convert xnl node to xml data type

[sent1729]

Hi all,

I am new to java programming. In my application I wanted to convert xml
node to an xml data type. The reason behind doing this is: I wanted to
write this xml node (in to a column of xml data type) with in to a
sequel server 2005 database. I am using JDBC driver (version 4) to
connect to the database. My stored procedure from the database side
accepts only xml data type and not xml Node type. So I wanted to
convert this xml Node to XML data type.

Can any help me with any input.

Thanks
Nathan.

 

[Raymond DeCampo]

Hi all,

I am new to java programming. In my application I wanted to convert xml
node to an xml data type. The reason behind doing this is: I wanted to
write this xml node (in to a column of xml data type) with in to a
sequel server 2005 database. I am using JDBC driver (version 4) to
connect to the database. My stored procedure from the database side
accepts only xml data type and not xml Node type. So I wanted to
convert this xml Node to XML data type.

An XML data type is non-standard, at least from the perspective of JDBC.
Your JDBC driver likely provides non-standard classes to represent
this type, or perhaps uses the existing DOM classes. Consult the
document of your JDBC driver.

HTH,
Ray