| OracleXMLSave Problem [message #91255] |
Mon, 17 June 2002 22:14  |
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 #91574 is a reply to message #91255] |
Wed, 20 November 2002 06:14  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
