Running SQLJ procedure on third party tool

0
votes

How can we execute call sqlj.install_jar('jarpath','jarname','0'); procedure on third party java tools?

I am trying to run this procedure on DBeaver to install the jar file.

But error I am getting:

  • No authorized routine named "SQLJ.INSTALL_JAR" of type "PROCEDURE" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884

Is it possible to execute the sqlj commands on third party tool?

I used to install it by logging into Db2 server and execute the command.

1
stored-proceduresdb2
Your description of the problem is not clear absolutely. Nobody can help you, if the only description of your problem is "not working". Why do you add db2jcc.jar with this routine, if your third party tool must have its own jar(s)? Namely this jar must be added with this routine. Does this "tool" itself require the database connection, and how does it use this connection exactly? How did you add this jar exactly? Please, edit your question with all such an information. – Mark Barinstein
@MarkBarinstein Updated the querstion – Db2Cramp
Can you run the query in the DB2CMD window (if MS-Windows) or bash shell (if Linux)? (you may need to omit the third argument if calling from the shell). – mao

1 Answers

0
votes

There is no such a routine with 3 parameters indeed. Refer to the following link:
JAR file administration on the database server.

CALL sqlj.install_jar('file:/home/bob/bobsjar.jar', 'MYJAR')

Jar file must be accessible from the database server by the full path provided with the 1-st parameter.