DBCP usage w/servlets

2003-01-29 Thread Erik Price
I found a promising-looking post in the archives about using DBCP in a Tomcat-based servlet environment: http://www.mail-archive.com/tomcat-user@jakarta.apache.org/msg67843.html Unfortunately, the link to the source code (the meat of the post) is broken. Does anyone have any sample source

Re: DBCP usage w/servlets

2003-01-29 Thread Jakarta
/web.xml i declare the resources requirements for each webapp it works r - Original Message - From: Erik Price [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 4:54 PM Subject: DBCP usage w/servlets I found a promising-looking post in the archives

Re: DBCP usage w/servlets

2003-01-29 Thread Hannes Schmidt
Have a look at the attached context listener. Once the datasource is initialized, you can acces it like that (but I guess you know that already) Connection c = dataSource.getConnection(); try { Statement s = c.createStatement(); String sql = SELECT ...; ResultSet rs = s.executeQuery(