File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Problem calling stored proc in DB2 (Using Visual Age For Java) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem calling stored proc in DB2 (Using Visual Age For Java)" Watch "Problem calling stored proc in DB2 (Using Visual Age For Java)" New topic
Author

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

Aju Josep
Greenhorn

Joined: Feb 20, 2004
Posts: 17
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
Ranch Hand

Joined: Jul 14, 2004
Posts: 305
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem calling stored proc in DB2 (Using Visual Age For Java)