I'm going to weigh in with the classic, "It all depends." If the requirement is that the xml come via http post, I'm going to assume that this request is handled by some servlet. I'm going to further assume, based on the fact that you even have these two options, that the handling of this request can be asynchronous in nature. That is, the xml can be stored somewhere and 'processed' later. Given this, I suggest you consider the use of some industry standard asynchronous communication protocol, for example JMS. Now, if you choose to use a persistent, durable configuration for this, you already have your temporary database storage in the form of a JMS store. You can even take advantage of EJB 2.0 and MDB to manage your transactions and other configuration options. Of course, now we are back to the original question - how to parse? Again, I would look to the most industry standard options available to me and only consider more proprietary solutions if other factors intervened, like performance. Therefore, I would opt first to parse from the application server and use JDBC to persist the information. Given the open choices you have made to this point, you can always switch later if performance, or budget, or other unforseen factors gain influence.
my 2 cents. -----Original Message----- From: Nahid, Nazneen (CORP, Consultant) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 6:42 PM 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
