hibernate_sequence lookup error ------------------------------- Key: HHH-5581 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5581 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.5 Environment: JBoss-6.0.0-SNAPSHOT (current svn checkout), Informix 11.5 Database, SUN JDK 1.6.0_21 Reporter: Frank Langelage On startup of JBossAS I see this in the boot.log file: 17:53:43,896 INFO [DatabaseMetadata] table not found: hibernate_sequence 17:53:43,898 ERROR [SchemaUpdate] could not complete schema update: org.hibernate.MappingException: Dialect does not support pooled sequences at org.hibernate.dialect.Dialect.getCreateSequenceString(Dialect.java:734) [:3.5.5-Final] at org.hibernate.dialect.Dialect.getCreateSequenceStrings(Dialect.java:692) [:3.5.5-Final] at org.hibernate.id.enhanced.SequenceStructure.sqlCreateStrings(SequenceStructure.java:156) [:3.5.5-Final] at org.hibernate.id.enhanced.SequenceStyleGenerator.sqlCreateStrings(SequenceStyleGenerator.java:363) [:3.5.5-Final] at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:1142) [:3.5.5-Final] at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:187) [:3.5.5-Final] at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:386) [:3.5.5-Final] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385) [:3.5.5-Final] at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954) [:3.5.5-Final] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:891) [:3.5.5-Final] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74) [:3.5.5-Final] at org.jboss.jpa.builder.DefaultCEMFBuilder.build(DefaultCEMFBuilder.java:47) [:1.0.2-alpha-1] at org.jboss.as.jpa.scanner.HackCEMFBuilder.build(HackCEMFBuilder.java:49) [:6.0.0-SNAPSHOT] at org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:275) [:1.0.2-alpha-1] I created the sequence manually but during next startup the same error message. I enabled the logging of database statements and found this: QUERY: (OPTIMIZATION TIMESTAMP: 09-19-2010 17:53:43) ------ select tabname, tabtype, owner, tabid from jboss6:informix.systables where tabtype in ('T','V') and tabname like 'hibernate_sequence' and owner like '%' Estimated Cost: 10 Estimated # of Rows Returned: 3 1) informix.systables: SEQUENTIAL SCAN Filters: ((informix.systables.tabtype IN ('T' , 'V' )AND informix.systables.tabname LIKE 'hibernate_sequence' ) AND informix.systables.owner LIKE '%' ) Hibernate is looking for a table or view named "hibernate_sequence" and not for a sequence of this name.

hibernate_sequence lookup error ------------------------------- Key: HHH-5581 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5581 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.5 Environment: JBoss-6.0.0-SNAPSHOT (current svn checkout), Informix 11.5 Database, SUN JDK 1.6.0_21 Reporter: Frank Langelage Attachments: InformixDialect.java, InformixDialect.java.diff On startup of JBossAS I see this in the boot.log file: 17:53:43,896 INFO [DatabaseMetadata] table not found: hibernate_sequence 17:53:43,898 ERROR [SchemaUpdate] could not complete schema update: org.hibernate.MappingException: Dialect does not support pooled sequences at org.hibernate.dialect.Dialect.getCreateSequenceString(Dialect.java:734) [:3.5.5-Final] at org.hibernate.dialect.Dialect.getCreateSequenceStrings(Dialect.java:692) [:3.5.5-Final] at org.hibernate.id.enhanced.SequenceStructure.sqlCreateStrings(SequenceStructure.java:156) [:3.5.5-Final] at org.hibernate.id.enhanced.SequenceStyleGenerator.sqlCreateStrings(SequenceStyleGenerator.java:363) [:3.5.5-Final] at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:1142) [:3.5.5-Final] at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:187) [:3.5.5-Final] at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:386) [:3.5.5-Final] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385) [:3.5.5-Final] at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954) [:3.5.5-Final] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:891) [:3.5.5-Final] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74) [:3.5.5-Final] at org.jboss.jpa.builder.DefaultCEMFBuilder.build(DefaultCEMFBuilder.java:47) [:1.0.2-alpha-1] at org.jboss.as.jpa.scanner.HackCEMFBuilder.build(HackCEMFBuilder.java:49) [:6.0.0-SNAPSHOT] at org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:275) [:1.0.2-alpha-1] I created the sequence manually but during next startup the same error message. I enabled the logging of database statements and found this: QUERY: (OPTIMIZATION TIMESTAMP: 09-19-2010 17:53:43) ------ select tabname, tabtype, owner, tabid from jboss6:informix.systables where tabtype in ('T','V') and tabname like 'hibernate_sequence' and owner like '%' Estimated Cost: 10 Estimated # of Rows Returned: 3 1) informix.systables: SEQUENTIAL SCAN Filters: ((informix.systables.tabtype IN ('T' , 'V' )AND informix.systables.tabname LIKE 'hibernate_sequence' ) AND informix.systables.owner LIKE '%' ) Hibernate is looking for a table or view named "hibernate_sequence" and not for a sequence of this name.

Improve InformixDialect sequence support ---------------------------------------- Key: HHH-5581 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5581 Project: Hibernate Core Issue Type: Patch Components: core Affects Versions: 3.5.5 Environment: JBoss-6.0.0-SNAPSHOT (current svn checkout), Informix 11.5 Database, SUN JDK 1.6.0_21 Reporter: Frank Langelage Assignee: Steve Ebersole Fix For: 3.6.0.CR2 Attachments: InformixDialect.java, InformixDialect.java.diff Time Spent: 2m Remaining Estimate: 0h On startup of JBossAS I see this in the boot.log file: 17:53:43,896 INFO [DatabaseMetadata] table not found: hibernate_sequence 17:53:43,898 ERROR [SchemaUpdate] could not complete schema update: org.hibernate.MappingException: Dialect does not support pooled sequences at org.hibernate.dialect.Dialect.getCreateSequenceString(Dialect.java:734) [:3.5.5-Final] at org.hibernate.dialect.Dialect.getCreateSequenceStrings(Dialect.java:692) [:3.5.5-Final] at org.hibernate.id.enhanced.SequenceStructure.sqlCreateStrings(SequenceStructure.java:156) [:3.5.5-Final] at org.hibernate.id.enhanced.SequenceStyleGenerator.sqlCreateStrings(SequenceStyleGenerator.java:363) [:3.5.5-Final] at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:1142) [:3.5.5-Final] at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:187) [:3.5.5-Final] at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:386) [:3.5.5-Final] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385) [:3.5.5-Final] at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954) [:3.5.5-Final] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:891) [:3.5.5-Final] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74) [:3.5.5-Final] at org.jboss.jpa.builder.DefaultCEMFBuilder.build(DefaultCEMFBuilder.java:47) [:1.0.2-alpha-1] at org.jboss.as.jpa.scanner.HackCEMFBuilder.build(HackCEMFBuilder.java:49) [:6.0.0-SNAPSHOT] at org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:275) [:1.0.2-alpha-1] I created the sequence manually but during next startup the same error message. I enabled the logging of database statements and found this: QUERY: (OPTIMIZATION TIMESTAMP: 09-19-2010 17:53:43) ------ select tabname, tabtype, owner, tabid from jboss6:informix.systables where tabtype in ('T','V') and tabname like 'hibernate_sequence' and owner like '%' Estimated Cost: 10 Estimated # of Rows Returned: 3 1) informix.systables: SEQUENTIAL SCAN Filters: ((informix.systables.tabtype IN ('T' , 'V' )AND informix.systables.tabname LIKE 'hibernate_sequence' ) AND informix.systables.owner LIKE '%' ) Hibernate is looking for a table or view named "hibernate_sequence" and not for a sequence of this name.