JBossDeveloper

This is my mysql-ds file

<datasources>
 <local-tx-datasource>
 <jndi-name>MySqlDS</jndi-name>
 <connection-url>jdbc:mysql://mysql-hostname:3306/jbossdb</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>jboss</user-name>
 <password>jboss</password>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
 <!-- should only be used on drivers after 3.22.1 with "ping" support
 <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
 -->
 <!-- sql to call when connection is created
 <new-connection-sql>some arbitrary sql</new-connection-sql>
 -->
 <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
 <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
 -->

 <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </local-tx-datasource>

<local-tx-datasource>
 <jndi-name>Publication</jndi-name>
 <connection-url>jdbc:mysql://mysql-hostname:3306/ld_publication</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>java</user-name>
 <password>java</password>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>15</max-pool-size>
 <idle-timeout-minutes>5</idle-timeout-minutes>
 <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
 <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>

</local-tx-datasource>

</datasources>

Ok one more time from the beginning. This is what I do:

1)I have mySQL ver 5.0.24a-community-nt so I copy the MySQL JDBC driver (mysql-connector-java-5.0.6-bin.jar) to the $JBOSS_HOME/server/default/lib

2)I delete $JBOSS_HOME/server/default/deploy/hsqldb-ds.xml

3)I copy $JBOSS_HOME/docs/examples/jca/mysql-ds.xml to $JBOSS_HOME/server/default/deploy and modify the <local-tx-datasource> element with my MySQL connection settings:

<jndi-name>MySqlDS</jndi-name> <connection-url>jdbc:mysql://mysql-hostname:3306/jbossdb</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>jboss</user-name>
<password>jboss</password>

<datasource>java:/DefaultDS</datasource>
 <type-mapping>mySQL</type-mapping>

<datasource>java:/DefaultDS</datasource>
 <datasource-mapping>mySQL</datasource-mapping>
 <fk-constraint>true</fk-constraint>

<application-policy name = "MySqlDbRealm">
 <authentication>
 <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
 <module-option name = "principal">jboss</module-option>
 <module-option name = "userName">jboss</module-option>
 <module-option name ="password">jboss</module-option>
 <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DefaultDS</module-option>
 </login-module>
 </authentication>
 </application-policy>

<depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>

Ive upgraded to mysql-5.0.41 any nothing:/

I can see this dependency in ejb-deployer.xml and uuid-key-generator.sar/META-INF/jboss-service.xml but Im not sure what should I do with it.

Could you rephrase your advice because the problem can be my english:)

After Ive changed everything to MySqlDS I got:

2007-05-22 14:37:52,920 ERROR [org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin] Cannot create timer table
org.jboss.deployment.DeploymentException: Error while checking if table aleady exists TIMERS; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.UnknownHostException
MESSAGE: mysql-hostname: mysql-hostname

STACKTRACE:

java.net.UnknownHostException: mysql-hostname: mysql-hostname

Wow How could I forget it. Ok so after changing it to localhost and changing jndi name to DefaultDS there are no errors:)

The fragment of the log looks like this

22:49:56,803 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jc
:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
22:50:01,560 INFO [A] Bound to JNDI name: queue/A
22:50:01,570 INFO [B] Bound to JNDI name: queue/B
22:50:01,570 INFO [C] Bound to JNDI name: queue/C
22:50:01,570 INFO [D] Bound to JNDI name: queue/D

Thank you for help and patience:)

You do everything like here:
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpMysqlAsDefaultDS

But there is one mistake. Dont change the datasource's name to mySQL in mysql-ds.xml. It should be kept as Default.