• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java servlet accessing DB2 cobol stored procedure

 
Venky Raj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am working on a project, we have the DB2 database,and our business rules are complex, hence we have to use stored procedures(as one user request will have multiple quries and computations) and then we get results out.
Can anyone pls tell me where I can find Stored procedures (prefreably DB2 cobol) being triggered by Java servlets.
Also any suggestions are welcome to use EJB or java beans.
Also since the result is not a single result set , we are planning to send out a XML string as a result set.(websphere is our server).
Thanks
Venky
 
Junilu Lacar
Bartender
Posts: 7606
54
Android Eclipse IDE IntelliJ IDE Java Linux Mac Scala Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My current project is exactly the same: DB2, WAS, and stored procs. DB2 stored procs can return multiple result sets so I don't see a need to complicate things by returning XML, unless you have some easy way to do that.
Junilu
 
Venky Raj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Junilu,
Thanks for the reply, I am using the XML string because the data from the result sets need to be processed and sent out from stored procedure.
Can you please give me sample code for triggering the stored procedure.
Thanks
Venky
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic