|
The sentence in my second paragraph that says: "I would say if the mapping is simple (one table, for instance) then writing the mappings your self would be too hard to do." should have said that it would NOT be too hard to do. Always check your work, huh? ;) ---------------------------------------------------------------------- Chris DeLashmutt Senior R&D Analyst LeasePlan USA 1165 Sanctuary Pkwy., Alpharetta, GA 30004 Phone: 678-202-8695 Fax: 678-566-8551 ---------------------------------------------------------------------- chrisd@xxxxxxxxxxxx m To: Java Programming on and around the iSeries / AS400 Sent by: <java400-l@xxxxxxxxxxxx> java400-l-bounces@m cc: idrange.com Subject: RE: Java and XML 09/24/2003 04:37 PM Please respond to Java Programming on and around the iSeries / AS400 It seems like the process is fairly simple, then. Like you said, there are tons of tools to do this. Personally, I normally tend towards writing something myself before buying something, but that is not always the best course. I would say if the mapping is simple (one table, for instance) then writing the mappings your self would be too hard to do. If the mapping includes parent-child relationships for the data, then the document parsing and creation starts to get complex real quick. There is a free generic framework for doing XML to SQL type mappings (among other things) called Castor (http://www.castor.org). I've never used it, so I can't really comment much on it other to say that it looks flexible, and not entirely straight forward. I have tried IBM's DB2 XML Extenders, and I wasn't too impressed. I can't remember the product's issues perfectly, but there was some kind of size limitation of XML documents that caused me trouble when trying to parse documents larger than 1 meg. Maybe that won't be an issue for you, though. ---------------------------------------------------------------------- Chris DeLashmutt Senior R&D Analyst LeasePlan USA 1165 Sanctuary Pkwy., Alpharetta, GA 30004 Phone: 678-202-8695 Fax: 678-566-8551 ---------------------------------------------------------------------- "Steven Molinaro" <smolinaro@pcrichar To: "'Java Programming on and around the iSeries / AS400'" d.com> <java400-l@xxxxxxxxxxxx> Sent by: cc: java400-l-bounces@m Subject: RE: Java and XML idrange.com 09/24/2003 02:42 PM Please respond to Java Programming on and around the iSeries / AS400 Pretty much same theme throughout all the projects. Send out XML files, usually constructed off of data from our DB2 files, get the response via XML, parse it and then update the DB2 files. -----Original Message----- From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of chrisd@xxxxxxxxxxxxx Sent: Wednesday, September 24, 2003 1:33 PM To: Java Programming on and around the iSeries / AS400 Subject: Re: Java and XML The project requirements really dictate what is the best path to take. If you just need to accept data into a database table, you can certainly do it with Java. However, there are plenty of methods for doing that, each with its own costs and benefits. Perhaps if we heard a bit more about the project and it's requirements, we could all provide you a good suggestion. ---------------------------------------------------------------------- Chris DeLashmutt Senior R&D Analyst LeasePlan USA 1165 Sanctuary Pkwy., Alpharetta, GA 30004 Phone: 678-202-8695 Fax: 678-566-8551 ---------------------------------------------------------------------- "Steven Molinaro" <smolinaro@pcrichar To: <java400-l@xxxxxxxxxxxx> d.com> cc: Sent by: Subject: Java and XML java400-l-bounces@m idrange.com 09/24/2003 01:07 PM Please respond to Java Programming on and around the iSeries / AS400 I am delving into the world of Java at this point mainly for it's good relationship with XML. I don't know however if this the best way on the iSeries though. I know there are parsing APIs that can be used from within RPG and there are XML DB2 Extenders that we can buy and learn how to use too. In your opinion(s), should I use one of those 2 or should I go about this the way I think I should, with pure Java running on the iSeries? As I'm sure the scenario is the same with a lot of you, we are being asked by many of our partners to start transmitting/receiving data in XML format. I've already butchered through one project using RPG where I build and parse, but as you can imagine that was not much fun. I have 3 more projects for similar requests and I would like to go about the right way. _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.