Re: DB2 stored procedure

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jun 16 2010 - 08:41:33 UTC

  • Next message: Andrus Adamchik: "Re: Cayenne with Axis2: Mysql connection Problems"

    I don't know much about DB2, but this procedure from our unit tests
    works:

    http://svn.apache.org/repos/asf/cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/db2/create-select-sp.sql

    Maybe that will give you some ideas.

    Andrus

    On Jun 15, 2010, at 8:35 AM, Juergen Saar wrote:

    > I have the same problem with Informix ... still using a
    > SQLTemplate ...
    >
    > 2010/6/14 Kuhns, John <jkuhn..imntls.com>
    >
    >> I am attempting to call a DB2 stored proc that returns a result
    >> set, so far
    >> no luck. The procedure takes two input params, and the docs imply
    >> I'm doing
    >> this correctly, but I must be missing something.
    >>
    >> For now I am using a SQLTemplate query and building the call
    >> statement on
    >> the fly. I'd like to know the "correct" way to do it, however,
    >> since I am
    >> integrating with a legacy system with a lot of oddities in date/
    >> time formats
    >> and normalization that I'd like to use stored procs to get around.
    >>
    >>

    This archive was generated by hypermail 2.0.0 : Wed Jun 16 2010 - 08:42:14 UTC