0 Replies Latest reply on Jul 27, 2007 9:11 PM by geeky2

    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