• Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: jBPM 6.0.0.CR2
    • Fix Version/s: jBPM 6.0.0.CR4
    • Component/s: Console
    • Labels:


      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:


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

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

      <property name="" 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="" value="false" />



      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) 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

        Gliffy Diagrams




              • Assignee:
                swiderski.maciej Maciej Swiderski
                madmaz Gaetano Mazzeo
              • Votes:
                0 Vote for this issue
                3 Start watching this issue


                • Created: