Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting To Database Through web.xml

 
Marcus Hathaway
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:

<context-param>
<param-name>
javax.servlet.jsp.jstl.sql.dataSource
</param-name>

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

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.

Cheers!
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Cheers.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic