Servlet / JDBC question

[Campbell, Sean]

I have a Servlet / JDBC question.
I have a servlet that needs to retrieve data from  an Oracle database using
Oracle version 8. I have debugged through and confirmed that I'm making the
connection - my problem is that when I try and retrieve records, I
consistently get an empty recordset, although  I can confirm that the
recordset structure being returned is the correct structure of the table I'm
querying. ( i.e.  I query a 'Users' table,  and when I create a
ResultSetMetaData object 'rsm'  from the ResultSet 'rs' object and use the
rsm.getColumnName() method, I get the correct column names. I'm just not
sure why I'm not getting any data back.
I've inserted my test function below - any help would be greatly
apprectiated.

                Connection con = null;


                // this is the constructor of the class my servlet is
calling
                public Data()
                  {
                     try{
                      DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver() );
                      con =
DriverManager.getConnection("jdbc:oracle:thin:@ccdev:1521:ccct", "ccc",
"ccc");
                      //log.logError("got here", "Constructor", "");
                      System.out.println("got here");

                      System.out.println(testFunc());
                     }
                     catch(SQLException sqlErr)
                     {
                        //log.logError("Data Class", "Constructor",
sqlErr.getMessage());
                      System.out.println("error occurred");
                     }

                     // point class Data's ErrorLog object to the passed
object reference
                     //this.log = passedLog;
                  }



                // the test function to test data retrieval

                public String testFunc()
                  {
                    Statement stmt ;
                     ResultSet rs ;
                     String returnValue = "no records returned";

                     try
                     {
                        stmt = con.createStatement();
                        rs = stmt.executeQuery("select * from USERS");

                        ResultSetMetaData rsm = rs.getMetaData();
                        System.out.println(rsm.getColumnName(1) +' ' +
rsm.getColumnName(2) +' '+ rsm.getColumnName(3));

                        if (rs.next()) {
                        returnValue =  rs.getString("password");
                        }

                        stmt.close();
                        con.close();
                     }
                     catch(SQLException sqlErr)
                     {
                        System.out.println("sql error");
                        System.out.println(sqlErr.getMessage());
                        //log.logError("Data Class", "validateUser",
sqlErr.getMessage());
                     }
                    return returnValue;
                  }

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html