[jboss-user] [Installation, Configuration & DEPLOYMENT] - need help with simple deployment for jboss 4.2.1 and mysql

[geeky2]

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


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4068408#4068408

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