Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Weblogic & CLOB

 
Gus Mus
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using CMP or writing the JDBC by hand?
 
Gus Mus
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using Session Bean + DAO
 
Marcos Maia
Ranch Hand
Posts: 977
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
u may find this linkhelpfull
regards
 
Chris Mathews
Ranch Hand
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Sorry for late reply, was busy...
Thank you for all the good comments, finally I used LONG .. it's easier
and better.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic