[jboss-user] [jBPM] - Re: JBPM v5 & MySQL Persistence Problem

[David C]

David C [http://community.jboss.org/people/process15] created the discussion

"Re: JBPM v5 & MySQL Persistence Problem"

To view the discussion, visit: http://community.jboss.org/message/623055#623055

--------------------------------------------------------------
Thanks for the suggestions, Chris and Marco.

It seems the error is related to the Database connection or configuration.

This is the typical error Im getting

Aug 26, 2011 12:33:22 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
SEVERE: XAER_RMFAIL: The command cannot be executed when global transaction is in the  ACTIVE state

I'm having little success in tracking down a solution from goggle.

BTW, I'm using  bitronix for TX

import bitronix.tm.TransactionManagerServices;
import bitronix.tm.resource.jdbc.PoolingDataSource;

|  |  |  | UserTransaction ut = (UserTransaction) new InitialContext().lookup("java:comp/UserTransaction"); |
|  |  |  | ut.begin(); |

|  |  |  | PoolingDataSource ds1 = new PoolingDataSource(); |


|  |  |  | ds1 = new PoolingDataSource(); |
|  |  |  | ds1.setUniqueName("jdbc/testDS1"); |
|  |  |  | ds1.setClassName("com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"); |

|  |  |  | ds1.setMaxPoolSize(3); |
|  |  |  | ds1.setAllowLocalTransactions(true); |
|  |  |  | ds1.getDriverProperties().put("user", "test1"); |
|  |  |  | ds1.getDriverProperties().put("password", "test1"); |
|  |  |  | ds1.getDriverProperties().put("URL","jdbc:mysql://localhost:3306/jbpm5db"); |

|  |  |  | ds1.init(); |
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/623055#623055]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110825/c7f35927/attachment-0001.html