Gavin,
Thanks for pointing me in the right direction (I would have never figured this out
otherwise)..
For anyone else out there with the same problem.. I solved it by changing
local-tx-datasource to xa-datasource in DataSource-dev.xml
example:
| <xa-datasource>
| <jndi-name>MainDatasource</jndi-name>
|
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
| <xa-datasource-property
name="URL">jdbc:mysql://xxx.xxx.xx</xa-datasource-property>
|
| <user-name>xxxxxxxx</user-name>
| <password>xxxxxxxx</password>
|
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
|
| <!-- This disables transaction interleaving (which BTW, most DB vendors
don't support) -->
| <track-connection-by-tx/>
| <isSameRM-override-value>false</isSameRM-override-value>
|
| <!--pooling parameters-->
| <min-pool-size>5</min-pool-size>
| <max-pool-size>20</max-pool-size>
| <blocking-timeout-millis>5000</blocking-timeout-millis>
| <idle-timeout-minutes>15</idle-timeout-minutes>
|
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
| <metadata>
| <type-mapping>mySQL</type-mapping>
| </metadata>
| </xa-datasource>
|
|
-Dustin
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4059324#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...