File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes deploy mysql in struts-config with WSAD Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "deploy mysql in struts-config with WSAD" Watch "deploy mysql in struts-config with WSAD" New topic

deploy mysql in struts-config with WSAD

PhiL Mulyana

Joined: Aug 01, 2006
Posts: 1
hi all,
I'm new to struts. Currently I'm making a web apps with WSAD and DB2 using struts. Now I need to change the database from using DB2 to mysql and I have no idea how the <data-source> in the struts-config should be. Can someone help me.

Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
My experience with the Struts datasource is that it's nothing but trouble, and that you should avoid using it.

The best practice is to set up a datasource through your application server and then access it in your application through a JNDI lookup. Since you're using WSAD, look in the help documentation and you will find a lot of good information about how to set up a datasource.

This link gives some information specifically about WSAD and MYSQL.
[ August 01, 2006: Message edited by: Merrill Higginson ]

Consultant, Sima Solutions
I agree. Here's the link:
subject: deploy mysql in struts-config with WSAD
jQuery in Action, 3rd edition