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.
Thanks.
Merrill Higginson
Ranch Hand
Joined: Feb 15, 2005
Posts: 4864
posted
0
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 ]