FreeTDS Development Group

[Craig Spannring <cts AT internetcds.com>]

Could you submit a nice short example that demonstrates your problem?

The FreeTDS driver normally handles multiple open result sets just
fine.



Andreas Tille writes:
 > Hello,
 > 
 > at first I have to say that I'm a very beginner in Java programming
 > in general and JDBC programming in special.  I have the following
 > skeleton of a servlet
 > 
 > ...
 >   ResultSet rs1, rs2;
 >   Statement stmt = con.createStatement(); 
 > 
 >   rs1 = stmt.executeQuery(query1); 
 >   if ( rs1.next() ) { ... }
 >   rs2 = stmt.executeQuery(query2); 
 >   if ( rs2.next() ) { ... }
 > 
 >   while ( rs1.next() ) { ... }
 > 
 > I found out that the last line breaks the servlet.  So my question
 > is:  Is it a general JDBC problem that I can't use two different
 > result sets at the same time or is it a FreeTDS JDBC problem?
 > 
 > Kind regards
 > 
 >         Andreas.
 > 
 > 
 > ---
 > You are currently subscribed to freetds as: cts AT internetcds.com
 > To unsubscribe, forward this message to $subst('Email.Unsub')
 > 
-- 
=======================================================================
 Life is short.                  | Craig Spannring 
      Bike hard, ski fast.       | cts AT internetcds.com
 --------------------------------+------------------------------------
 Any sufficiently horrible technology is indistinguishable from Perl.
=======================================================================