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:
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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com