I am trying to get jBPM running on MSSQL. I created my MSSQL DB using the jbpm.jpdl.mssql.sql script that came with the installation. I setup a datasource based on this guide. http://www.jboss.org/community/docs/DOC-12242 I have tried MS JDBC and jTDS with the same results. I am trying to run the Web Sale example. I get the following exceptions when it hits the timer associated with the evaluate web order task node.
Is there any further data setup that is necessary beyond the SQL script provided with the installation? Has anyone else seen this or know of a guide on how to get jBPM running on MSSQL? 2009-03-11 12:56:29,037 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.TimerEntityBean#findByPrimaryKey] Executing SQL: SELECT t0_TimerEntityBean.ID_ FROM JBPM_JOB t0_TimerEntityBean WHERE t0_TimerEntityBean.ID_=? 2009-03-11 12:56:29,037 WARN [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] Adding multiple last resources is disallowed. Current resource is org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@672bb3 2009-03-11 12:56:29,067 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true 2009-03-11 12:56:29,067 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false 2009-03-11 12:56:29,067 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true 2009-03-11 12:56:29,067 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.TimerEntityBean#findByPrimaryKey] Find failed org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a226452:ab8:49b7ec92:5f status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a226452:ab8:49b7ec92:5f status: ActionStatus.ABORT_ONLY >)) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:225) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:144) at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.execute(JDBCFindByPrimaryKeyQuery.java:155) at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:61) ... lots more ... for reference -- jdk-6u12-windows-i586-p.exe jboss-4.2.3.GA-jdk6.zip jbpm-installer-3.3.1.GA.jar MSSQL 2005 Also, for what it's worth, if I remove the timer I can run through all the nodes. However it then throws out a lot of exceptions on the console after I finish the last step where you enter a payment id. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4217086#4217086 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4217086 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user