• Post Reply Bookmark Topic Watch Topic
  • New Topic

Help with DB2 Java Stored Procedures  RSS feed

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.
Max Tomlinson
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!