Configuring datasource in jboss4.2.2GA
mssql-xa-da.xml file
----------------------
<datasources>
<xa-datasource>
<jndi-name>mssqlxads</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlDataSource</xa-datasource-class>
<xa-datasource-property name="URL">
jdbc:mysql://localhost:3306/test</xa-datasource-property>
<!-- not sure if these should be here-->
<user-name>tester</user-name>
<password>tester</password>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
<metadata>
<type-mapping>MS SQLSERVER2000</type-mapping>
</metadata>
</xa-datasource>
</datasources>
JAVA FILE
---------
InitialContext ic = new InitialContext();
if(ic!=null){
DataSource ds = (DataSource)ic.lookup("java:/mssqlxads");
con = ds.getConnection();//
Exception from this line (ClassCastException com.mysql.jdbc.jdbc2.optional.MysqlDataSource) Can anyone help me.
Thanks.