Traduct a service file into ds

[eric_lemaitre]

Hi all !

I have a working application with a MySQL service file for 3.2.1 version "mysql-3.2.1-service.xml". I need to translate this service file into "mysql-ds.xml" DS file, but although DS file deploys properly I always get a "java.lang.ClassCastException" at "com.sun.corba.se.internal.javax.rmi.PortableRemoteObject.narrow(PortableRemoteObject.java:293)" with it, while application still runs with former service file. Could someone help ?

Service file "mysql-3.2.1-service.xml" :

<?xml version="1.0" encoding="UTF-8"?>



jca/Connect

<depends optional-attribute-name="ManagedConnectionPool">


<depends optional-attribute-name="ManagedConnectionFactoryName">

<!-- the value of name of the OldRarDeployement must be the same as the ra.xml display name -->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=MySQL


<config-property name="ConnectionDriverName" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
<config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost/test</config-property>
<config-property name="ConnectionUserName" type="java.lang.String">admin</config-property>
<config-property name="ConnectionPassword" type="java.lang.String">admin</config-property>





0
50
5000
15
ByContainer



<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

<depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager




"mysql-ds.xml" file :

<?xml version="1.0" encoding="UTF-8"?>

<xa-datasource>
<adapter-display-name>mysql-resource-adaptor</adapter-display-name>
<jndi-name>jca/Connect</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<connection-url>jdbc:mysql://localhost/test</connection-url>
<!-- <driver-class>org.gjt.mm.mysql.Driver</driver-class> -->
<xa-datasource-class>org.gjt.mm.mysql.Driver</xa-datasource-class>
<user-name>admin</user-name>
admin
jboss.jca:service=RARDeployment,name=MySQL
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss:service=TransactionManager

</xa-datasource>


TIA.

Best regards.

[adrian.brock]

AFAIK MySQL does not support XA
Certianly the class you have configured is not an XADataSource,
it is a jdbc driver class.

Use the example mysql-ds.xml from docs/example/jca
Change the parameters as appropriate.

Regards,
Adrian