• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

Aju Josep
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I am trying to execute a stored proc in DB2 using jdbc. Am getting an error on this stetement:
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.

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

Ranch Hand
Posts: 305
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!