I am attemptimg to convert an xml document to an oracle table.
I am using the following java program to try to achieve this task.
import oracle.xml.sql.dml.*;
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.jdbc.*;
import java.net.*;
public class xmltest
{
public static void main(String args[]) throws SQLException
{
String tabname = "TRILOAD"; // Table into which to insert xml data
String filename = "c:\\pa_tri.xml\\"; // xml document filename
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Initialize a JDBC connection
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@epen02:1535:DEVDWH","TRI_DBA","TEST");
// Insert XML data from file (filename) into
// database table (tabname)
OracleXMLSave save = new OracleXMLSave(conn, tabname);
URL url = save.createURL(filename);
System.out.println("display :" + filename);
int rowCount = save.insertXML(url);
System.out.println("display :" + url);
System.out.println(" successfully inserted "+rowCount+
" rows into "+ tabname);
conn.close();
System.exit(0);
}
}
The program compiles fine, however when attempting to run it I get the
following error message.
Exception in thread "main" oracle.xml.sql.OracleXMLSQLException: No rows to
mo
fy -- the row enclosing tag missing. Specify the correct row enclosing tag.
at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2532)
at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2402)
at oracle.xml.sql.dml.OracleXMLSave.insertXML
(OracleXMLSave.java:1365)
at xmltest.main(xmltest.java:25)
Anyone have any suggestions on what the problem is.
Any ideas would be appreciated.
-----------------------------------------------------
xml-interest: A list for discussing XML technologies in the Java Platform.
To post, mailto:xml-interest@xxxxxxxxxxxx
Archives at: http://archives.java.sun.com/xml-interest.html
To unsubscribe, mailto:listserv@xxxxxxxxxxxx the following message;
signoff xml-interest.
|