wood burning stoves 2.0*
The moose likes Servlets and the fly likes Java servlet accessing DB2 cobol stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Java servlet accessing DB2 cobol stored procedure" Watch "Java servlet accessing DB2 cobol stored procedure" New topic
Author

Java servlet accessing DB2 cobol stored procedure

Venky Raj
Greenhorn

Joined: May 30, 2002
Posts: 4
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

Joined: Feb 26, 2001
Posts: 4679
    
    7

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

Joined: May 30, 2002
Posts: 4
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java servlet accessing DB2 cobol stored procedure