jQuery in Action, 3rd edition
The moose likes XML and Related Technologies and the fly likes Sybase Database to XML Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Sybase Database to XML" Watch "Sybase Database to XML" New topic

Sybase Database to XML

Alex Iordache
Ranch Hand

Joined: Mar 13, 2001
Posts: 62
I like to know if there is a utility to transfer data from a stored procedure into an XML Document which
could be later sent to client using SOAP. The database used to store data is Sybase. So, the utility
should be Sybase Compliant.
Ajith Kallambella

Joined: Mar 17, 2000
Posts: 5782
You have two ways to go - One is to write such an utility yourself in Java/C++ whatever is your language of choice. Simply get the resultset and format it as an XML document. The advantages of using a home-grown utility is that it will give you better control over performance tuning, customization etc. It can be closely tied to your business processes. The downside however, is that you may be spending time and money in reinventing the wheel.
The second option is to investigate what XML support is offered by the vendor ie., Sybase. I'm sure they will have a plethora of options for XML support. Checkout their Enterprise Integration products. Vendor products always integrate better with other tools/services offered by them when compared with frameworks developed in-house.
Hope that helps!

Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.
IBM Certified Developer - XML and Related Technologies, V1.

Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
I agree. Here's the link: http://aspose.com/file-tools
subject: Sybase Database to XML
jQuery in Action, 3rd edition