Problem calling stored proc in DB2 (Using Visual Age For Java)

[Aju Josep]

Hi,

I am trying to execute a stored proc in DB2 using jdbc. Am getting an error on this stetement:
stmt.execute();
where stmt is an instance of CallableStatement. The Error message is :

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN] SQL10013N The specified library "<name>" could not be loaded.

Where <name> is the name of my stored proc.

Note:
1)the connection is established succesfully and i am also able to execute simeple SQL statements using that connection object.
2) I am writing the code in IBM Visual Age for Java (VAJ).

Is there any settings that has to be made in VAJ ?? The classpath settings of the Drivers seem to be fine, since i am able to get the connection succesfully and am also able to execute simple sql statements.

Any idea ???

Thanks,
Aju

[Bacon]

I do not know much about VA for Java, however, if the error message is accurate, there is something wrong with your call to the stored procedure. It thinks the <name> you are providing is the library, not the stored procedure. The i-series, if that's what you are accessing, is library based not folder based. You identify an object by library/object syntax, at least natively.

I found this link on IBM's site: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/rzaha/javaproc.htm

It did not appear to deal with the library issue, however. It may give you some additional information.

Most operations, by default, use the current library when none is specified.