connecting to MySQL with Jboss.
joberholtzer Feb 24, 2004 11:53 AMI 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