hello everyone,
i am attempting to deploy a simple jboss app that uses mysql as a datasource. this is the first time i have tried to connect to anything but the default datasource.
this is the error that i am getting:
>>
--- MBeans waiting for other MBeans ---
ObjectName: jboss.j2ee:jar=jbosstest.jar,name=ClockOperationsLocalBean,service=EJB3
State: NOTYETINSTALLED
I Depend On:
persistence.units:unitName=MYSQLDS
ObjectName: jboss.j2ee:jar=jbosstest.jar,name=ClockOperationsRemoteBean,service=EJB3
State: NOTYETINSTALLED
I Depend On:
persistence.units:unitName=MYSQLDS
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: persistence.units:unitName=MYSQLDS
State: NOTYETINSTALLED
Depends On Me:
jboss.j2ee:jar=jbosstest.jar,name=ClockOperationsLocalBean,service=EJB3
jboss.j2ee:jar=jbosstest.jar,name=ClockOperationsRemoteBean,service=EJB3
<<
this is my persistence.xml file:
<local-tx-datasource>
<jndi-name>MYSQLDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/primexdb</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>x</user-name>
y
<type-mapping>mySQL</type-mapping>
</local-tx-datasource>
i have made sure that that mysql jar file is located in the default/lib dir and i have also copied the sample mysql-ds.xml file in to the deploy directory - after making appropriate changes (not sure if this is redundant or not).
thx for any help
mark