Store Procedure call

Discussions

EJB programming & troubleshooting: Store Procedure call

  1. Store Procedure call (1 messages)

    Hi,

    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:
    com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "CLIENTREPORT" could not be loaded



    Anybody any ideas?

    Steve

  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.


    Prasath

    [email protected]