🚀 go-pugleaf

En fait j'ai presque resolu mon probleme avec ce code. Les champs ID et NOM 
font partie d'une table et les PAYS et VILLE d'une autre.
Je ne sais pas comment faire pour inserer uniquement les champs ID et NOM 
dans la table concernee.

Voila l'erreur :
oracle.xml.sql.OracleXMLSQLException: Exception ' The XML element tag 
'PAYS' does not match the name of any of the columns/attributes of the 
target database object.' encoutered during processing ROW element 0All 
prior XML row changes were rolled back. in the XML document
at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:1962)
at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:1880)
at oracle.xml.sql.dml.OracleXMLSave.insertXML(OracleXMLSave.java:1013)

Code java :

import oracle.xml.sql.*;
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.jdbc.*;
import java.net.*;
public class put
{
   public static void main(String argv[])
     throws SQLException
   {
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	Connection conn = 
DriverManager.getConnection("jdbc:oracle:oci8:admin/admin@test");
     	String tabName = "TEST";   // table into which to insert
	String fileName = "put.xml";   // the file containing the XML doc
	OracleXMLSave sav = new OracleXMLSave(conn,tabName);
	String [] colNames = new String[2];
    	colNames[0] = "ID";
	colNames[1] = "NOM";
	sav.setUpdateColumnList(colNames); // set the columns to update..!
	sav.setIgnoreCase(true);
	URL url = sav.createURL(fileName);
	int rowCount = sav.insertXML(url);
	System.out.println(" successfully inserted "+rowCount+" rows into 
"+tabName);
     conn.close();
   }
}

Fichier put.xml :
<?xml version = '1.0'?>
<ROWSET>
   <ROW>
      <ID>1</ID>
      <NOM>toto</NOM>
      <PAYS>france</FRANCE>
	<VILLE>Paris</VILLE>
   </ROW>
</ROWSET>

Merci d'avance pour vos reponses.

-- 
Posted from brest.ifremer.fr [134.246.155.1] 
via Mailgate.ORG Server - http://www.Mailgate.ORG