Re: Bulk Updates in Oracle from XML File
From: Peter Connolly (peter_at_alum.wpi.edu)
Date: 12/24/03
- Next message: Peter Connolly: "Re: known bugs with Oracle's JDBC?"
- Previous message: ITM: "JDBC/ODBC user issues accessing SQL Server 2000 database"
- In reply to: Kiran Dalvi: "Bulk Updates in Oracle from XML File"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 24 Dec 2003 11:01:37 -0800
Have you looked into using the Statement.addBatch and
Statement.executeBatch methods of the latest versions of jdbc? I
think you would still need to use a typical insert statement with
these, but they may give you the performance benefits you are looking
for.
-Peter
rayoflight_kiran@yahoo.com (Kiran Dalvi) wrote in message news:<b33f94a.0312240102.3940d3e5@posting.google.com>...
> Hi,
>
> I have following problem scenario .....
>
> I have a XML of the format ....
> <Data>
> <Employee>
> <EmpName>Kiran</EmpName>
> <EmpID>100</EmpID>
> </Employee>
> <Employee>
> <EmpName>Faheem</EmpName>
> <EmpID>1000</EmpID>
> </Employee>
> ..
> ..
> .. ..... I have such 30000+ blocks corressponding to 30000+
> Employees.
> </Data>
>
> Now, I have a DB design with following columns .....
> 1) EmpName Varchar2(64)
> 2) EmpID Number(64)
>
>
> Here I want to parse this XML and persist the data from that XML into
> DB "efficiently".
> I don't want to use conventional INSERTs.
>
> How can I go about it ?
>
> Thanks,
> --Kiran
- Next message: Peter Connolly: "Re: known bugs with Oracle's JDBC?"
- Previous message: ITM: "JDBC/ODBC user issues accessing SQL Server 2000 database"
- In reply to: Kiran Dalvi: "Bulk Updates in Oracle from XML File"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
