jBPM 7 and Oracle Not Working

[Lorenzo Ciaravola]

hi,

I have set up and install jBPM 7 to use Oracle database but it doesn't seem to work. The KIE workbench starts up and I can login but when trying to access the Task or Process Instances pages, I get the following exception:

"Unable to complete your request. The following exception occurred: Can't lookup on specified data set: jbpmHumanTasksWithUser."

The strange thing is that no tables are created in the Oracle database during installation (I did not run the SQL script manually).

Also, the log file has an exception that seems to refer to H2:

2017-07-10 09:28:23,660 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 75) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2017-07-10 09:28:23,667 WARN  [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 75) HHH000431: Unable to determine H2 database version, certain features may not work

2017-07-10 09:28:27,121 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 75) SQL Error: 936, SQLState: 42000

2017-07-10 09:28:27,122 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 75) ORA-00936: missing expression

2017-07-10 09:28:27,127 ERROR [org.kie.server.services.impl.KieServerImpl] (ServerService Thread Pool -- 75) Error when initializing server extension of type jBPM KIE Server extension: java.lang.RuntimeException: Unable to create EntityManagerFactory due to [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory

at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:701)

at org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:186)

 ... more

Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:953)

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:883)

at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:135)

at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:699)

... 24 more

Caused by: org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation

at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

... 26 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

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

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

... 32 more

 I am pretty confident I have configured Oracle properly as below:

In build.properties:

db.name=oracle

db.driver.module.prefix=com/oracle

db.driver.jar.name=ojdbc6.jar

(and commented out the H2 entries)

In jbpm-persistence-JPA2.xml:

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

In standalone-full-wildfly-10.1.0.Final.xml:

          <datasource pool-name='OracleDS' use-java-context='true' use-ccm='true' enabled='true' jta='true' jndi-name='java:jboss/datasources/jbpmDS'>

                    <connection-url>jdbc:oracle:thin:@<HOST>:<PORT>:<SID></connection-url>

                    <driver>oracle</driver>

                    <security>

                        <user-name>username</user-name>

<password>password</password>

                    </security>

                </datasource>

                <drivers>

                    <driver name="oracle" module="com.oracle"></driver>

                </drivers>

[Abhijit Humbe]

try to pass DB details using below option:

org.kie.server.persistence.ds --> JNDI name of datasource
org.kie.server.persistence.dialect--> Oracle dialect

Abhijit Humbe

--
You received this message because you are subscribed to the Google Groups "jBPM Setup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+unsubscribe@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/bb197816-e758-47fe-8f55-00544b61dfbe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Lorenzo Ciaravola]

Hi Abhijit,

Thanks a lot. I have done as you suggested and had some progress. The Oracle tables are being created now, no references anymore to the H2 dialect.

Putting aside for a moment that I don't understand why I am supposed to pass those details manually since the jBPM installation manual doesn't say anything about that, I am still facing the same exception when trying to access the Task or Process Instances pages, I get the following exception:

"Unable to complete your request. The following exception occurred: Can't lookup on specified data set: jbpmHumanTasksWithUser."

In the log file, I see the following exception during jBoss startup/jBPM deployment:

"Unable to register query definition on 'default-kieserver@localhost:8080' due to Server that this client is connected to has no capabilities to handle QueryServicesClient"

Any idea?

Thanks

Abhijit Humbe

To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+...@googlegroups.com.

[Lorenzo Ciaravola]

I might have solved my problem with the aforementioned exception.

When you told me to use the persistence options, I added org.kie.server.persistence.ds although it was already there (org.kie.server.persistence.dialect wasn't). But I added it with a wrong JNDI name of datasource, jboss/datasources/jbpmDS instead of java:jboss/datasources/jbpmDS