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:
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.
posted 9 years ago
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.