Re: Failed Query
Re: Failed Query
- Subject: Re: Failed Query
- From: OCsite via Webobjects-dev <email@hidden>
- Date: Tue, 14 Jan 2020 18:47:46 +0100
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 Pacitti via Webobjects-dev
> <email@hidden> wrote:
>
> 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 for UTF-8 and the column has this Collation -
> utf8_general_ci
>
> The search for string is returned from a POJO
>
> Any other ideas?
>
>
>
>
>
>
>
>
>
>> On 14 Jan 2020, at 12:59, Gino Pacitti via Webobjects-dev
>> <email@hidden> wrote:
>>
>> Thanks Pierre
>>
>> I will test this out…
>>
>>
>>
>>> On 14 Jan 2020, at 12:57, GILQUIN Pierre <email@hidden> 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=email@hidden] De
>>> la part de Gino Pacitti via Webobjects-dev
>>> Envoyé : mardi 14 janvier 2020 13:34
>>> À : WebObjects-Dev Mailing List List
>>> Objet : Re: Failed Query
>>>
>>> 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
>>> <email@hidden> wrote:
>>>
>>> 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=email@hidden] De
>>> la part de Gino Pacitti via Webobjects-dev
>>> Envoyé : mardi 14 janvier 2020 13:04
>>> À : WebObjects-Dev Mailing List List
>>> Objet : Failed Query
>>>
>>> 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 Transaction
>>> TransactionForPaymentIntentIdQuery(String paymentIntentID, EOEditingContext
>>> _ec) throws NoSuchElementException {
>>>
>>>
>>> NSArray<String> args = new NSArray<String>(new String[]{
>>> paymentIntentID });
>>> EOQualifier myQual =
>>> EOQualifier.qualifierWithQualifierFormat("purchaseIntentId = %@", args);
>>>
>>> log.info("Qualifier " + myQual);
>>>
>>>
>>> return Transaction.fetchRequiredTransaction(_ec, myQual);
>>>
>>> }
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list (email@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden