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
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();
recs