Updatable ResultSet - getString works but getObject does not??

[Shailan Mm]

Hi

I am creating an updatable resultset and then going thru it to read the values in each row. When I use getObject() to get the column values for each row, I get nulls. However, when I use getString(), I get the correct values.
Also, if I create a regular statement, not using the updatable result set feature, the getObject() call works fine.

Why would this be happening? (code below)

Thanks
Shailan

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
//Statement stmt = conn.createStatement(); // - getObject() works with this
ResultSet rset = stmt.executeQuery(query);
 
metaData = rset.getMetaData();
int numberOfColumns = metaData.getColumnCount();
int numRows = 0;
 
for (int column = 1; column <= numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column));
}
 
columnNames.addElement("RECEIVE_DATE");
 
// Get all data rows.
while (rset.next()) {
 numRows++;
 Vector newRow = new Vector();
 for (int i = 1; i <= numberOfColumns; i++) {
   //newRow.addElement(rset.getString(i));
   newRow.addElement(rset.getObject(i));
 }
 aliceData.addElement(newRow);
}

[edited to add code tags]
[ December 07, 2004: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Shailan,
What is the type of the database field? Also, what database are you using?

[Shailan Mm]

Hi Jeanne

Im using Oracle8i Enterprise Edition Release 8.1.6.0.0

The query does a select * from a table with the following field types. (all Nullable)

Type
------------
VARCHAR2(3)
VARCHAR2(5)
VARCHAR2(3)
VARCHAR2(6)
VARCHAR2(1)
VARCHAR2(6)
DATE
VARCHAR2(1)
VARCHAR2(2)
DATE
DATE
VARCHAR2(8)
VARCHAR2(20)

[Jim Cheng]

This is an interesting question.
I will try to duplicate the problem and figure out the reason if I have time.

Please also report back if you figure out the reason.


Jim

[Jeanne Boyarsky]

Shailan,
Strange. You are using Oracle's JDBC driver, right?

[Shailan Mm]

Yup. oracle.jdbc.driver.OracleDriver.

[Shailan Mm]

Has anyone else encountered this behavior?

Thanks
Shailan