[jboss-user] [JBoss Seam] - Datasource problem with seam and jbpm

[Strategy]

Hi all,

I´m using Seam together with jBPM.
jBPM integration worked, so i changed the database to mysql. I created a new database exclusive for jBPM entries. 
But I´m also using another database, containing my application-based data. Using the application based database works fine, until i start my first buisness-process. Afterwards I get an exception.

Here´s my ds.xml:



  | <datasources>
  |    
  |    <local-tx-datasource>
  |       <jndi-name>jboss_seamDatasource</jndi-name>
  |       <connection-url>jdbc:mysql://localhost/jboss</connection-url>
  |       <driver-class>com.mysql.jdbc.Driver</driver-class>
  |       <user-name>jboss</user-name>
  |       <password>jboss</password>
  |    </local-tx-datasource>
  |     
  |     <local-tx-datasource>
  |     <jndi-name>JbpmDS</jndi-name>
  |     <connection-url>jdbc:mysql://localhost/jbpm</connection-url>
  |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |     <user-name>root</user-name>
  |     <password></password>
  |     <metadata>
  |       <type-mapping>MySQL</type-mapping>
  |     </metadata>
  |   </local-tx-datasource>
  |     
  |     
  | </datasources>
  | 


and here is  the error that occures:



  | 11:45:04,723 WARN  [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 6d5eaf
  | 11:45:04,756 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
  | 11:45:04,757 ERROR [JDBCExceptionReporter] 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: -3f57fde1:c9aa:4768f43c:7a 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: -3f57fde1:c9aa:4768f43c:7a status: ActionStatus.ABORT_ONLY >))
  | 12:39:42,507 ERROR [SeamPhaseListener] uncaught exception
  | 

Any usefull ideas ??

Thanks a lot,
  Matthias

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4114163#4114163

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4114163