Hi Sean: try rs.getType("your column name"). If your data is varchar2, then
rs.getString(), if integer then getInt() etc.
The result you got is stored in rs, not rsm. Good Luck!
Eric Liu
>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
___________________________________________________________________________
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
