Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting Large XML file into Oracle Database through java,Please help

 
sv hari
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

I am trying to insert a large xml file into oracle database through java , i am getting the following error ,please help me to resolve d issue,itz very urgent.

ORA-30676: socket read or write failed
ORA-06512: at "SYS.XMLTYPE", line 5


Following is my code

 
Rob Spoor
Sheriff
Pie
Posts: 20751
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch!

hari java wrote:please help me to resolve d issue,itz very urgent.

Please UseRealWords ("the", "it's" instead of "d", "itz"), and EaseUp. There is no such thing as urgent around here. Also, please UseCodeTags next time. Don't forget to maintain proper indentation. I've added both this time.

Which part of this code is throwing the exception? getXMLString, insertXML, or getCLOB? More importantly, on which line does this exception occur?
 
sv hari
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rob,
Thanks for your reply and for guidance, i am new to this forums, and regarding my post , i am getting the error in the insertXML method.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you tried searching on the oracle error numbers, oracles numbers are usually quite precise, and there are often really helpfull pages out there already.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Unfortunately, in this case the error code does not say much. It seems that the process at the database side crashed (thus the socket error). Some additional info might be in the database logs.

sv hari, are you using the latest Oracle JDBC driver (ojdbc5.jar / ojdbc6.jar)? If not, I'd suggest trying to switch to these drivers first.
 
sv hari
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Martin and Windy ,
Thanks for your suggestios , the issue is resolved with some code changes, and i used the ojdbc14.jar
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you let us know what those code changes are, to help other ranchers, and other people who stumble on this thread searching for help.
 
sv hari
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all ,
The below code worked resolved my issue.


 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic