Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

com.ibm.db2.jcc.c.SqlException

Status
Not open for further replies.

lindabaja

Programmer
Mar 15, 2006
1
US
Hi,
I just migrated from DB2 7.2, FP 13 on Windows 2000 to DB2 8.1, FP2 on XP.

When I try to get the table list using database metadata I am getting the following exception

com.ibm.db2.jcc.c.SqlException: The load module name for the stored procedure on the server is not found. Please contact your dba.

Code is as follows :

Class.forName("com.ibm.db2.jcc.DB2Driver");
Connection c = DriverManager.getConnection(...)
S.o.pln("Connection there");
DatabaseMEtaData d = c.getMetaData();
S.o.pln("DBMD there");
ResultSet rs = d.getTables(null,"PMA",null,new String[]{"TABLE"});

I am getting the connection and the DBMD but its causing exception at the ResultSet as above.
I have all the necessary drivers in the class path.

Any help will be greatly appreciated.

Thx
Karthik
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top