wood burning stoves 2.0*
The moose likes BEA/Weblogic and the fly likes Weblogic & CLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Weblogic & CLOB" Watch "Weblogic & CLOB" New topic
Author

Weblogic & CLOB

Gus Mus
Ranch Hand

Joined: Feb 28, 2003
Posts: 53
Hi,
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 ?
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Are you using CMP or writing the JDBC by hand?
Gus Mus
Ranch Hand

Joined: Feb 28, 2003
Posts: 53
I am using Session Bean + DAO
Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
Hi,
u may find this linkhelpfull
regards
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Three comments:
1) It would be easier to help if you posted your JDBC code. Maybe one of us will spot the problem.
2) The problem could be an issue with the JDBC Driver. Have you tried a different Driver?
3) I prefer storing large String objects in an LONG field, I find them easier to work with (as expected there are some tradeoffs).
Gus Mus
Ranch Hand

Joined: Feb 28, 2003
Posts: 53
Hi,
Sorry for late reply, was busy...
Thank you for all the good comments, finally I used LONG .. it's easier
and better.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Weblogic & CLOB
 
Similar Threads
How to read CLOB data from oracle database.
How to handle BLOB and CLOB?
Problem with CLOB
How to handle BLOB and CLOB?
Preserving text format for adding to CLOB