为什么会提示oracle方言不支持sequence

Question

最近把系统从mysql转到oracle以后，主键的问题始终没有解决，修改注释后的实体代码：@Entity
@Table(name = "itsc_user_info")
public class ItscUserInfo implements Serializable {    private static final long serialVersionUID = 1L;    public static final String PROPERTY_USER_NAME = "userName";    public static final String PROPERTY_USER_ROLEID = "roleInfo.roleId";    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator="itsc_user_generator")
    @SequenceGenerator(name="itsc_user_generator", sequenceName="itsc_user_generator")
    @Column(name = "user_id")
    private Integer userId;用的数据库是oracle 10g express，驱动是自带的ojdbc14.jar，结果，系统启动，出来的错误提示叫人难以相信Caused by: org.hibernate.MappingException: could not instantiate id generator
        at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:98)
        at org.hibernate.mapping.SimpleValue.createIdentifierGenerator(SimpleValue.java:152)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:192)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:753)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:691)
        at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1390)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1359)
        ... 47 more
Caused by: org.hibernate.MappingException: Dialect does not support sequences
        at org.hibernate.dialect.Dialect.getSequenceNextValString(Dialect.java:596)
        at org.hibernate.id.SequenceGenerator.configure(SequenceGenerator.java:65)
        at org.hibernate.id.SequenceHiLoGenerator.configure(SequenceHiLoGenerator.java:43)
        at org.hibernate.id.IdentifierGeneratorFactory.create(IdentifierGeneratorFactory.java:94)说我的数据库方言不支持sequence，而我配置的数据库信息：jdbc.dialect = org.hibernate.dialect.OracleDialect
jdbc.driverClassName = oracle.jdbc.driver.OracleDriver
jdbc.url = jdbc:oracle:thin:@localhost:1521:xe
jdbc.username = system
jdbc.password = 123456
jdbc.showSql = true
jdbc.generateDdl = false
不知道哪里出了问题？

Answer 1

按理说应该不可能的，你把方言改为这个类：org.hibernate.dialect.Oracle10gDialectOracle JDBC 驱动改为这个类：oracle.jdbc.OracleDriver看样子你是用 Spring 管理的，把 Spring 中涉及 DataSource 什么的配置贴出来看一下。

Answer 2

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

Answer 3

好久没碰过Hibernate,全忘了，惭愧

Answer 4

好久没碰过Hibernate,全忘了，惭愧

Answer 5

可以肯定的是支持sequence方式。但详细的问题我还不够资格来查找

Answer 6

对不住大家，我犯了一个低级错误，bao110908刚才提醒我了，看了下我的sessionFactory配置：
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
        <property name="annotatedClasses">
            <list>
                <value>com.aaron.platform.entity.ItscRoleInfo</value>
                <value>com.aaron.platform.entity.ItscUserInfo</value>
                <value>com.aaron.platform.entity.ItscRolePrivileges</value>
                <value>com.aaron.platform.entity.ItscDomainInfo</value>
                <!--<value>com.aaron.platform.entity.FgysContract</value>
                <value>com.aaron.platform.entity.FgysEnterprise</value>
                <value>com.aaron.platform.entity.FgysLogicalSite</value>
                <value>com.aaron.platform.entity.FgysOrderInfo</value>
                <value>com.aaron.platform.entity.FgysPayment</value>
                <value>com.aaron.platform.entity.FgysPhysicalSite</value>
                <value>com.aaron.platform.entity.FgysProject</value>-->
            </list>
        </property>
    </bean>
原来里面把hibernate.dialect写死了，一直在用mysql的方言，太晕了，感谢大家，呵呵！