?
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
Medium Priority
?
898 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 20

Accepted Solution

by:
chaitu chaitu earned 2000 total points
ID: 22793467
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 2000 total points
ID: 22793475
0
 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 2000 total points
ID: 22793503
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
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 2000 total points
ID: 22793579
0
 

Author Comment

by:fsyed
ID: 22918476
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 2000 total points
ID: 22920318
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
ID: 31509529
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

-Xmx and -Xms are the two JVM options often used to tune JVM heap size.   Here are some common mistakes made when using them:   Assume BigApp is a java class file for the below examples. 1.         Missing m, M, g or G at the end …
Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

800 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