FreeTDS Development Group

[Andreas Tille <tillea AT rki.de>]

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.