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
894 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
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 500 total points
ID: 22793475
0
 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 500 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 500 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 500 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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
java. non-English characters encoding problem. intellij idea 3 88
Non-recursive backtracking, using a stack 1 169
servlet example 17 51
intellij error 2 17
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…
Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

809 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