Re: Transactions

2024-11-13 Thread Christian Gonzalez
2024 at 3:55 PM John Huss wrote: > On Mon, Nov 11, 2024 at 2:58 PM Christian Gonzalez < > christian.gonza...@smartscrubs.com> wrote: > > > Hi John, I tried making the transaction using the transaction factory and > > the changes that the objectContext committed were stil

Re: Transactions

2024-11-13 Thread Christian Gonzalez
t need to change the > setting for the whole CayenneRuntime. > > On Wed, Nov 13, 2024 at 12:01 PM Christian Gonzalez < > christian.gonza...@smartscrubs.com> wrote: > > > At some point we turned it on because there was a procedure that caused > > issues since it handl

Re: Transactions

2024-11-11 Thread Christian Gonzalez
gt; context.commitChanges(); > tx.commit(); > > } catch (Exception e) { > tx.rollback(); > throw e; > } > > On Fri, Nov 8, 2024 at 5:21 PM Christian Gonzalez < > christian.gonza...@smartscrubs.com> wrote: > > > Also forgot to mention but the runtime is

Re: Transactions

2024-11-08 Thread Christian Gonzalez
Also forgot to mention but the runtime is configured with external transactions enabled. On Fri, Nov 8, 2024 at 4:14 PM Christian Gonzalez < christian.gonza...@smartscrubs.com> wrote: > Hello, I am currently using cayenne 4.2 and am running into some issues > when committing my chan

Transactions

2024-11-08 Thread Christian Gonzalez
Hello, I am currently using cayenne 4.2 and am running into some issues when committing my changes. We have an application that uses a single object context to do all the necessary changes we want to save to the database and then when the user clicks the save button we call the objectContext.commit

Re: Complicated SQL queries

2024-02-07 Thread Christian Gonzalez
yE.PROP ) > .eq( someValue ) > ) > .select( context ) > > > > > On Wed, 07 Feb 2024 19:25:34 +0200, Christian Gonzalez > wrote: > > > One last question, I was trying to update another query using the same > > method of identifying the wanted column

Re: Complicated SQL queries

2024-02-07 Thread Christian Gonzalez
One last question, I was trying to update another query using the same method of identifying the wanted columns when trying to fetch from a different ObjectEntity than the one from the ObjectSelect. The issue seems to be that the column I'm selecting is the pk column of another ObjectEntity? The qu

Re: Complicated SQL queries

2024-02-06 Thread Christian Gonzalez
; with: > > List< OBJECT_E > results = ObjectSelect.query( ObjEntityA.class ) > .columns( ) > .where( ) > .map( col -> createObjectE( col ) ) > .select( context ); > > > > On Wed, 31 Jan 2024 18:26:46 +0200, Christian Gonzalez > wrote: > > &

Re: Complicated SQL queries

2024-01-31 Thread Christian Gonzalez
> .dot( ObjEntityD.PROP_B ) > .eq( "somevalue" ) ) > .select( context ); > > Regards > Jurgen > > > From: Christian Gonzalez > Sent: Tuesday, 30 January 2024 18:22 > To: user@cayenne.apache.org > Subject: Re: Complicated SQL queries > > S

Re: Complicated SQL queries

2024-01-30 Thread Christian Gonzalez
J_B.dot( ObjEntityB.PROP_FOR_OBJ_C ).dot( > ObjEntityC.PROP_FOR_OBJ_D ) > .dot( ObjEntityD.PROP_B ) // this is t3.varB > .eq( "somevalue" ) ) > .select( context ); > > > > On Fri, 19 Jan 2024 22:45:24 +0200, Christian Gonzalez > wrote:

Re: Complicated SQL queries

2024-01-19 Thread Christian Gonzalez
Looks like it worked, thank you. It is definitely an interesting way of doing it although I'm not sure about how I feel about having to make a new entity every time a query like this is used but hopefully it won't be too often. Thank you for your help. On Wed, Jan 17, 2024 at 11:08 AM Jurgen Dol

Re: Complicated SQL queries

2024-01-17 Thread Christian Gonzalez
quot; button (above the relationship lists) > 10. Click on "Done" (bottom right) and repeat for next attribute > > Regards > Jurgen > > > On Tue, 16 Jan 2024 17:58:23 +0200, Christian Gonzalez > wrote: > > > Yes, > > > > First I would like to ame

Re: Complicated SQL queries

2024-01-16 Thread Christian Gonzalez
as its respective reverse relationship. t3 has its relationship with t2 on a single variable/attribute and then we use t3 to evaluate. Please let me know if there is any additional info you might need. Thank you, Christian Gonzalez On Sun, Jan 14, 2024 at 12:33 PM Andrew Lindesay wrote: > Hello Ch

Complicated SQL queries

2024-01-12 Thread Christian Gonzalez
Hi, I was wondering if there was a way to perform queries where the ending table/class is different from the starting one. I have a query where the result columns (the SELECT part) I want are from a different table than the starting one. It looks something like this: SELECT t3.columnA, t3. columnB