Error when adding and then removing object from relationship before committing

2008-04-29 Thread Brian Nelson
Let me start this post by thanking the Cayenne dev team for their great work. The project I'm working on switched from Hibernate to Cayenne several months ago. I can honestly say the decision to switch is one of the best things that ever happened to my project. Now on to my problem... I have a

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

2008-04-29 Thread Andrus Adamchik
I tried it again, but the sample stored procedure that you sent me does not blow until commit phase, so the exception is different and the behavior is different. Now the auto-commit... yeah, I traced down the reset of auto-commit flag. It happens in Cayenne code right after "willAddConnecti

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

2008-04-29 Thread Marc Gabriel-Willem
Dear Andrus, Yes this is very disappointing since manual transaction with no autocommit does not work for us. Perhaps we need to clarify this? At this point, the only working way is to use directly JDBC with autocommit (which is not an option for us). Neither the use of manual transaction with n

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

2008-04-29 Thread Andrus Adamchik
I am surprised about autocommit making a difference vs. a manual transaction with no autocommit, as the later worked for me in my previous test, so now everything I say is just a guess. One other difference that I noticed is that I tested using Cayenne 3.0 trunk (soon to be M4), and you are

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

2008-04-29 Thread Marc Gabriel-Willem
Hello Andrus, We've set the autocommit to true using a TransactionDelegate but somehow, it appears the flag is later on reset automatically to false. As you advised, the autocommit has been set to true in willAddConnection, but when didRollback or didCommit is called, we figured out the flag has b

Re: "Is" Expression

2008-04-29 Thread Andrus Adamchik
Try this: Expression expression = ExpressionFactory.matchExp("actif", Boolean.TRUE); I don't remember how good was the boolean support in 2.0.x, but the above works for me with Cayenne 3.0 and MySQL 5 rather well. Andrus On Apr 29, 2008, at 11:34 AM, Support Technique C3T wrote: Hi

"Is" Expression

2008-04-29 Thread Support Technique C3T
Hi I'm new with this great ORM and I'm looking for a way to select rows where a column is true. I use Cayenne 2.0.4 with MySQL 5.0 I created a table with a boolean column. I inserted rows in it with Cayenne. But i wanted to select rows but I didn't find a ExpressionFactory method like tha