Very Computer

I write very simple code as follows,
 ....
  String ss;
 try{
   Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
   Connection con = DriverManager.getConnection
 ("jdbc:odbc:pdfdoc","fulcrum","fulcrum");
  con.setTransactionIsolation(con.TRANSACTION_READ_COMMITTED);
  Statement stmt = con.createStatement();

  ResultSet rs = stmt.executeQuery("select * from pdfdoc");
   column = rs.findColumn("status");

   ss = rs.getString(column);  //here catch "invalid cursor state " error
        ...

Quote:}

catch(SQLException e)
        {
        ...

        }

I'm new to java ,any suggestion will appreciate.

-----------------** -- Posted from CodeGuru -- **-----------------
http://www.codeguru.com/java     The website for Java programmers.

You must add
 rs.next();

       rs.next(); //add this one

Quote:>   ss = rs.getString(column);  //here catch "invalid cursor state " error
>    ...
>}
>catch(SQLException e)
>    {
>    ...

>    }

>I'm new to java ,any suggestion will appreciate.

>-----------------** -- Posted from CodeGuru -- **-----------------
>http://www.codeguru.com/java     The website for Java programmers.

-----------------** -- Posted from CodeGuru -- **-----------------
http://www.codeguru.com/java     The website for Java programmers.