2 Replies Latest reply on Feb 28, 2005 6:18 AM by Mukti furtado

    Jboss- DataSource Problem

    Mukti furtado Newbie

      I have Jboss 4.0.1 and mysql4.1 and j2sdk1.4.2_07. i have deployed a ear file which contains 1 entity bean . I get the following errors when i start the server

      ObjectName: jboss.j2ee:jndiName=ejb/Example/Story,service=EJB
      state: FAILED
      I Depend On:
      Depends On Me: org.jboss.deployment.DeploymentException: Error: can't find data
      source: java:/MySqlDS; - nested throwable: (javax.naming.NameNotFoundException:
      MySqlDS not bound)

      and in the browser i get following error

      java.rmi.ServerException: RuntimeException; nested exception is: java.lang.IllegalStateException: createBeanClassInstanceCommand == null

      Can somebody please help me with this problem .

        • 1. Re: Jboss- DataSource Problem
          Steven Peh Newbie

          Have you created the mysql datasource that your ejb is using? i'd suggest you edit one of the mysql-*.xml files in the docs/example/jca folder and copy it into your server's deploy folder...

          • 2. Re: Jboss- DataSource Problem
            Mukti furtado Newbie

            Hi,
            My problem is solved. I followed the steps mentioned below
            Thanks for your help

            1.Replace jboss-4.0.0/server/standard/deploy/hsqldb-ds.xml by a file named mysql-ds.xml with the following content:

            <local-tx-datasource>
            <jndi-name>DefaultDS</jndi-name>
            <connection-url>jdbc:mysql://localhost/test</connection-url>
            <driver-class>com.mysql.jdbc.Driver</driver-class>
            <user-name>jboss</user-name>
            <security-domain>MySqlDbRealm</security-domain>
            </local-tx-datasource>

            2.Edit jboss-4.0.0/server/standard/conf/standardjaws.xml with the following parameters:
            java:/DefaultDS
            <type-mapping>mySQL</type-mapping>

            3.Edit jboss-4.0.0/server/standard/conf/standardjbosscmp-jdbc.xml with the following parameters:
            <datasource-mapping>mySQL</datasource-mapping>
            ...
            <fk-constraint>true</fk-constraint>

            4.Replace file jboss-4.0.0/server/standard/deploy/jms/hsql-jdbc2-service.xml by file jboss-4.0.0/docs/examples/jms/mysql-jdbc2-service.xml and change MySqlDs to DefaultDS (line 47) in that file.