File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
jQuery in Action, 3rd edition