• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

defining stored procedure call in xml for Sybase

 
Swapnil Shroff
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any java api available that I can use to define database sp calls in xml and fire them against a Sybase server. If yes how to use it.

Thanks in advance.
 
Swapnil Shroff
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
More details

I have a requirement where by I need to call existing legacy stored procedure on Sybase database on from java and calls are defined in XML.

I want to store the database call in XML format and store result set returned into a map object as key value pairs, where column name is a key and then have a list of these map objects.
Also, it is possible that procedure may not return any result set. In that case only sp should be executed(may be a insert sp).
Also I don't want to create any hierarchy of vo objects. The call should be direct to database.

How can I achieve this using iBatis/hibernate/any other tool. Please advice.
 
Paul Clapham
Sheriff
Posts: 21583
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Swapnil Shroff:
How can I achieve this using iBatis/hibernate/any other tool.
Yes, I didn't really think this was an XML question. Let's move it to the forum about iBatis and Hibernate and so on.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic