hibernate 配置文件:
<property name="connection.username">scott</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="myeclipse.connection.profile">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.password">tiger</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="show_sql">true</property>
sequence :
<id name="powid" type="java.lang.Long">
<column name="POWID" precision="22" scale="0" />
<generator class="sequence"></generator>
</id>异常:
严重: Servlet.service() for servlet default threw exception
org.hibernate.MappingException: Dialect does not support sequences
at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:531)
at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:93)
at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:152)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:182)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:805)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildS为什么会包这个异常 ???求助
<property name="connection.username">scott</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="myeclipse.connection.profile">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.password">tiger</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="show_sql">true</property>
sequence :
<id name="powid" type="java.lang.Long">
<column name="POWID" precision="22" scale="0" />
<generator class="sequence"></generator>
</id>异常:
严重: Servlet.service() for servlet default threw exception
org.hibernate.MappingException: Dialect does not support sequences
at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:531)
at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:93)
at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:152)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:182)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:805)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildS为什么会包这个异常 ???求助
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl </property>
明显是Oracle。<id name="powid" type="java.lang.Long">
<column name="POWID" precision="22" scale="0" />
<generator class="sequence"> </generator>
</id> 改成
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="native"></generator>
</id>
这个是对的
CREATE SEQUENCE seq_sid
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;个人觉得用native的最好的.他会根据你数据库的类型自己去做如果不行就手动添加一个sequence
<param name="squence_name"></param>
</generator>
你创建create sequence 了么?
顶留守,哈哈