Hi All,
If you want to validate your xml files agaist DTD/SCHEMA you need to do it
application sever level.If u r not doing an validation then what Nazneen
recommends seems to be a good idea.i.e oracle handles.
Regards
Bala
Mobile 0415 654 273
Office 02-8845 8617
Alwyn Van Niekerk
<AlwynVa@discoveryhea To: "JDJList"
<[EMAIL PROTECTED]>
lth.co.za> cc:
Subject: [jdjlist] RE: XML
Parsing.
2002/05/23 14:23
Please respond to
"JDJList"
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
------------------------------------------
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
