5 Replies Latest reply on Jun 3, 2014 1:21 AM by Maciej Swiderski

    JBPM6-Per process instance strategy in websphere application server 7

    Venkata Prasad Newbie

      Hi,

      I'm trying to implement per process instance strategy in my application which uses JBPM 6. I use Bitronix transaction manager and use spring configuration to set it.

       

      Though i was able to successfully configure and test in Tomcat, i'm not successful in Web Sphere application server 7.0  The error i get

       

      Hibernate: select contextmap0_.mappingId as mappingI1_4_, contextmap0_.CONTEXT_ID as CONTEXT2_4_, contextmap0_.KSESSION_ID as KSESSION3_4_, contextmap0_.OPTLOCK as OPTLOCK4_4_ from ContextMappingInfo contextmap0_ where (contextId=? )

      16:28:26.516 [http-bio-8080-exec-1] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 904, SQLState: 42000

      16:28:26.516 [http-bio-8080-exec-1] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - ORA-00904: "CONTEXTID": invalid identifier

       

       

      It is very clear from the log is JBPM try to query the "contextmappinginfo" with invalid column name "contextid".

       

      This error does not seem to occur when application deployed in tomcat server.

       

      In CONTEXT.XML of tomcat, Include the line

      <Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory"/>

       

      where as not sure is there any corresponding change to be done when deploying in Web Sphere.

       

      Transaction manager configuration in root-context.xml:

      <bean id="bitronixTransactionManagerConfig" factory-method="getConfiguration" class="bitronix.tm.TransactionManagerServices"  >
      </bean>
      <bean id="bitronixTransactionManager" factory-method="getTransactionManager"
      class="bitronix.tm.TransactionManagerServices" depends-on="bitronixTransactionManagerConfig" destroy-method="shutdown" />

       

         <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager" autowire="constructor">

       

       

      <property name="transactionManager" ref="bitronixTransactionManager" />
      <property name="userTransaction" ref="bitronixTransactionManager" />

       

      </bean>

       

      From my persistence.xml file:

       

      <property name="hibernate.transaction.manager_lookup_class"

        value="org.hibernate.transaction.BTMTransactionManagerLookup" />

       

       

      Please let me know why JBPM is querying with invalid column name