I need to use jBPM 6 with Oracle.

So I added the Oracle driver as module, modified the standalone.xml to have the Oracle datasource and finally I modified the persistence.xml in order to make jBPM 6 work with Oracle as follow:

<properties>

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

<property name="hibernate.max_fetch_depth" value="3"/>

<property name="hibernate.hbm2ddl.auto" value="update" />

<property name="hibernate.show_sql" value="true" />

<property name="hibernate.format_sql" value="true" />

<property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" />

<!-- BZ 841786: AS7/EAP 6/Hib 4 uses new (sequence) generators which seem to cause problems -->

<property name="hibernate.id.new_generator_mappings" value="false" />

</properties>

</persistence-unit>

All seemed ok at first, until I added some process definition and then the following error continuosly appeared in the log:

18:41:27,763 INFO [stdout] (pool-16-thread-1) Hibernate:

18:41:27,771 INFO [stdout] (pool-16-thread-1) select

18:41:27,777 INFO [stdout] (pool-16-thread-1) *

18:41:27,783 INFO [stdout] (pool-16-thread-1) from

18:41:27,789 INFO [stdout] (pool-16-thread-1) ( select

18:41:27,801 INFO [stdout] (pool-16-thread-1) requestinf0_.id as id14_,

18:41:27,816 INFO [stdout] (pool-16-thread-1) requestinf0_.commandName as commandN2_14_,

18:41:27,829 INFO [stdout] (pool-16-thread-1) requestinf0_.deploymentId as deployme3_14_,

18:41:27,840 INFO [stdout] (pool-16-thread-1) requestinf0_.executions as executions14_,

18:41:27,852 INFO [stdout] (pool-16-thread-1) requestinf0_.businessKey as business5_14_,

18:41:27,863 INFO [stdout] (pool-16-thread-1) requestinf0_.message as message14_,

18:41:27,873 INFO [stdout] (pool-16-thread-1) requestinf0_.requestData as requestD7_14_,

18:41:27,883 INFO [stdout] (pool-16-thread-1) requestinf0_.responseData as response8_14_,

18:41:27,893 INFO [stdout] (pool-16-thread-1) requestinf0_.retries as retries14_,

18:41:27,903 INFO [stdout] (pool-16-thread-1) requestinf0_.status as status14_,

18:41:27,912 INFO [stdout] (pool-16-thread-1) requestinf0_.timestamp as timestamp14_

18:41:27,922 INFO [stdout] (pool-16-thread-1) from

18:41:27,928 INFO [stdout] (pool-16-thread-1) RequestInfo requestinf0_

18:41:27,937 INFO [stdout] (pool-16-thread-1) where

18:41:27,943 INFO [stdout] (pool-16-thread-1) (

18:41:27,949 INFO [stdout] (pool-16-thread-1) requestinf0_.status='QUEUED'

18:41:27,959 INFO [stdout] (pool-16-thread-1) or requestinf0_.status='RETRYING'

18:41:27,972 INFO [stdout] (pool-16-thread-1) )

18:41:27,979 INFO [stdout] (pool-16-thread-1) and requestinf0_.timestamp<?

18:41:27,987 INFO [stdout] (pool-16-thread-1) order by

18:41:27,989 INFO [stdout] (pool-16-thread-1) requestinf0_.timestamp DESC )

18:41:27,994 INFO [stdout] (pool-16-thread-1) where

18:41:27,996 INFO [stdout] (pool-16-thread-1) rownum <= ? for update

18:41:28,000 INFO [stdout] (pool-16-thread-1)

18:41:28,010 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-16-thread-1) SQL Error: 2014, SQLState: 42000

18:41:28,016 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (pool-16-thread-1) ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

18:41:28,025 INFO [org.hibernate.engine.jdbc.internal.LogicalConnectionImpl] (pool-16-thread-1) HHH000106: Forcing container resource cleanup on transaction completion