RE: Connection Pool and Connections

2007-10-09 Thread Peng Tuck Kwok
If I recall correctly close from a datasource (not a SQLConnection) will return the connection to the pool for reuse. In the later this will close the connection to the database. To answer your question I'm pretty sure any statement executed within the connection from the datasource will go to

Re: Connection Pool and Connections

2007-06-01 Thread Johnny Kewl
Hi LightBulb... No its not going to work like I think you want it to... Statement stmt= con.createStatement(); ResultSet resultSet = stmt.executeQuery(sSql); //For Select and say Statement stmt = con.createStatement();