[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-5581) Improve InformixDialect sequence support

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-5581.
-------------------------------

    Resolution: Fixed

> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira