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
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 364
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Help with DB2 Java Stored Procedures
 
Similar Threads
WAS and DB2 connectivity details
Calling DB2 stored procedures
DB2 Stored procedures written in Java
Java and DB2
DB2 Stored procedure build error