🚀 go-pugleaf

Stephen,

you don't need two Connections, but two Statements. One Statement
can only serve one ResultSet. 
You might also want to verify if what your are after isn't doable
with *one* SQL statement - join, subselect and so on.

Torsten

"Stephen Zeng" <chinafax1@cmmail.com> wrote:
>   Connection con=DriverManager.getConnection("jdbc:odbc:expresso","sa","");
>   Statement sqlstr=con.createStatement();
>   Statement trasql=con.createStatement();
>
>   ResultSet firstrs=sqlstr.executeQuery("....");
>
>    while (firstrs.next()) {
>
>        System.out.println(firstrs.getString(1));
>
>
>        //  next result set
>        ResultSet secondrs=sqlstr.executeQuery("...");
>
>        while (secondrs.next()) {
>            System.out.println(secondrs.getString(1));
>
>// error: Connection is busy with results for another Statment,
>// Does it means I need create New Connection for each ResultSet?  if that
>is the case,
>// it will  occupy large Server resource?
>// Or is there any better method?
>
>            }
>
>    }
>
>
>
>