JDBC ThinDriver executeQuery() fails for VARCHAR data under Oracle 9i/Linux and Win2000/JDK1.3

From: Jennifer Alford <j.alford_at_tcu.edu>
Date: 3 Dec 2001 12:32:32 -0800
Message-ID: <b39940d8.0112031232.3f770a8e@posting.google.com>

I am seeking a workaround to the following problem:

Any kind of character data (CHAR, VARCHAR2) defined in SQL can not be accessed via a SELECT statement from a JDBC executeQuery() method.

Here are the software configurations:

    Server-side: Oracle 9i under Linux 7.1 on PC     Client-side: JDK 1.3.1 using the following with JDBC ThinDriver

                    classes12.zip (for Oracle 8.1.7 for NT)under Win2000

    (I realize the inconsistencies but sometimes it can be made to work.)

Here is the SQL that defines and populates the test table:

create table emp (

    	    empid   integer not null,
     	    empname varchar2(5),
      	    dno     number(4),
      	    primary key (empid)
     );

insert into emp values (20, 'Bob', 2);
insert into emp values (30, 'Ann', 1);

Here is the Java segment that fails:

Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery("select EMPNAME from EMP"); // Fails on this line

Here is the error message:

Exception in thread "main" java.sql.SQLException: ORA-00600: internal error code , arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
        at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:1681)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1870)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
538)
        at Test1.main(Test1.java)

Thank you,

Jennifer Received on Mon Dec 03 2001 - 14:32:32 CST