It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Problem with CLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with CLOB" Watch "Problem with CLOB" New topic

Problem with CLOB

Gus Mus
Ranch Hand

Joined: Feb 28, 2003
Posts: 53
I created an application to insert XML and read the XML back to/from Oracle DB using CLOB & Weblogic.
It's working fine except for some XML that I cannot read it back and got the SQL Exception with Oracle 24334 Error :
ORA-24334 no descriptor for this position
Cause: The application is trying to get a descriptor from a handle for an illegal position.
Action: Check the position number.
For loading / saving other XML it's working really perfect. I tried to analyze the XML but it's correct and no special characters inside.
Ok .. after I analyze it, it seems like if the XML that I saved is too big (more than 23 Kb) then it will fail to read it back, only XML which is smaller that it can read back. The funny thing is I created App without Weblogic (directly use CLOB object not rmi.weblogic.jdbc.rmi.SerialClob) then it can read it properly.
Any help ? Maybe I have to set something in Weblogic Datasource configuration ?
[ August 13, 2003: Message edited by: Gus Mus ]
[ August 13, 2003: Message edited by: Gus Mus ]
I agree. Here's the link:
subject: Problem with CLOB
It's not a secret anymore!