Bug in JDBC drivers 7.4. , 8.0.4, 8.0.5 (both thin & oci)

Hi,

anyone heard of this one:

stmt = conn.createStatement();

rset = stmt.executeQuery ("SELECT A,B FROM C"); rset.close();

rset = stmt.executeQuery ("SELECT E FROM D "); rset.close();

... results in Exception somewhere in the "thin" driver

java.lang.ArrayIndexOutOfBoundsException: 1

        at
oracle.jdbc.driver.OracleStatement.doDefinesFromTypes(OracleStatement.java:394)

        at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:997)

        at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1152)

        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)

        at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:194)

        [...]

the problem can be "fixed" by altering query #1 to "SELECT A FROM C", i.e. select only one column.

100 % reproducible.

This is very bad. Or am I supposed to close() the Statment after each query ??

Matthias

--
Out-of-order Execution

        (Feature von modernen Microprozessoren) Received on Sat Feb 27 1999 - 19:16:35 CST