rds,
Marc
-Original Message-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 29, 2008 11:10 AM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
I am surprised about autocommit making a difference vs. a m
Many thanks for your kind assistance,
Best regards,
Marc
-Original Message-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 29, 2008 11:10 AM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
I am surp
lot
Marc
-Original Message-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Monday, April 28, 2008 2:48 PM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
On Apr 28, 2008, at 3:41 PM, Marc Gabriel-Willem wrote:
Dear And
user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
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 usin
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 procedur
roblem, even on error conditions.
>
> Andrus
>
> On Apr 21, 2008, at 6:20 PM, Marc Gabriel-Willem wrote:
>
>> Hi Andrus,
>>
>> We are using intensively the QueryResponse ;)
>>
>> Here is the problem; the call of the 'performGenericQuery' method
>
esday, April 22, 2008 10:06 AM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
Ah, I used the MS driver. Let me also try it with jTDS when I have a
bit more time.
Andrus
On Apr 22, 2008, at 10:59 AM, Marc Gabriel-Willem wrote:
Sent: Monday, April 21, 2008 5:32 PM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
Then I didn't understand your question... In my test cases, using a
manual transaction would prevent an exception and I could read the ou
ssage-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Monday, April 21, 2008 5:32 PM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
Then I didn't understand your question... In my test cases, using a
manual transactio
o be able to handle the output parameters.
Marc Gabriel
-Original Message-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Monday, April 21, 2008 5:09 PM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
QueryResponse is the
situation, we need to be able to handle the output parameters.
Marc Gabriel
-Original Message-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Monday, April 21, 2008 5:09 PM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL
Do you have another idea for us?
Thank you again.
Marc Gabriel
-Original Message-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 20, 2008 5:10 PM
To: user@cayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
I think
enne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
I think I found the problem. It was not a stored procedure call per
se, but a transaction surrounding it. When wrapping a JDBC failing SP
call with "connection.setAutoCommit(false)" and &q
I think I found the problem. It was not a stored procedure call per
se, but a transaction surrounding it. When wrapping a JDBC failing SP
call with "connection.setAutoCommit(false)" and "conneciton.commit()"
I get the same error as with Cayenne. Here is how to handle this in
Cayenne workaro
So Cayenne calls the sp in the following format:
{? = call spXXX(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}
In your JDBC test you do it like this:
{ call spXXX(?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }
I.e. no return value is specified. So what if you uncheck "returning
value" checkbox for this stored proc
st on the fact that the crash occurs when the
called stored procedure does not return any result set.
Thank you again for your help. We appreciate very much.
Marc Gabriel
-Original Message-
From: Andrus Adamchik [mailto:[EMAIL PROTECTED]
Sent: Friday, April 11, 2008 7:09 PM
To: user@c
Hi Marc Gabriel,
For information, using JDBC directly the situation is handled
correctly.
Could you post the JDBC code you used to read the data?
Andrus
On Apr 10, 2008, at 3:36 PM, Marc Gabriel-Willem wrote:
Dear all,
First of all, thank you for your great product. We are using it
Dear all,
First of all, thank you for your great product. We are using it successfully
since last year and we are very happy of the product quality.
Few days ago, we found a problem with our stored procedures access.
In order to illustrate you the problem in the best possible way, I'm
18 matches
Mail list logo
