Jar for DB2 type 2 driver

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • exp123
    New Member
    • Jan 2012
    • 2

    Jar for DB2 type 2 driver

    Hi,

    After installing DB2 client i got below 4 jar files,

    1.db2jcc_licens e_cu.jar
    2.db2jcc.jar
    3.db2jcc4.jar
    4.db2java.zip

    I need to call SP which returns value , have to use type 2 driver.
    I set db2jcc_license_ cu.jar,db2jcc.j ar,db2java.zip in class path.

    Class.forName(" com.ibm.db2.jcc .DB2Driver");

    Connection connection= DriverManager.g etConnection("j dbc:db2:DB2D"," username","pwd" );

    But getting " SQL0440N No authorized routine named "PROCEDURE" of type "XXX" having compatible arguments was found. SQLSTATE=42884 " error..

    Whether correct jar files are set in class path??
    Please guide me on this..

    Thanks in advance.
    Last edited by exp123; Jan 16 '12, 04:52 PM. Reason: Adding code
Working...