Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Is any problem with this code? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Is any problem with this code?" Watch "Is any problem with this code?" New topic
Author

Is any problem with this code?

Jayii Young
Greenhorn

Joined: Dec 11, 2000
Posts: 5
Statement sql = con.createStatement();
ResultSet rs1 = sql.executeQuery(sql1);
ResultSet rs2 = sql.executeQuery(sql2);
String Value1 = rs1.getString(1);
String Value2 = rs2.getString(1);
Blake Minghelli
Ranch Hand

Joined: Sep 13, 2002
Posts: 331
Originally posted by Jayii Young:
Statement sql = con.createStatement();
ResultSet rs1 = sql.executeQuery(sql1);
ResultSet rs2 = sql.executeQuery(sql2);
String Value1 = rs1.getString(1);
String Value2 = rs2.getString(1);

Yes, that won't work correctly. A Statement can only be used to read one ResultSet at a time. As soon as you execute the second query, the first ResultSet is automatically closed.
If you need to read from more than one ResultSet at a time, then you must use different Statements.


Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
Jayii Young
Greenhorn

Joined: Dec 11, 2000
Posts: 5
Thanks Blake!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Is any problem with this code?