It's not a secret anymore!*
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 Android Security Essentials Live Lessons this week in the Android 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
 
Similar Threads
Java and DB2
DB2 Stored procedures written in Java
Calling DB2 stored procedures
WAS and DB2 connectivity details
DB2 Stored procedure build error