Re: JDBC: select statements causing errros when using classes12.zip but not when using classess111.zip

Josh ---

   sigh...I suggest contacting Oracle with the stacktrace info, operating system, etc. For your immediate needs, you can continue to use the classes111.zip with your 1.2 code. Sorry, I'm fresh out of ideas. I don't have these problems on Solaris or NT...
Best of luck.
Cindy

Josh Gough wrote:

> Cindy,
> I put in the stacktrace and it says it comes from line 20,
> which is: ResultSet rs = stmt.executeQuery(sql);
>
> The query: SELECT * from node
>
> ORA-03120: two-task conversion routine: integer overflow
>
> java.sql.SQLException: ORA-03120: two-task conversion routine: integer
> overflow
>
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:207)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:540)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1285)
> at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:783)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1177)
> at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1321)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1358)
> at
> oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:274)
> at SampleQuery2.main(SampleQuery2.java:20)
>
> If i try to select an int,varchar then i get a slightly
> different error message:
>
> The query: select id,name from node
>
> ORA-03115: unsupported network datatype or representation
>
> java.sql.SQLException: ORA-03115: unsupported network datatype or
> representation
>
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:207)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:540)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1285)
> at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:783)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1177)
> at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1321)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1358)
> at
> oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:274)
> at SampleQuery2.main(SampleQuery2.java:20)
>
> I remember the faq saying something about not all conversions are
> working, but these seems like it just cant deal with multiple
> columns...I saw some other people having problems in linux, but no
> specifics about their select statements.
> Any other thoughts?
>
> Thanks again,
>
> Josh Gough
>
> C. Ferguson wrote:
> >
> > By chance, does the table select return things other than strings?
> > Say, an Integer?
> >
> > This is where the error might be occurring:
> > >> result += rs.getString(i) + " ";
> >
> > In your exception handler, put e.printStackTrace();
> > This will show you the exact line it's dumping at.
> >
> > If you can't get a line number from the stacktrace,
> > use this: java -Djava.compiler=NONE -classpath... yourApp
> > The -D option is telling java to not use the jit compiler, which tends
> > to write (compiled code) instead of line number
> > in the stack trace.
> >
> > Hope this is on the right track and gives you enough clues.
> > Cindy
> >
Received on Wed Aug 04 1999 - 15:21:51 CDT