Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> JDBC Thin Drivers Problem

JDBC Thin Drivers Problem

From: Filippo Macchiettini <fm497019_at_silab.dsi.unimi.it>
Date: 3 May 1999 13:40:08 GMT
Message-ID: <7gk8vo$j22$1@pluto.sm.dsi.unimi.it>


Hi,

I have some problems with the Oracle JDBC Thin drivers (1.1.1 classes, I have Oracle 8.0.5 installed under Mandrake Linux 5.3)

Loading Driver, creating the connection & the stametemnt is ok.

When I execute a query with a select on a single column

// Select the ENAME column from the EMP table

    ResultSet rset = stmt.executeQuery ("select ENAME from EMP");

everything seems to work fine.

But when I select more than a column

// Select the ENAME,JOB column from the EMP table
// ENAME & JOB columns are varchar2(20))

    ResultSet rset = stmt.executeQuery ("select ENAME,JOB from EMP");

java returns a SQLexception at the executeQuery line of the source code

java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
        at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a)
        at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)
        at Employee.main(Employee.java:35) 


I have no clue.

Thanks,
Filippo Macchiettini
fm497019_at_silab.dsi.unimi.it Received on Mon May 03 1999 - 08:40:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US