It's not a secret anymore!
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
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
 
Have you checked out Aspose?
 
subject: Help with DB2 Java Stored Procedures
 
It's not a secret anymore!