webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Problem while calling stored procedure using jdbc adapter connection

  • 1.  Problem while calling stored procedure using jdbc adapter connection

    Posted Tue April 21, 2009 01:12 PM

    Hi,

    my requirement is to invoke a stored procedure by java service.
    I am able to get the jdbc connection using ExecuteService in the java service but when i create the object of OracleCallableStatement using below statement:

    oracle.jdbc.driver.OracleCallableStatement cs = (oracle.jdbc.driver.OracleCallableStatement)conn.prepareCall( sql ); – sql is a procedure name string

    then found following error:

    java.lang.ClassCastException: oracle.jdbc.driver.T4CCallableStatement

    Please let me know how can i execute the procedure successfully.


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Problem while calling stored procedure using jdbc adapter connection

    Posted Mon April 27, 2009 07:32 PM

    This might be a problem with ur jar files(ojdbc14.jar). Please check that part once.

    ~R


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 3.  RE: Problem while calling stored procedure using jdbc adapter connection

    Posted Mon April 27, 2009 07:34 PM

    Hi,

    This might be because of ur ojdbc14.jar files, please check that part once.

    ~R


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards