TechLists.org

HTH

jeff --

---
Jeff Gutierrez
Senior Software Engineer
Intertainer Inc. (http://www.intertainer.com)

"Algorithms + Data Structures = Programs"   -- Niklaus Wirth


----- Original Message -----
From: "alex" <tinbb@xxxxxxxxxxxx>
To: <advanced-java@xxxxxxxxxxxxxxxx>
Sent: Tuesday, December 28, 1999 3:03 AM
Subject: JDBC question


> Dear all,
>
> Does the following valid ?
>
> Connection conn = DriverManager.getConnection("...", "a","f");
> Statement stmt = conn.createStatement();
> ResultSet rs = stmt.executeQuery("select field1 from tableA");
> while (rs.next()) {
>     int a = rs.getInt(1);
>     ResultSet rs2 = stmt.executeQuery("select field2 from tableB where
> field1 = "+a);
>     while (rs2.next()) {
>           ...
>           .....
>     }
> }
>
> can i send another query when the first resultset is not read completely?
>
> regards
> alex
>
>
> ---
> To unsubscribe, mail advanced-java-unsubscribe@xxxxxxxxxxxxxxxx
> To get help, mail advanced-java-help@xxxxxxxxxxxxxxxx
>


---
To unsubscribe, mail advanced-java-unsubscribe@xxxxxxxxxxxxxxxx
To get help, mail advanced-java-help@xxxxxxxxxxxxxxxx