aspose file tools*
The moose likes JDBC and the fly likes Saving XML in Oracle Blob Data type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Saving XML in Oracle Blob Data type" Watch "Saving XML in Oracle Blob Data type" New topic

Saving XML in Oracle Blob Data type

Nirant Chikate

Joined: Mar 16, 2006
Posts: 2
Hi All,
I would really appriciate if someone provides me the source code to save an XML string in Oracle Blob Data type.

Thanks and Regards,

Thanks and Regards, <br /> Nirant
Rajan Chinna
Ranch Hand

Joined: Jul 01, 2004
Posts: 320
check this
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17257

"Itz Nirant"-
Welcome to the JavaRanch! Please adjust your displayed name to meet the

JavaRanch Naming Policy.

You can change it


Thanks! and welcome to the JavaRanch!


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Gagan Indus
Ranch Hand

Joined: Feb 28, 2001
Posts: 346
I am not sure if the mentioned link already emphasizes it, but one thing i found especially helpful when dealing with XML and CLOB columns was the ability to get a output stream and write to it..

The similar thing is possible with BLOBs, just refer to javadocs. I am curious, why would you choose BLOB over CLOB for storing XML data, which is i believe by nature is character oriented?

Gagan (/^_^\) SCJP2 SCWCD IBM486 <br />Die-hard JavaMonk -- little Java a day, keeps you going.<br /><a href="" target="_blank" rel="nofollow">My Blog</a>
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

What do you feel about native XML databases for storing XML ? Do you think that they will get popular?

Vedhas Pitkar
Ranch Hand

Joined: Jan 27, 2001
Posts: 445
We were doing something similar in our project:
subject: Saving XML in Oracle Blob Data type