This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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)