Home » Developer & Programmer » JDeveloper, Java & XML » Re: Loading XML into database
Re: Loading XML into database [message #91099] Thu, 04 April 2002 20:58
Sunil Dua
Messages: 1
Registered: April 2002
Junior Member
Here below is the program which runs well. Hope it will help:

import java.sql.*;
import oracle.xml.sql.query.OracleXMLQuery;
import oracle.xml.sql.dml.OracleXMLSave;
import java.io.*;

public class testInsert
{
public static void main(String argv[[]]) throws SQLException
{
Connection conn = getConnection("law1","law1");
OracleXMLQuery qry = new OracleXMLQuery(conn,"SELECT name as T, Reptype as C FROM Key_reptype");
String str = qry.getXMLString();
try{
OracleXMLSave sav = new OracleXMLSave(conn, "law1.titles");
sav.insertXML(str);
sav.close();
}catch(Exception ex){System.out.println(ex.toString());}
}
private static Connection getConnection(String username, String password)
throws SQLException
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@portal:1521:star", username,password);
return conn;
}
}
Previous Topic: One connection question
Next Topic: Re: Where can i get the Oracle thin driver
Goto Forum:
  


Current Time: Wed Jul 28 20:54:57 CDT 2021