Forums Register Login

Problem with configuring EJB with MySQL

+Pie Number of slices to send: Send
Hi all
I am new to EJB and i followed the tutorial to set up entity beans from EJBtut.com, i faily understood the configurations and EJB structure.
But i have a problem in registering mysql driver as the dasebase driver.

I am using Jboss-4.0.0 as my app server and mysql as a database.

Could anybody help with the procedure as i feel i am not doing it right.

With Regards
S.R.K.Vivek Raju.
+Pie Number of slices to send: Send
1. Have you put mysql driver file in JBoss server's lib folder.

2. From C:\jboss-4.0.0\docs\examples\jca directory you can get mysql-ds.xml file and place it in JBoss server's deploy folder.

3. Edit this file for <jndi-name>,<connection-url>,<driver-class>,<user-name>, <password>

4. In login-config.xml file if you have
<application-policy name = "someDbRealm"> specified. If yes then check for
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=This should be same as <jndi-name> in step 3.</module-option>

5. <security-domain> in mysql-ds.xml file at step 2. should be same as application-policy name at step4.
+Pie Number of slices to send: Send
A few months ago I posted a small document about MySQL/JBoss config, based on the problems I encountered.
Maybe this can help you.
See http://www.practicalsoftwarearchitect.com/tips/jbossmysql/jbossmysql.html
It is an experimental device that will make my mind that most powerful force on earth! More powerful than this tiny ad!
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 541 times.
Similar Threads
headache! jboss+mysql problem
Remote Exception in EJB with MySQL
Communication failure during handshake
NetBeans and MySQL
How to connect entity beans to mysql database.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 05:04:44.