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

FYI - problem solved.
I loaded the JDBC driver for 9.0.1 for JDK 1.2.x and 1.3.x. from the technet.oracle.com site. Although the driver is designated for Solaris, it is working under Windows.

Thanks for the reply,

JA

crappygolucky_at_hotmail.com (crappy) wrote in message news:<ce31c410.0112041239.43275e50_at_posting.google.com>...
> 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 - 23:32:17 CST