• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help with DB2 Java Stored Procedures

 
Max Tomlinson
Ranch Hand
Posts: 365
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic