🚀 go-pugleaf

Dear Torsten,

You see my sample I do create statement for each ResultSet, but there is a
error: Connection is busy with results for another Statment?  Do you know
why?

"Torsten Welches" <torsten.welches@who.cares.netcologne.de> wrote in message
news:3ab1b7e4$1_2@dnews...
>
> 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?
> >
> >            }
> >
> >    }
> >
> >
> >
> >
>