This week's book giveaway is in the
We're giving away four copies of
Node.js in Action
and have Mike Cantelon, Marc Harter, T.J. Holowaychuk and Nathan Rajlich on-line!
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Node.js in Action
this week in the
Saving XML in Oracle Blob Data type
Joined: Mar 16, 2006
Mar 16, 2006 08:31:00
I would really appriciate if someone provides me the source code to save an XML
in Oracle Blob Data type.
Thanks and Regards,
Thanks and Regards, <br /> Nirant
Joined: Jul 01, 2004
Mar 16, 2006 09:42:00
Joined: Feb 05, 2001
Mar 16, 2006 13:47:00
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
How to Ask Questions the Smart Way FAQ
Joined: Feb 28, 2001
Mar 16, 2006 23:40:00
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..
Writer writer = clob.getCharacterOutputStream(); writer.write(.....); writer.flush();
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>
Joined: Feb 27, 2002
Mar 17, 2006 00:02:00
What do you feel about native XML databases for storing XML ? Do you think that they will get popular?
Joined: Jan 27, 2001
Mar 17, 2006 01:40:00
We were doing something similar in our project:
//Convert xml object to a clob cs = con.prepareCall("begin DBMS_LOB.CREATETEMPORARY(?, TRUE, DBMS_LOB.SESSION); end;"); cs.registerOutParameter(1, OracleTypes.CLOB); cs.execute(); oracle.sql.CLOB xmlClob = (oracle.sql.CLOB)cs.getClob(1); xmlClob.putString(1, xml); cs.execute(); stmt.setObject(1, xmlClob);
subject: Saving XML in Oracle Blob Data type
Urgent..Problem while using java.sql.Blob in JSP
Parsing BLOB datatype
how to insert CLOB data type
Problems with file upload
Search for Text in a BLOB
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014