org.hibernate.MappingException: Dialect does not support pooled sequences

Hibernate JIRA | Frank Langelage | 6 years ago
  1. 0

    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 JIRA | 6 years ago | Frank Langelage
    org.hibernate.MappingException: Dialect does not support pooled sequences
  2. 0

    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 JIRA | 6 years ago | Frank Langelage
    org.hibernate.MappingException: Dialect does not support pooled sequences
  3. 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    org.hibernate.MappingException: Association references unmapped class

    Stack Overflow | 5 years ago | Tapas Bose
    org.hibernate.MappingException: Association references unmapped class: info.domain.User
  6. 0

    JTrac / Discussion / Help:Running under PostgreSQL

    sourceforge.net | 11 months ago
    org.hibernate.MappingException: No Dialect mapping for JDBC type: 2005

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.MappingException

      Dialect does not support pooled sequences

      at org.hibernate.dialect.Dialect.getCreateSequenceString()
    2. Hibernate
      SchemaUpdate.execute
      1. org.hibernate.dialect.Dialect.getCreateSequenceString(Dialect.java:734)[:3.5.5-Final]
      2. org.hibernate.dialect.Dialect.getCreateSequenceStrings(Dialect.java:692)[:3.5.5-Final]
      3. org.hibernate.id.enhanced.SequenceStructure.sqlCreateStrings(SequenceStructure.java:156)[:3.5.5-Final]
      4. org.hibernate.id.enhanced.SequenceStyleGenerator.sqlCreateStrings(SequenceStyleGenerator.java:363)[:3.5.5-Final]
      5. org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:1142)[:3.5.5-Final]
      6. org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:187)[:3.5.5-Final]
      6 frames
    3. Hibernate
      SessionFactoryImpl.<init>
      1. org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:386)[:3.5.5-Final]
      1 frame
    4. Hibernate
      AnnotationConfiguration.buildSessionFactory
      1. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)[:3.5.5-Final]
      2. org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)[:3.5.5-Final]
      2 frames
    5. Hibernate EJB
      HibernatePersistence.createContainerEntityManagerFactory
      1. org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:891)[:3.5.5-Final]
      2. org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)[:3.5.5-Final]
      2 frames
    6. org.jboss.jpa
      DefaultCEMFBuilder.build
      1. org.jboss.jpa.builder.DefaultCEMFBuilder.build(DefaultCEMFBuilder.java:47)[:1.0.2-alpha-1]
      1 frame
    7. JBoss Application Server EJB3
      HackCEMFBuilder.build
      1. org.jboss.as.jpa.scanner.HackCEMFBuilder.build(HackCEMFBuilder.java:49)[:6.0.0-SNAPSHOT]
      1 frame
    8. org.jboss.jpa
      PersistenceUnitDeployment.start
      1. org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:275)[:1.0.2-alpha-1]
      1 frame