Very Computer

Hi,

When running the code below I get the following error:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor
state
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor
state
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
        at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3266)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString
(JdbcOdbcResultSet.java:5377)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getString
(JdbcOdbcResultSet.java:320)
        at DBCompany.<init>(DBCompany1.java:177)
        at DBCompany.main(DBCompany1.java:207)

Can anyone tell me what I have missed out/done incorrectly?
Or, is there a limit to the number of resultsets you can have in one
java program?

Many Thanks in advance!
Dipen

Code
====
import java.sql.*;
import java.util.*;
import java.io.*;
import DBConnection;

public class DBCompany1
{

    public DBCompany1() throws IOException
    {
       String table, sqlstr = null;
       try
       {
          DBConnection db = new DBConnection();
          Connection conn = db.getConnection("abc","de");
          Connection connA = db.getConnection("abc","de");
          Connection connB = db.getConnection("abc","de");
          Connection conn2 = db.getConnection("cde","de");

          Statement st = conn.createStatement();
          sqlstr = "select * from companies";
          ResultSet rs = st.executeQuery(sqlstr);
          while(rs.next())
          {
             String company_id = rs.getString(1);

             Statement st2 = connA.createStatement();
             String sqlstr2 = "select * from sources";
             ResultSet rs2 = st2.executeQuery(sqlstr2);

             while(rs2.next())
             {
                String name = rs2.getString(1);
                String type = rs2.getString(2);

                Statement st3 = connB.createStatement();
                ResultSet rs3 = st3.executeQuery("select * from
sectors");

                while (rs3.next());
                {

// error occurs here - ie when trying to 'get' the datatype
                                  Object o = rs3.getObject(1);
                                  System.out.println("the datatype for
column 1 of rs3 is : " + o.getClass().getName());

                }
             }
          }
       }
       catch(SQLException e)
       {
          System.err.println(e);
                  e.printStackTrace(System.err);
       }
       catch(IOException e)
       {
                  System.err.println(e);
                  e.printStackTrace(System.err);
       }
   }

   public static void main (String[] args) throws IOException
   {
      DBCompany1 test = new DBCompany1();
   }

Quote:}

Sent via Deja.com
http://www.deja.com/