[jboss-user] [JBoss jBPM] - MSSQL Exceptions

robro99 do-not-reply at jboss.com
Wed Mar 11 13:15:33 EDT 2009


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$LocalXAResource at 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



More information about the jboss-user mailing list