Personally, I would do this in the App server. It is not only more scalable, less platform-dependent, but should also be more efficient since you don't need to store the input temporarily. Furthermore, if this is supposed to be done in a transaction which may involve other db/persistence store changes, it is easier to manage in an app server. However, store it in db first would allow asynchronous and/or batch processing.
My suggestion is that if your app server has enough power to process the input syncrhonously, and transactional support is required, do it in the app server. Hope this helps. -JJ "Nahid, Nazneen (CORP, Consultant)" wrote: > 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
