Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Unanswered: com. ibm. db2. jcc. c. SqlException

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you migrate both the server and the client?

  3. #3
    Join Date
    Mar 2006
    Posts
    2
    Yes I did.
    I figured out that the problem was in the stored procedure SQLTABLES and that it wasnt getting loaded properly.
    However I do not know the cause or the solution.
    Pl help.
    Thx
    Karthik

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •