0 Replies Latest reply on Feb 24, 2004 11:53 AM by joberholtzer

    connecting to MySQL with Jboss.

    joberholtzer Newbie

      I am trying to get MySQL to be the default database in JBOSS. After making the several changes (listed later) in the xml files, this is as close as I get:

      Depends On Me: , ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
      state: FAILED
      I Depend On: jboss.jca:service=LocalTxDS,name=MySqlDS

      Depends On Me: org.jboss.deployment.DeploymentException: Exception setting attribute javax.management.Attribute: name=ManagedConnectionFactoryName value=jboss.jca:service=LocalTxDS,name=MySqlDS on mbean jboss.jca:service=LocalTxCM,name=MySqlDS; - nested throwable: (javax.management.AttributeNotFoundException: Writable attribute 'ManagedConnectionFactoryName' not found), ObjectName: jboss.jca:service=LocalTxDS,name=MySqlDS
      state: FAILED
      I Depend On:
      Depends On Me: jboss.jca:service=LocalTxCM,name=MySqlDS


      I have no idea where to look for this problem. Ideas?

      A portion of standardjbosscmp-java.xml:
      <?xml version="1.0" encoding="UTF-8"?>
      <!DOCTYPE jbosscmp-jdbc PUBLIC
      "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN"
      "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">

      <!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->

      <jbosscmp-jdbc>


      <!-- java:/DefaultDS-->
      <datasource-mapping>ejb</datasources-mapping>
      <datasource-mapping>MySQL</datasource-mapping>


      A portion of standardjaws.xml:

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

      <!DOCTYPE jbosscmp-jdbc PUBLIC
      "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN"
      "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd">

      <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->


      java:/DefaultDS
      <type-mapping>MySQL</type-mapping>
      false


      A portion of mysql-service.xml:



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

      DefaultDS


      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost/ejb</config-property>
      <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>

      <!-- set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String">ejb</config-property>
      <config-property name="Password" type="java.lang.String">ejb</config-property>


      <!-- Below here are advanced properties -->
      <!-- hack -->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper