[jboss-user] [JBoss Seam] - Re: Problems using multiple datasources

[dustismo]

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