Win a copy of Java Database Connections & Transactions (e-book only) this week in the JDBC forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

Sybase Database to XML  RSS feed

 
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
pie. tiny ad:
how do I do my own kindle-like thing - without amazon
https://coderanch.com/t/711421/engineering/kindle-amazon
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!