[jboss-user] [JCA/JBoss] - Re: Migration to MySQL

[bartek.polakowski]

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>

4)In $JBOSS_HOME/server/default/conf/standardjaws.xml I change the <type-mapping> element to mySQL:

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

5)In standardjbosscmp-jdbc.xml I change the following

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

6)I add the following within the  element of login-config.xml:

  <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>

7) I Replace file $JBOSS_HOME/server/default/deploy/jms/hsql-jdbc2-service.xml by file $JBOSS_HOME/docs/examples/jms/mysql-jdbc2-service.xml

8) Change MySqlDS to DefaultDS in $JBOSS_HOME/server/default/deploy/jms/mysql-jdbc2-service.xml:

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

9) I rename hsqldb-jdbc-state-service.xml to mysql-jdbc-state-service.xml.

And still the same:/ Maybe I use some incompatible versions of jboss and mysql or the driver is wrong?



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047483#4047483

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047483