• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem with configuring EJB with MySQL

 
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 346
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
My pie came with a little toothpic holding up this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic