Re: Failed Query
Re: Failed Query
- Subject: Re: Failed Query
- From: Gino Pacitti via Webobjects-dev <email@hidden>
- Date: Tue, 14 Jan 2020 14:26:41 +0000
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
| References: | |
| | >Failed Query (From: Gino Pacitti via Webobjects-dev <email@hidden>) |
| | >RE: Failed Query (From: GILQUIN Pierre via Webobjects-dev <email@hidden>) |
| | >Re: Failed Query (From: Gino Pacitti via Webobjects-dev <email@hidden>) |
| | >Re: Failed Query (From: Gino Pacitti via Webobjects-dev <email@hidden>) |