Use JDBC to connect to arbitrary DB from java stored procedure

Panoptical · #1 (**permalink**) 04-13-11, 08:12

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?

n_i · #2 (**permalink**) 04-13-11, 08:17

No, you cannot do that.

Panoptical · #3 (**permalink**) 04-14-11, 04:46

I tried it with mysql. It works.

n_i · #4 (**permalink**) 04-14-11, 09:07

Quote:

Originally Posted by Panoptical

I tried it with mysql. It works.

Wasn't your question about DB2 9 Express Edition?

Panoptical · #5 (**permalink**) 04-15-11, 04:42

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)?

Internet Services

Web Development

Digital Marketing

Consumer Tech