simple questions, but hard to find an exact answer
Posted by: joewaster
Date: March 10, 2005 09:34AM

Can you have more than one statment at the sametime on the same connection??

for example

conn = ds.getConnection();

Statement stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT SOMETHING");

Statement stmt2 = conn.createStatement();
rs2 = stmt2.executeQuery("SELECT SOMETHINGELSE");

this works fine right?

does this mean I can have two resultsets open at the same time?

I always hear that you can only have one resultset open at a time,
so thats why I am kind confused, can someone clarify this??

Options: ReplyQuote

Written By
simple questions, but hard to find an exact answer
March 10, 2005 09:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.