jBPM 6.4 + Oracle 12c

[maxandri...@gmail.com]

Hello,

I need to use jBPM 6.4 with Oracle 12 DB. When I start wildfly 8.2.1 I see a lot of errors related to the interction with oracle DB 

16-05-19 10:26:53,191 INFO  [org.hibernate.ejb.Ejb3Configuration] (MSC service thread 1-6) HHH000204: Processing PersistenceUnitInfo [

name: org.jbpm.domain

...]

2016-05-19 10:26:53,914 INFO  [org.hibernate.dialect.Dialect] (MSC service thread 1-6) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2016-05-19 10:26:53,926 WARN  [org.hibernate.dialect.H2Dialect] (MSC service thread 1-6) HHH000431: Unable to determine H2 database version, certain features may not work

2016-05-19 10:26:54,231 INFO  [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (MSC service thread 1-6) HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jta.CMTTransactionFactory

2016-05-19 10:26:54,246 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (MSC service thread 1-6) HHH000397: Using ASTQueryTranslatorFactory

2016-05-19 10:26:54,630 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-6) HHH000228: Running hbm2ddl schema update

2016-05-19 10:26:54,636 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-6) HHH000102: Fetching database metadata

2016-05-19 10:26:54,652 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-6) HHH000319: Could not get database metadata: java.sql.SQLSyntaxErrorException: ORA-00942: table or view 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)

can you help me?

Thank you

[Rustam Usmanov]

See http://docs.jboss.org/jbpm/release/6.4.0.Final/jbpm-docs/html/ch03.html#d0e950
At least you need to specify correct dialect in persistence.xml.

[Massimiliano Andriotto]

thank you for your suggestion, I followed the installation guide and this:

http://prashantdevda.blogspot.it/2015/04/configure-oracle-11g-database-with-jbpm.html

[Abdu Chadili]

Hello,

I am using OracleXE, what jdb driver I should configure with jBPM and what's the name of the Hibernate dialect to use?

in

jbpm-persistence-JPA2.xml

<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle????????" />

Thanks

Abdu

[db...@seimcc.com]

Hello,

I am facing the same problem as you. I followed the same guide as you and i read the official documentation. But I can't understand what i am doing wrong....

Did you solve your problem? How do you do?