• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

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

 
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:
 
Ranch Hand
Posts: 368
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic