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

Home -> Community -> Usenet -> c.d.o.server -> Problem with JDBC-Type 4 and Linux

Problem with JDBC-Type 4 and Linux

From: Peter Kroiss <pk_at_faw.uni-linz.ac.at>
Date: Mon, 10 Dec 2001 10:41:17 +0100
Message-ID: <3c14816a@news.uni-linz.ac.at>


I often get an unrepeatable error "Refcursor value is invalid" from my jdbc-driver (Oracle) type 4

The statements are not always the same and I cannot repeat this

error. Most of the times the statements, which are very simple, are working fine, but sometimes I get this error.

The same happens with "java.sql.SQLException: Bigger type length than Maximum".

I already search the knowledge base at metalink.oracle.com, the only thing I found is that others

also have the same problems but I didn't finde a patch or a reason why these error occur.

I'm using Oracle 8.1.7 on Linux RedHat. We are using the O/R-Mapping Tool TopLink.

Does anybody have a solution for this?

Peter

Throwable: java.sql.SQLException

message: Refcursor value is invalid

java.sql.SQLException: Refcursor value is invalid

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)

at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:857)

at oracle.jdbc.ttc7.TTCStatement.<init>(TTCStatement.java:41)

at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:469)

at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)

at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)

at

oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.ja

va:182)

at

oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.ja

va:165)

at

oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection

.java:604)

at

oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:4

85) Received on Mon Dec 10 2001 - 03:41:17 CST

Original text of this message

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