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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Saving XML in Oracle Blob Data type" Watch "Saving XML in Oracle Blob Data type" New topic
Author

Saving XML in Oracle Blob Data type

Nirant Chikate
Greenhorn

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,
Nirant.C


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

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

Joined: Feb 05, 2001
Posts: 17250
    
    6

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

JavaRanch Naming Policy.

You can change it

here.

Thanks! and welcome to the JavaRanch!

Mark


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="http://www.objectfirst.com/blog" 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?


Groovy
Vedhas Pitkar
Ranch Hand

Joined: Jan 27, 2001
Posts: 445
We were doing something similar in our project:
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Saving XML in Oracle Blob Data type