File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes com. ibm. db2. jcc. c. SqlException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "com. ibm. db2. jcc. c. SqlException " Watch "com. ibm. db2. jcc. c. SqlException " New topic
Author

com. ibm. db2. jcc. c. SqlException

Karthik Krishnamurthy
Ranch Hand

Joined: Feb 04, 2005
Posts: 118
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

Joined: Feb 04, 2005
Posts: 118
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: com. ibm. db2. jcc. c. SqlException