[jboss-user] [JCA/JBoss] - Problem looking up XADatasource - Always returns Datasource

pradeeps do-not-reply at jboss.com
Mon Oct 27 08:05:58 EDT 2008


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=4184818#4184818

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4184818



More information about the jboss-user mailing list