Re: JDBC and ResultSetMetaData

"Galen Boyer" <galenboyer_at_hotpop.com> schrieb im Newsbeitrag news:ufzw7j1ih.fsf_at_hotpop.com...
> 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.

The queries are correct. They are running perfectly in sqlplus and even most times Java. The described problem shows up every 50 (an avarage value) times
the query is executed.

And metadata.getColumnName(i)) returns a Java 'null' for a valid index and a non empty
resultset. Received on Wed Sep 18 2002 - 03:43:13 CDT