aspose file tools*
The moose likes JDBC 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 Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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