• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Struts and connectionPool

 
Servin Park
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Ranchers,
I am building a webapp on top of struts. I also have a DBConnectionPool class that will handle getting MySQL database connection. I just want to ask your opinion on what I am doing has any flaw:
1. Extended ActionServlet and override init(...) method. In the init() I initialized conncetionpool and servletContext.setAttribute("dbpool", dbconn);
2. In the action class (for instance RegisterAction), I get the connectionpool like this. getServlet().getServletContext().getAttribute("dbpool");
I didn't get any problem having me as only user. Does anyone see flaws in my logic above? Do you have any better idea how to utilize generic connection pool with struts?
Thanks in advance for you kind replies.
 
karl koch
Ranch Hand
Posts: 388
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
there is a (development release) of JDBC3.0 driver for mySQL available.
see
sun jdbc im not sure if all the drivers include the pooling facility. best thing is to check with the mySQL homepage.
k
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic