Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

com. ibm. db2. jcc. c. SqlException

 
Karthik Krishnamurthy
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Karthik Krishnamurthy
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I also found out that the reason behind this is failure to load the Stored procedure SQLTABLES. But I still dont know why.

Pl help
Thx
KArthik
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic