Help on tomcat 5.0 connection pool

[Koon Yue Lam]

Hi, I am using Tomcat 5.0 and Stuct 1.1 to develop a web base application
and I want to create some prepareStatement and execute it multiple times
but since the connection is retrieved from the pool upon request, I
may get a number of connections, how can I create a prepareStatement
to a specific connection??

code like this:

PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES
                                     SET SALARY = ? WHERE ID = ?");
   pstmt.setBigDecimal(1, 153833.00)
   pstmt.setInt(2, 110592)


Regards

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]