Re: JDBC and ResultSetMetaData

On Mon, 16 Sep 2002, j_at_softdecc.com wrote:
> Hello,
>
> every now and then I get no result (a 'null'), when I try to read
> a column name from a ResultSetMetaData (metadata.getColumnName(i))
> using Oracle 8.1.7 Server and the thin JDBC-Driver with
> JDK1.3.1_04 (on Windows2000).
>
> Prior to that I read metaData.getColumnCount() and got the
> correct result for the given ResultSet, so that the index into
> getColumnName() is correct.
>
> What we can observe is:
>
> - that happens not alway
> - it happens not on special columns or column datatypes
> - it happens not on special queries
>
> Anybody any ideas?

I'm not so sure "no result" means "null".

Or maybe the values in the column you asked for were null?

Does the result of the SQL run in sqlplus show the column returning values?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.