3 Replies Latest reply on Sep 6, 2013 6:29 AM by Maciej Swiderski

    jBPM6 + Oracle gives ORA-02014 error

    Gaetano Mazzeo Newbie

      Hi,

      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

       

      Anyone used jBPM6 + Oracle with success? Any idea how to resolve?

       

      Thanks in advance.

      Cheers.