It's not a secret anymore!*
The moose likes JSP and the fly likes Connecting To Database Through web.xml Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Connecting To Database Through web.xml" Watch "Connecting To Database Through web.xml" New topic

Connecting To Database Through web.xml

Marcus Hathaway
Ranch Hand

Joined: Jun 07, 2005
Posts: 89
Hi,sorry if this post should be in JDBC instead...but because its directly related to JSP and web.xml i thought it best here.

Anyway, i want my web application to be able to connect to a MySQL database directly through values i set in web.xml. Even though i can connect through a normal java class no problems, i specifically don't want to use a java class or servlet in this instance. Furthermore, I believe this can be achieved solely through web.xml. Perhaps someone could firtsly confirm this?

Here's what i've done so far. In web.xml i have the following:


<param-value> jdbc:mysql://localhost:3306/dbName,com.mysql.jdbc.Driver,username,password </param-value>

I have the mysql connector jar file in tomcat/common/lib.
In my own application folder i have jstl.jar & standard.jar in the lib folder and all required tag libaries in the tld folder.

Any advice or comments on this way of connecting would be greatly appreciated.

Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Its perfactly fine to define DB connection strings in web.xml. But it is discouraged to JSTL SQL tags in a production application. JSTL SQL tags are usually used for prototyping stuff. Best practices are to seperate the DB access code from presentation tier.

Don't get me started about those stupid light bulbs.
subject: Connecting To Database Through web.xml
Similar Threads
JSF Facelets deployment problem
Missing application web.xml, using defaults only
Context param values from web.xml
javax. servlet.jsp.J spException: Cannot find FacesContext
problem in web application with connection pooling