[bpmn2user]

what is correct? the org.hibernate.transaction.JBossTransactionManagerLookup?

?

org.hibernate.transaction.BTMTransactionManagerLookup , is correct if  Bitronix is used with Tomcat

[lucazamador]

Hi, did you found how properly configure bitronix? I followed the instructions to install it on tomcat without sucess http://communitymapbuilder.org/display/BTM/Tomcat

[bpmn2user]

What are the errors you see in the log file?

[lucazamador]

Sorry, here's the stacktrace http://pastebin.com/1v4Tmujq

I followed the instructions and the only changed made were to add the username and password into the resources.properties

// also tryed with the MySqlXADatasource

resource.ds.className=bitronix.tm.resource.jdbc.lrc.LrcXADataSource

resource.ds.uniqueName=jdbc/testDS1

resource.ds.minPoolSize=0

resource.ds.maxPoolSize=5

resource.ds.driverProperties.driverClassName=com.mysql.jdbc.Driver

resource.ds.driverProperties.url=jdbc:mysql://localhost/jbpm

resource.ds.driverProperties.user=testing

resource.ds.driverProperties.password=testing

But I can't see the registered datasource in the tomcat jndi manager.

[bpmn2user]

Your datasource is not registered in Tomat.

Also look into the documentation http://tomcat.apache.org/tomcat-6.0-doc/config/context.html

Have you modified the contents of context.xml to define the resource name (i.e jdbc/testDS1) for the web application (i.e, gwt-console-server)? or have you modified in  $CATALINA_BASE/conf/context.xml file where the Context element information will be loaded by all webapps?

What are the conents of context.xml?

[lucazamador]

Yes, the resource is defined inside the gwt-console-server/META-INF/context.xml. Previously I was using the now disabled datasource, but when I wanted to use Bitronix I had to change it. Maybe Bitronix isn't registering the datasources, right?

Thanks.

<Context debug="5" reloadable="true" crossContext="true"> 

   <!--Resource name="jdbc/testDS1"

    auth="Container" 

    type="javax.sql.DataSource"

    username="testing"

    password="" 

    driverClassName="com.mysql.jdbc.Driver" 

    url="jdbc:mysql://localhost/jbpm"

    maxActive="8"

    maxIdle="4"/-->

     <Resource name="jdbc/testDS1" auth="Container" type="javax.sql.DataSource"

        factory="bitronix.tm.resource.ResourceObjectFactory" uniqueName="jdbc/testDS1" />

</Context> 

[bpmn2user]

If you modify the context.xml at Tomcat level ($CATALINA_BASE/conf/context.xml), then you do not need to modify gwt-console-server's context.xml.

Modify the context.xml in Tomcat's conf directory

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

    <Resource name="jdbc/testDS1" auth="Container" type="javax.sql.DataSource"
               maxActive="15" maxIdle="2" maxWait="10000"
logAbandoned="true"
               username="testing" password=""
driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost/jbpm"/>

If you define the username etc in context.xml, you can delete them from resources.properties.

Make sure if you include mysql jar file in Tomcat's lib directory

[bpmn2user]

Here are the sample configuration files (resources.properties and context.xml) for your example. They need to be in TOMCAT_HOME/conf directory.

Also, you might want to have a simple test jsp to make sure the datasource is bound properly. Attached also a sample test jsp file.

[amichal]

Can you create full description how to create jBPM5 with Tomcat6?

[bpmn2user]

The main steps are discussed here and again the integration depends on the transaction manager and database you choose.

If you like, I can provide a sample  description using Bitronix transaction manager and h2 database. Then you can extend it for the transaction manager/database you choose.

[bpmn2user]

Here is the full description using, JBPM5, H2 and Bitronix.

http://community.jboss.org/people/bpmn2user/blog/2011/01/21/test

[aminmc]

Thanks for the article.  I have followed it to the letter however I have an issue in that I cannot see any process definitions in the console or when i invoke the REST API to get all process definitions. I know that I am connecting to the right database as I have used the testJNDI.jsp.  In the tomcat logs I can see a log statement stating loading "xyx.bpmn" but I can't see anything in the console.  Also when I look at the logs in the console I can see "0 process definitions loaded in 12ms".  I have set the jbpm directory in the catalina file.  Any  help would be appreciated,

[bpmn2user]

Are you sure it is not getting into 'timeout' issue as described in http://community.jboss.org/message/587133#587133?

[aminmc]

Hi

Thanks for your reply.  Interestingly I have guvnor running as well in my tomcat which doesn't have the process definitions.  I am specifying it using the  jbpm.console.directory but I'm guessing that the guvnor location is being used instead.  I'll remove guvnor and give it a go.

Thanks

[aminmc]

Hi

Apologies for this long running thread about JBPM console.  I followed the steps you mentioned and used the two classes mentioned in another thread.  I added log statements to see what was happening.  Firstly in the CommandDelegate I added a log statement to select all ProcessInstanceInfo which returns results. However when I look in the console I cannot see anything.  In the log section of the console I can see "0 process instances returned in 0ms". Secondly I notice in the tomcat logs that a call is made to load the image of the process definition however it's making a request to Guvnor to get the image.  I feel so close to getting this work..

Cheers