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 
> <webobjects-dev@lists.apple.com> wrote:
> 
> Thanks Pierre
> 
>  I will test this out…
> 
> 
> 
>> On 14 Jan 2020, at 12:57, GILQUIN Pierre <pierre.gilq...@hcuge.ch> 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=hcuge...@lists.apple.com] 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 
>> <webobjects-dev@lists.apple.com> 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=hcuge...@lists.apple.com] 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      (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com
>> 
>> This email sent to ginok...@mac.com
> 
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com
> 
> This email sent to ginok...@mac.com

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to