• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

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

Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
    Bookmark Topic Watch Topic
  • New Topic