Two Laptop Bag*
The moose likes JDBC and the fly likes String to XMLType Conversion Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "String to XMLType Conversion" Watch "String to XMLType Conversion" New topic
Author

String to XMLType Conversion

Dibyendu Sarkar
Greenhorn

Joined: Jan 12, 2009
Posts: 25
Hi everyone... I hope everyone's doing good.

I've run into an issue with XMLType. Here's the problem:

I have an XML stored in a XMLType column in the database. I extracted it from the database, did the parsing, did all the modification and now I have an updated XML string that I need to update back into the column I fetched it from. Now this is where I'm stuck. How can I convert a String containing XML into an XMLType object?

Any ideas?

XMLType has this method:

XMLType.createXML(Connection conn, String xmlString).

I'm trying to use this one. Can anyone tell me how to go about getting the first parameter?
If there is a totally different way to do the String -> XMLType conversion, please let me know that as well.

This is a pure Java app and I'm using iBatis.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29241
    
139

Dibyendu,
I vaguely remember reading you can use stmt.setAsciiStream() for this. I don't remember where I read it though so I don't know how well supported it is.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: String to XMLType Conversion
 
Similar Threads
XMLType column with Spring
How to get XMLType column value from Oracle using JDBC ?
XMLType Column Oracle - InsertIntoDB - Exception
HOw to Convert org.w3c.dom.Document to oracle.xdb.XMLType
Oracle's XMLType.createXML() fails...