Re: Stored proc returning result set (and output params) with MS SQL server

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Apr 28 2008 - 08:47:50 EDT

  • Next message: Support Technique C3T: ""Is" Expression"

    On Apr 28, 2008, at 3:41 PM, Marc Gabriel-Willem wrote:

    > Dear Andrus,
    >
    > Have you got a chance to work on the problem?

    No, not yet.

    > For a summary, our investigations show that using JDBC, the 'auto
    > commit' attribute set to 'true' solve the problem. Is it possible to
    > execute the stored procedure using that behavior? We already looked to
    > set that flag to a particular connection within cayenne, but without
    > any
    > success...

    You may try using a TransactionDelegate that sets autocommit to true
    based on some ThreadLocal variable state from within
    'willAddConnection':

        http://cayenne.apache.org/doc/understanding-transactions.html

    Andrus

    This archive was generated by hypermail 2.0.0 : Mon Apr 28 2008 - 08:48:22 EDT