Store Procedure call


EJB programming & troubleshooting: Store Procedure call

  1. Store Procedure call (1 messages)


    I am trying to call a DB2 Stored Procedure, "CLIENTREPORT" from a session bean.
    Using IBM VisualAge for Java.
    When I run the test client to test the bean I get the error message:

    Exception is:
    java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
    java.rmi.RemoteException: Couldn't complete client inquiry; nested exception is: A database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "CLIENTREPORT" could not be loaded

    Anybody any ideas?


  2. I think there is a problem with the Driver to connect to your DB2.See if they are connected properly. Here again you require RMI JDBC driver and not the JDBC -ODBC bridge.


    [email protected]