Solved

Need to setup MySQL 5 on JBoss 4.2 application server using Eclipse 3.3 and JDK 1.5

Posted on 2008-10-23
7
888 Views
Last Modified: 2013-12-15
I am using jboss 4.2 application server with eclipse 3.3 (code name europa) and am using jdk1.5 .  By default, JBoss comes installed with the Hypersonic database.  However, I want to be able to use MySQL 5 instead.  I would sincerely appreciate it if someone could give me the FULL STEP BY STEP PROCESS of configuring MySQL with JBoss for EJB3 programming.  I want all the steps that I would need in case in the future I decide to use Oracle or PostGreSQL instead.  Moreover, I also would like to what additional steps I need to take, if any, to work with hibernate, and the spring framework with EJB3, and MySQL.

Thanks to all who reply.
Sincerely;
Fayyaz
0
Comment
Question by:fsyed
  • 5
  • 2
7 Comments
 
LVL 20

Accepted Solution

by:
chaitu chaitu earned 500 total points
Comment Utility
you go step by step .below link will tell you how to connect to MYSQL and other databases.

http://www.onjava.com/pub/a/onjava/2004/02/25/jbossjdbc.html
0
 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 500 total points
Comment Utility
0
 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 500 total points
Comment Utility
one thing keep in mind that when create datasource for mysql or any database the configuration file i.e xml file must always ends with -ds.xml file.

all related datasources are there in this folder.
C:\jboss-4.0.2\docs\examples\jca

take mysql-ds.xml  and copy this file in C:\jboss-4.0.2\server\default\deploy and make the changes .
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 500 total points
Comment Utility
0
 

Author Comment

by:fsyed
Comment Utility
Thanks so much for your prompt reply, and my sincerest apologies for not replying earlier, as I have been quite busy.  I read somewhere that I need to replace the hsqldb-jdbc2-service.xml with mysql-jdbc2-service.xml file (which I put in the servicer/xxx/deploy/jms directory).  Is this necessary?  Do I need to change anything in these files?  What about the persistence.xml file?  What changes do I need to make there?  I also read somewhere that I have to replace the hsqldb-persistence-service.xml file with the mysql-persistence-service.xml file in the messaging directory.  Is this the same as the mysql-jdbc2-service.xml file?

Sorry once again for the delay in replying, and thanks once again for your help.
Sincerely;
Fayyaz
0
 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 500 total points
Comment Utility
I read somewhere that I need to replace the hsqldb-jdbc2-service.xml with mysql-jdbc2-service.xml file (which I put in the servicer/xxx/deploy/jms directory).  Is this necessary?

If you are using JMS then its neccessary.replace hsqldb JNDI datasource with mysql datasource name.


Do I need to change anything in these files?  What about the persistence.xml file?  What changes do I need to make there?
http://docs.jboss.org/ejb3/app-server/reference/build/reference/en/html/entityconfig.html

I also read somewhere that I have to replace the hsqldb-persistence-service.xml file with the mysql-persistence-service.xml file in the messaging directory.  Is this the same as the mysql-jdbc2-service.xml file?

yes.
0
 

Author Closing Comment

by:fsyed
Comment Utility
My sincerest apologies for the delay in responding.  My laptop needed repairs, and I had a major deadline to complete at work.  Thanks so much for your time and patience!

Take care.
Sincerely;
Fayyaz
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org (http://seleniumhq.org) Go to that link and select download selenium in the right hand columnThat will then direct you to their downlo…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
The viewer will learn how to implement Singleton Design Pattern in Java.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now