com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘hibernate.id_gen’ does

java後台所提示的錯誤：

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hibernate.id_gen' doesn't exist

 

11:26:56,984 ERROR JDBCExceptionReporter:101 - Unknown table 'hibernate_sequence' in field list

 

 

Junit4測試所提示錯誤：

org.hibernate.exception.SQLGrammarException: could not get next sequence value

 

出現這個問題是因為hibernate.cfg.xml的配置錯誤，我的錯誤是修改了mysql串連配置，而沒有修改hibernate方言

如：

 

        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>

        <property name="connection.url">jdbc:mysql://127.0.0.1:3306/hibernate</property>

        <property name="connection.username">root</property>

        <property name="connection.password">centre</property>

<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>