[teiid-issues] [JBoss JIRA] (TEIID-3031) Database Logging: Problems with Oracle

Database Logging: Problems with Oracle -------------------------------------- Key: TEIID-3031 URL: https://issues.jboss.org/browse/TEIID-3031 Project: Teiid Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: 8.7.1 Reporter: Van Halbert Assignee: Steven Hawkins Installed the teiid extension: database logging to use oracle, and get the following exception at startup: Unable to build EntityManagerFactory at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:103) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_55] at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] Caused by: javax.persistence.PersistenceException: [PersistenceUnit: teiid-logger] Unable to build EntityManagerFactory at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:924) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899) at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:76) at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:200) at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.access$600(PersistenceUnitServiceImpl.java:57) at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:99) ... 4 more Caused by: org.hibernate.MappingException: org.hibernate.dialect.Oracle10gDialect does not support identity key generation at org.hibernate.dialect.Dialect.getIdentityColumnString(Dialect.java:772) at org.hibernate.dialect.Dialect.getIdentityColumnString(Dialect.java:762) at org.hibernate.mapping.Table.sqlCreateString(Table.java:505) at org.hibernate.cfg.Configuration.generateSchemaCreationScript(Configuration.java:1038) at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:125) at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:504) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1797) at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914) ... 9 more