Hi Nazneen,
I believe your dilemma should be analyzed according to the requirements. From what you have said, it does not sound like you have to apply any "business logic" processing to the data - which makes it ideal to let Oracle handle the xml parsing and inserting in a very straight forward, and extremely fast manner.
However, if you do have a lot of processing that can not be applied to the xml by utilizing xsl (which Oracle also allows you), then I would have to say that you should do it in the AppServer or at least in Java
If your parsing/inserting requirements can be overcome by a combination of xsl and Oracle, then I would highly recommend doing it that way, let Oracle work, that's what it was made for
-----Original Message-----
From: Nahid, Nazneen (CORP, Consultant)
[mailto:[EMAIL PROTECTED]]
Sent: 23 May 2002 1:42 AM
To: JDJList
Subject: [jdjlist] XML Parsing.
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
To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
