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

i believe that's a known problem using the 8.x jdbc driver against a 9i db. i think in that scenario, pretty much anything you do will give you that error msg--so when you say "char or varchar" do you mean other queries actually work?

"sometimes" it can be made to work, i suppose, but in this case perhaps not. check the trace file--it have a feeling it might show you something that's not related to your query at all.

j.alford_at_tcu.edu (Jennifer Alford) wrote in message news:<b39940d8.0112031232.3f770a8e_at_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 Tue Dec 04 2001 - 14:39:12 CST