This involves using JBOSS 4.2.3 GA, Spring 2.5 and SQLServer 2000 XA jdbc driver.
I created a file pxdatasource-xa-ds.xml file in the deploy folder with the following
definition-
<xa-datasource>
<jndi-name>pxDS</jndi-name>
<track-connection-by-tx>True</track-connection-by-tx>
<connection-url>jdbc:microsoft:sqlserver://SQLTEST1;SelectMethod=cursor;databasename=App_Dev</connection-url>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
<min-pool-size>1</min-pool-size>
<max-pool-size>20</max-pool-size>
<new-connection-sql>select 1 from systypes</new-connection-sql>
<check-valid-connection-sql>select 1 from
systypes</check-valid-connection-sql>
</xa-datasource>
JBOSS is using org.jboss.resource.adapter.jdbc.WrapperDataSource class for this look up.
If the object is assigned to object of type Datasource, there is no problem. But if it is
assigned to the type XADatasource there is an exception.
So even though I am defining a datasource that supports XA i.e. implements XADatasource
the object that is returned to me somehow is of the type Datasource.
How do I tell JBOSS that I need the looked up object to be XADatasource?
Thanks.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4184498#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...