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@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#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...