Re: using xmltype and jdbc insert

Olaf Raether <olaf_at_raether.de> wrote in message news:<r3b8av4m5hci70n8kjfs5cgb3hc4b866dd_at_4ax.com>...
> Hey,
>
> if you only want to store an XML-File, use CLOB.

Thanks but this fails, do I need to cast the doc? Document doc=XMLUtils.createDocFromStream(is);

            stmt=con.prepareStatement("insert into xml_test values(?)");

            stmt.setClob(1,doc);

Error			The method setClob(int, Clob) in the type PreparedStatement is
not applicable for the arguments (int, Document)	XmlTest.java	blc
framework/WEB-INF/classes	line 36

>
> Olaf Raether
>
> On 21 Apr 2003 06:24:19 -0700, scottb022563_at_hotmail.com (Scott) wrote:
>
> >I am having trouble inserting a document into a table. What is the
> >correct datatype to use for a column specfifed as xmltype? here is a
> >simple exmple below. thanks for the help
> >
> >Scott
> >
> >CREATE TABLE XML_TEST Oracle 9i
> >(
> > DOC SYS.XMLTYPE
> >)
> >
> >
> >import org.w3c.dom.*;
> >
> >InputStream is=PropertiesUtils.loadResourceAsStream("HealthAutoInventoryInputTemplate.xml");
> > Document doc=XMLUtils.createDocFromStream(is);
> > stmt=con.prepareStatement("insert into xml_test
> >values(?)");
> > stmt.set????(1,doc);
Received on Tue Apr 22 2003 - 05:31:40 CDT