Re: Stored Procedure - How i can call a Stored Procedure with ARRAY p arameter

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Feb 02 2006 - 13:57:42 EST

  • Next message: Andrus Adamchik: "Re: Performance problem 1.2"

    There may be a few caveats. First the driver mileage may vary on
    that. So, what database are you in?

    But assuming that the driver supports it, you will need to pass the
    IN parameter as java.sql.Array to ProcedureQuery. java.sql.Array is
    an interface and Java provides no default implementation.

    I am not sure how various drivers handle that and whether (like in a
    similar case with BLOB) you can simply provide your own custom
    implementation or you have to actually fetch an array first from the
    DB, and only then pass it around. You need to experiment with that
    and check the driver docs on the details.

    Andrus

    On Feb 2, 2006, at 1:30 PM, Joshua Pyle wrote:

    > very very easily once the procedure is in you cayenne mappings...
    >
    > here is a place to look
    > http://objectstyle.org/cayenne/userguide/stored-procedures/any.html
    >
    >
    > --
    > Joshua T. Pyle
    > Go has always existed.
    >
    >
    > On 2/2/06, Maedler, Silko (dit) <Silko.Maedle..it.de> wrote:
    >>
    >>
    >> Dir all,
    >>
    >> I have the following Stored Procedure
    >>
    >> procedure proc1(parameter VARRAY) is ....
    >>
    >> My question is how i can call this procedures in java/cayenne?
    >>
    >> regards
    >>
    >> Silko
    >

    This archive was generated by hypermail 2.0.0 : Thu Feb 02 2006 - 13:57:45 EST