Re: xml document to oracle table

I don't know, but I have 2 qusetions:

1. Where's does the xml file get read?

2. I sit normal to put a slash

         filename = "c:\\pa_tri.xml\\"

at the end of hte XML file?

At 09:51 AM 11/4/2005 -0700, you wrote:
>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:[email protected]
>Archives at: http://archives.java.sun.com/xml-interest.html
>To unsubscribe, mailto:[email protected] the following message;
>signoff xml-interest.

-----------------------------------------------------
xml-interest: A list for discussing XML technologies in the Java Platform.
To post, mailto:[email protected]
Archives at: http://archives.java.sun.com/xml-interest.html
To unsubscribe, mailto:[email protected] the following message;
signoff xml-interest.