jpa 小问题

 

JPA:unknown Oracle major version [11] 的错误处理方法

org.hibernate.HibernateException: unknown Oracle major version [11]

添加 ：
<property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>

 

 

 

jpa中主键使用oracle序列

实体类配置

@Id
 @GeneratedValue(strategy=GenerationType.SEQUENCE,generator="mseq")
 @SequenceGenerator(name="mseq",sequenceName="metadata_seq",allocationSize=1)
 @Column(name = "ENTID", unique = true, nullable = false, precision = 22, scale = 0)
 public long getEntid() {
  return this.entid;
 }

sequenceName 是自己

 

 

JPA中oracle生成主键方式

当标识实体的主键为 @GeneratedValue 的时候，需要在oracle中创建一个序列：

CREATE SEQUENCE HIBERNATE_SEQUENCE   MINVALUE 1 MAXVALUE 9999999999999999

否则会有：

Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not get next sequence value
 at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(Abst