Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Shane Lee
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 368
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This seems to be bug with the driver class. Maybe you could go through : http://www.orafaq.com/forum/t/34666/0/
 
Shane Lee
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic