Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    3

    Unanswered: Use JDBC to connect to arbitrary DB from java stored procedure

    Is it possible to use JDBC to connect to an arbitrary DB, say Mysql, from inside a java stored procedure in db2 9 express? I am asking because in the documentation it says: "Connection level APIs cannot be called from within external functions or external methods." and I have no idea what this is supposed to mean.
    Where would I put the mysql jdbc driver jar file? Can I upload it using the jar uploader stored procedure?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    No, you cannot do that.

  3. #3
    Join Date
    Apr 2011
    Posts
    3

    yes, you can

    I tried it with mysql. It works.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Panoptical View Post
    I tried it with mysql. It works.
    Wasn't your question about DB2 9 Express Edition?

  5. #5
    Join Date
    Apr 2011
    Posts
    3
    Yes. I created a java stored procedure on a DB2 Express-C which connects to a mysql database using jdbc.
    Would this not work on a DB2 Express (without the C)?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •