-
1. Re: Make Messaging server talk to MySQL DB
peterj Jan 8, 2007 11:08 AM (in response to vvd)An example mysql-ds.xml file can be found in the app server at ./docs/examples/jca/mysql-ds.xml.
-
2. Re: Make Messaging server talk to MySQL DB
vvd Jan 8, 2007 11:13 AM (in response to vvd)"PeterJ" wrote:
An example mysql-ds.xml file can be found in the app server at ./docs/examples/jca/mysql-ds.xml.
thanks. -
3. Re: Make Messaging server talk to MySQL DB
vvd Jan 15, 2007 1:43 PM (in response to vvd)after copying the mysql related file in the respective directories
ie. mysql-persistence-service.xml into <jboss-installdir>/server/standalone-messaging/deploy/jboss-messaging
and mysql-ds.xml into <jboss-installdir>/server/standalone-messaging/deploy directory.
Only common change I made was to change the from 'DefaultDS' to 'msgq'.
In 'mysql-ds.xml' file I mentioned the machine and port, userid and password.
when I start the server I see the following error outputed to screen
13:32:20,213 INFO [Catalina] Server startup in 212 ms
13:32:20,341 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
13:32:20,782 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined
13:32:21,781 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
13:32:22,223 INFO [[/web-console]] J2EEFolder: Failed to init plugin, bsh/Interpreter
13:32:22,236 INFO [[/web-console]] SystemFolder: Failed to init plugin, bsh/Interpreter
13:32:22,656 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
13:32:22,971 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:name=msgq,service=DataSourceBinding' to JNDI name 'java:msgq'
13:32:23,019 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.mysql.jdbc.Driver))
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179) -
4. Re: Make Messaging server talk to MySQL DB
peterj Jan 15, 2007 3:36 PM (in response to vvd)Did yo ucopy the JDBC jatr file to server/standalone-messaging/lib?
-
5. Re: Make Messaging server talk to MySQL DB
vvd Jan 15, 2007 9:22 PM (in response to vvd)Thanks for the response.
I did find the below file in the path you have mentioned.
"/server/standalone-messaging/lib/jboss-common-jdbc-wrapper.jar"
if above is not the correct file, please let me know which file I need to copy
and let me know where I can find the file also.
Thanks, -
6. Re: Make Messaging server talk to MySQL DB
peterj Jan 15, 2007 9:31 PM (in response to vvd)That is not the JDBC jar file. You have to get it from your database vendor.
-
7. Re: Make Messaging server talk to MySQL DB
vvd Jan 16, 2007 1:57 PM (in response to vvd)Thanks for all the help.
1. downloaded the mysql-connector-java-5.0.4-bin.jar from MySQL connector tar file and copied into 'server/standalone-messaging/lib'
2. Edited the mysql-ds.xml file to update the JNDI name
3. updated the mysql-persistence-service.xml file with above JNDI name as mentioned in the documentation .
4. brought the server up and it now talks to the MySQL DB.