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