Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Android Security Essentials Live Lessons this week in the Android forum!
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: 17249
    
    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: 8904

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:
 
jQuery in Action, 2nd edition
 
subject: Saving XML in Oracle Blob Data type
 
Similar Threads
Problems with file upload
Parsing BLOB datatype
Search for Text in a BLOB
how to insert CLOB data type
Urgent..Problem while using java.sql.Blob in JSP