Home » Developer & Programmer » JDeveloper, Java & XML » OracleXMLSave Problem
OracleXMLSave Problem [message #91255] Mon, 17 June 2002 22:14 Go to next message
Mandy
Messages: 4
Registered: May 2002
Junior Member
I meet problems when using OracleXMLSave.
I read an XML file and want to insert the data directly to a table in Oracle. Following is the code I used.
OracleXMLSave sav = new OracleXMLSave(dbConnection, "IMPORT_TABLE'");
sav.insertXML("http://192.168.15.24/import/test.xml");
sav.close();

However, the following error occurs:
Error Code : 500
Error Details : javax.servlet.ServletException: oracle/jdbc2/Clob

Does anyone know what the problem is?
Thank you very much!
Re: OracleXMLSave Problem [message #91266 is a reply to message #91255] Sun, 23 June 2002 23:22 Go to previous messageGo to next message
mandge omprakash
Messages: 1
Registered: June 2002
Junior Member
hi sir i wants reply to this message
Re: OracleXMLSave Problem [message #91574 is a reply to message #91255] Wed, 20 November 2002 06:14 Go to previous message
David
Messages: 110
Registered: November 1998
Senior Member
I encountered the same problem. I am using the Oracle XML SQL utility against a non-oracle database.

Even though I do not connect to Oracle, I added classes12.zip (oracle jdbc driver) to the classpath. This provides the Clob.class needed for the xsu. I did this by copying classes12.zip to my JRElibext directory.

BTW, I used the Oracle 8.1.7 jdbc driver.

Hope this helps.
Previous Topic: how to store xml file into database?
Next Topic: Banner , Outdoors , Gifts , Silkscreen ,
Goto Forum:
  


Current Time: Fri Mar 29 01:27:04 CDT 2024