aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Help with DB2 Java Stored Procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of RabbitMQ in Depth this week in the Open Source forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Help with DB2 Java Stored Procedures" Watch "Help with DB2 Java Stored Procedures" New topic
Author

Help with DB2 Java Stored Procedures

Max Tomlinson
Ranch Hand

Joined: Jul 17, 2001
Posts: 365
Hi all-
I need to port a big chunk of JDBC functionality off off WAS and directly onto DB2 (v7.2). I'm planning on using JDBC. I woudl really liek to re-use exsiting classes (DAOs) by importing them and calling them in the stored proc.
1) Can I do this?
2) Does anyone have an example of how to import a jar that can be referenced by DB2 java stored procs? I'm having a devil of a time trying to do this...one article I read said I can use:
"sql.alter_jar_path" in my create procesdure statement but this seems to be unavailable in DB2.
If anyone has soem Create Procedure code that does this, I would be eternally greatful.
thansk
Max Tomlinson
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help with DB2 Java Stored Procedures