File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Oracle 10g JDBC Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle 10g JDBC Error " Watch "Oracle 10g JDBC Error " New topic
Author

Oracle 10g JDBC Error

Rajeev Iyer
Ranch Hand

Joined: Jun 19, 2002
Posts: 42
Hi,

I am facing a problem when executing an oracle function that returns a ref cursor from Weblogic 8.1 SP4 with JRockit.
The error reads "Java.sql.SQLException:Bigger type length than maximum" when the first request is fired.when i fire the same request again, the error changes to "Java.sql.SQLException ALL8 is in an inconsistent state".
I am using the oracle thin driver versions :9.0.1,9.2.0,10 which is available when configuring the JDBC connetion pool from the weblogic console.

Can anyone help me out with this.

Thanks
Rajeev
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


ALL8 is in an inconsistent state

This usually happens when you try to access a v9i database with v10i thin driver. Get the latest 10i driver from Oracle's site - I think they fixed this issue.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Rashid Darvesh
Ranch Hand

Joined: Feb 13, 2004
Posts: 189
I too have the same problem,
we upgraded our database to Oracle9i Enterprise Edition Release 9.2.0.7.0. i tried with oracle 9i and 10g both ojdbc14.jar file and nothing helps. i am using a stmt.registerOutParameter(1, OracleTypes.CURSOR); to get an output as a cursor. BTW i am using weblogic 8.1

Any help on this
Srini Tanikonda
Greenhorn

Joined: Jun 09, 2006
Posts: 1
I am also facing same problem. Can somebody please help. It is very Urgent

We are using the 9.0.2.0.0 Thin Driver -- Websphere6.0 and Redhot Linux

The problem is with the REF_CURSOR.


Regards
Srini
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle 10g JDBC Error
 
Similar Threads
SQL Exception Weblogic9.1 Oracle 10g
Error Using JDrivers to Connect to Oracle
using JDBC in WEBLOGIC
Debug an Oracle procedure fired from JDBC?
What is it?