[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2472) Error in HSQLDB Sequence Syntax

Error in HSQLDB Sequence Syntax ------------------------------- Key: HHH-2472 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2472 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.2 Reporter: Aaron Mulder I am using Hibernate via JPA. My persistence.xml has this: <provider>org.hibernate.ejb.HibernatePersistence</provider> <properties> <property name="hibernate.show_sql" value="true"/> <property name="hibernate.format_sql" value="true"/> <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/> </properties> My Entity has this: @SequenceGenerator(name = "GeneratePCSequence", sequenceName = "GEN_PC_SEQUENCE") ... @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "GeneratePCSequence") private int id; My DDL has this: create sequence GEN_PC_SEQUENCE start with 100000 increment by 1; The result I get when creating a new entity of this type is this: java.sql.SQLException: Table not found in statement [select next value for GEN_PC_SEQUENCE from dual_GEN_PC_SEQUENCE] org.hsqldb.jdbc.Util.throwError(Unknown Source) org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185) org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278) org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497) org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:123) org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:73) org.hibernate.id.SequenceHiLoGenerator.generate(SequenceHiLoGenerator.java:58) org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99) org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131) org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87) org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38) org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618) org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592) org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596) org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:212) The "from dual_GEN_PC_SEQUENCE" looks sketchy to me, but I'm not real sure.