In our application there are input files in xml format and output files in
xml format.
Input files.
Using the DOM parser we parse the file at the application level and insert
data into the database.
Output files.
Using XSL template and PL/SQL procedure in the databse the data will be
picked up and stored as xml file CLOB in the table and the application
picks up this file and send output.
Pl let me know you have furhter queries.I will drill down.
Regards
Bala
Mobile 0415 654 273
Office 02-8845 8617
"Nahid, Nazneen (CORP,
Consultant)" To: "JDJList"
<[EMAIL PROTECTED]>
<Nazneen.Nahid@corpora cc:
te.ge.com> Subject: [jdjlist] XML Parsing.
2002/05/23 09:42
Please respond to
"JDJList"
Hi All,
My requirement goes as follows:-
XML files contain data with which the database has to be updated.
The XML files would be uploaded into the appplications server via the https
file protocol.
Application server is WebSphere . Database is -Oracle.
Dilemma is :-
Should the XML files be parsed in the Application server and the data
extracted from parsing
inserted into the Oracle database using JDBC driver connection
Or
The entire XML file be uploaded into the database via ftp or inserted into
a temporary table
And then using the utility of Oracle XML parser parse the entire file and
insert it into the database.
I am unable to decide which one is advantageous ?
I desperately require the answer.
Nazneen Nahid
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
------------------------------------------
This e-mail is confidential. If you are not the intended recipient, any use,
disclosure or copying of this document is unauthorised and prohibited. If you have
received this document in error, please delete the email and notify me by return email
or by phoning the NEMMCO Helpdesk on 1300 300 295.
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
