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#4059324

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4059324
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to