Re: Failed Query

2020-01-14 Thread OCsite via Webobjects-dev
Gino, first thing I would try would be to log out the generated SQL and check its contents. Can you do that? Unless I am missing something, your quoted strings look like a plain ASCII, and thus they should not be affected by Unicode quirks. All the best, OC > On 14 Jan 2020, at 15:26, Gino Pa

Re: Definitely solved: More SharedEC woes: relationships into SEC not saved with more EOF stacks

2020-01-14 Thread OCsite via Webobjects-dev
Chuck, > On 14 Jan 2020, at 6:31, Chuck Hill wrote: > On Jan 13, 2020, at 5:42 AM, OCsite mailto:o...@ocs.cz>> wrote: >>> Do you have multiple EOF stacks (multiple EOObjectStoreCoordinator >>> instances)? >> >> Hmmm... yup, in most of my apps, I use for years and years >> >> er.extensions.ERXO

Re: Failed Query

2020-01-14 Thread Gino Pacitti via Webobjects-dev
Still not working …. Could it be the length of the string? This is the searched for String - pi_1G0qENIo1HLeQd0O7rTZlOAx This is the database Varchar -pi_1G0qENIo1HLeQd0O7rTZlOAx I have this in my connection Dictionary - useUnicode=true&characterEncoding=UTF-8 The database is configured

Re: Failed Query

2020-01-14 Thread Gino Pacitti via Webobjects-dev
Thanks Pierre I will test this out… > On 14 Jan 2020, at 12:57, GILQUIN Pierre wrote: > > Yes strange > > A case issue ? May be try Transaction.PAYMENTINTENTID.ilike() > Or a encoding utf8/iso issue … > > > > De : Webobjects-dev > [mailto:webobjects-dev-bounces+pierre.gilquin=hcug

Re: Failed Query

2020-01-14 Thread Gino Pacitti via Webobjects-dev
Thanks I will give it a go… Funny thing is that the ‘old’ code works and then just on occasion does not… > On 14 Jan 2020, at 12:25, GILQUIN Pierre via Webobjects-dev > wrote: > > Hi, > > I Dont know if your old style qualifier is correct, so you may try something > like this with the c

RE: Failed Query

2020-01-14 Thread GILQUIN Pierre via Webobjects-dev
Hi, I Dont know if your old style qualifier is correct, so you may try something like this with the corresponding ERXKey : myQual = Transaction.PAYMENTINTENTID.eq(paymentIntentID) ; De : Webobjects-dev [mailto:webobjects-dev-bounces+pierre.gilquin=hcuge...@lists.apple.com] De la part de Gino

Failed Query

2020-01-14 Thread Gino Pacitti via Webobjects-dev
Hi Anyone had experience of queries that should return an object as the row exists but EOF throws a NoSuchElementException? This is some code: Transaction transactionEo = QueryDatabase.TransactionForPaymentIntentIdQuery(customCharge.getPayment_intent(), _ec); public static synchronized Tra

Re: Definitely solved: More SharedEC woes: relationships into SEC not saved with more EOF stacks

2020-01-14 Thread Philippe Rabier via Webobjects-dev
Hi all, I would bet on your answer, Chuck. And I agree w/ you: I don’t remember the details but we had some side effects/issues in the past w/ SEC OC, I recommend an article titled "Development-Which cache to use with EOs?" I wrote several years ago: https://wiki.wocommunity.org/pages/viewpage.