store and retrieve xml in database using JDBC

luri ron

Ranch Hand

Posts: 87

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

what is best way to store/retrieve XML in database using JDBC?

ujjwal soni

Ranch Hand

Posts: 405

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

There are two ways to do this. One is as CLOBs. In
Oracle 9i, these can be indexed and queried with XPath, although I'm not
sure that would be of any use to you. The other way is with an
object-relational mapping using the Oracle XML SQL Utility for Java.

Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"

Consider Paul's rocket mass heater.