🚀 go-pugleaf

Stephen (and Torsten),
I just wanted to add that I discovered that with Oracle's
JDBC driver and an Oracle 8.1.6 database, the "Connection"
interface is not multi-threaded. In other words, if you perform
a "Statement.executeQuery" from two separate threads
simultaneously against the same "Connection" the second
thread will block until the "Connection" returns the first
thread's "ResultSet".

HTH,
Avi.

Torsten Welches wrote:

> 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?
> >
> >            }
> >
> >    }
> >
> >
> >
> >