aspose file tools*
The moose likes JDBC and the fly likes Error java.sql.SQLException: Bigger type length than Maximum Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error java.sql.SQLException: Bigger type length than Maximum " Watch "Error java.sql.SQLException: Bigger type length than Maximum " New topic
Author

Error java.sql.SQLException: Bigger type length than Maximum

Shane Lee
Ranch Hand

Joined: Mar 19, 2005
Posts: 63
My version of oracle is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
When i perform stored function call using xml table i get that error above.

I am calling the function in my java application, jdk 1.5 >> oracle driver class is in the jar ojdbc14, this jar file i downloaded from the oracle website.
i ran the select statement select * from all_registry_banners; and it looks like there is a JVM and xml database version. Is it a problem due to the fact i am using a CLOB as a parameter?

The funny thing is that if i use a later version for oracle class driver ojdbc14-10.2.0.2 downloaded from findjar.com i get a different error:


I am really lost, please help!

Regards,
Shane.

my java code is:


stored function is:
Satya Maheshwari
Ranch Hand

Joined: Jan 01, 2007
Posts: 368
This seems to be bug with the driver class. Maybe you could go through : http://www.orafaq.com/forum/t/34666/0/


Thanks and Regards
Shane Lee
Ranch Hand

Joined: Mar 19, 2005
Posts: 63
Haha, thanks for the reply Satya. You try and keep things compatiable as in use the correct driver with your version of software and it does not work, but when you use a later version it does!! The later version actually gives me a different error but i know why, its due to setting a string in my callable statement, when it should be a CLOB.

So just have to look into how to set a clob in jdbc for a string!

Regards,
Shane.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error java.sql.SQLException: Bigger type length than Maximum
 
Similar Threads
CallableStatement resultset returns only columns and no data, where data exists.
Facing the problem while reterving the resultsets in java from named query function in hibernate
Field display problem
cursor?
Does Oracle LOBs support streams ?