Re: Or qualifiers
Missing a parenthesis after peer not authenticated… d’oh.
On Aug 1, 2014, at 3:52 PM, Ramsey Gurley wrote:
> Hi all,
>
> I’m wondering if anyone has seen this before. I am using Wonder 6.1 tag and
> wonder postgresql plugin. I have something like
>
> ERXQ.or(a.and(b), c.and(d), e.and(f));
>
> But when the where clause is generated, I get something like
>
> (a and b) or (c and d and (e and f))
>
> when I would expect
>
> (a and b) or (c and d) or (e and f)
>
> Actual qualifier and sql logged are:
>
> EOQualifier q = ERXQ.or(
> ERCMailMessage.STATE.eq(ERCMailState.SUPPRESSED)
>
> .and(ERXQ.not(ERCMailMessage.MAIL_RECIPIENTS.dot(ERCMailRecipient.MAIL_ADDRESS).dot(ERCMailAddress.DATE_LAST_SENT.isNull(
>
> .and(ERXQ.not(ERCMailMessage.MAIL_RECIPIENTS.dot(ERCMailRecipient.MAIL_ADDRESS).dot(ERCMailAddress.STOP_REASON.isNotNull(
> ,ERCMailMessage.STATE.eq(ERCMailState.EXCEPTION)
> .and(ERCMailMessage.EXCEPTION_REASON.contains("peer not
> authenticated")
> ,ERCMailMessage.STATE.eq(ERCMailState.EXCEPTION)
> .and(ERCMailMessage.EXCEPTION_REASON.contains("AWS Error Code:
> InternalFailure")))
> );
>
> SELECT t0.dateRead, t0.dateSent, t0.exceptionReason, t0.fromAddressID,
> t0.htmlClobID, t0.id, t0.mailCategoryID, t0.messageID, t0.plainClobID,
> t0.replyToAddressID, t0.state, t0.subject, t0.uuid, t0.xMailer FROM
> ERCMailMessage t0 INNER JOIN ERCMailRecipient T1 ON t0.id = T1.mailMessageID
> INNER JOIN ERCMailAddress T2 ON T1.mailAddressID = T2.id WHERE ((t0.state =
> ?::varchar(50) AND not (T2.dateLastSent is NULL) AND not (T2.stopReason is
> not NULL)) OR (t0.state = ?::varchar(50) AND UPPER(t0.exceptionReason) LIKE
> UPPER(?::varchar(1000)) ESCAPE '|' AND (t0.state = ?::varchar(50) AND
> UPPER(t0.exceptionReason) LIKE UPPER(?::varchar(1000)) ESCAPE '|')))
> withBindings: 1:'SUPPRESSED'[state], 2:'EXCEPTION'[state], 3:%peer not
> authenticated%[exceptionReason], 4:'EXCEPTION'[state], 5:%AWS Error Code:
> InternalFailure%[exceptionReason]
>
> Ramsey
___
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
Or qualifiers
Hi all,
I’m wondering if anyone has seen this before. I am using Wonder 6.1 tag and
wonder postgresql plugin. I have something like
ERXQ.or(a.and(b), c.and(d), e.and(f));
But when the where clause is generated, I get something like
(a and b) or (c and d and (e and f))
when I would expect
(a and b) or (c and d) or (e and f)
Actual qualifier and sql logged are:
EOQualifier q = ERXQ.or(
ERCMailMessage.STATE.eq(ERCMailState.SUPPRESSED)
.and(ERXQ.not(ERCMailMessage.MAIL_RECIPIENTS.dot(ERCMailRecipient.MAIL_ADDRESS).dot(ERCMailAddress.DATE_LAST_SENT.isNull(
.and(ERXQ.not(ERCMailMessage.MAIL_RECIPIENTS.dot(ERCMailRecipient.MAIL_ADDRESS).dot(ERCMailAddress.STOP_REASON.isNotNull(
,ERCMailMessage.STATE.eq(ERCMailState.EXCEPTION)
.and(ERCMailMessage.EXCEPTION_REASON.contains("peer not
authenticated")
,ERCMailMessage.STATE.eq(ERCMailState.EXCEPTION)
.and(ERCMailMessage.EXCEPTION_REASON.contains("AWS Error Code:
InternalFailure")))
);
SELECT t0.dateRead, t0.dateSent, t0.exceptionReason, t0.fromAddressID,
t0.htmlClobID, t0.id, t0.mailCategoryID, t0.messageID, t0.plainClobID,
t0.replyToAddressID, t0.state, t0.subject, t0.uuid, t0.xMailer FROM
ERCMailMessage t0 INNER JOIN ERCMailRecipient T1 ON t0.id = T1.mailMessageID
INNER JOIN ERCMailAddress T2 ON T1.mailAddressID = T2.id WHERE ((t0.state =
?::varchar(50) AND not (T2.dateLastSent is NULL) AND not (T2.stopReason is not
NULL)) OR (t0.state = ?::varchar(50) AND UPPER(t0.exceptionReason) LIKE
UPPER(?::varchar(1000)) ESCAPE '|' AND (t0.state = ?::varchar(50) AND
UPPER(t0.exceptionReason) LIKE UPPER(?::varchar(1000)) ESCAPE '|')))
withBindings: 1:'SUPPRESSED'[state], 2:'EXCEPTION'[state], 3:%peer not
authenticated%[exceptionReason], 4:'EXCEPTION'[state], 5:%AWS Error Code:
InternalFailure%[exceptionReason]
Ramsey
___
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
Wonder 6.1.2 is out
Hi list, it has been some time since the last release but finally Wonder 6.1.2 is officially out. Point your browser to the release page on github https://github.com/wocommunity/wonder/releases to get everything you need: a changelog (thanks Paul) and all artifacts you would get from the wocommunity jenkins server. Thanks for all those who contributed! signature.asc Description: Message signed with OpenPGP using GPGMail ___ 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
Re: Eclipse 4.4 support for WOLips
Sure, hadn't noticed it's a link to wocomunity repository branch. For a working and stable version, You should use the Wolfy42 repo (https://github.com/Wolfy42/wolips). W dniu 01/08/14 10:11, Dennis Bliefernicht pisze: Hello, On 01.08.2014, at 07:22, Konrad Kubacki wrote: Currently, it's DIY (or better: build it yourself, from repository mentioned in first mail). As a side-note: the repository/branch mentioned in the first post doesn’t seem to contain the latest changes concerning velocity, wizards and templates. I needed to fetch the actual pull request repository state to get the latest changes: git clone https://github.com/wocommunity/wolips.git wolips-4_4 cd wolips-4_4 git fetch origin pull/109/head:eclipse_4_4 git checkout eclipse_4_4 I’ve been running that build (without the now-existing velocity patch, because I have no m2e installed currently) for several days now and have not yet encountered a single WOLips-related issue in Luna (Eclipse 4.4, even with Gradle-based projects); although I should mention I don’t work with components very often. Thus far I’d say that this is a really great effort and a good step forward for WOLips. Greetings Dennis Bliefernicht ___ 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/kkubacki%40power.com.pl This email sent to kkuba...@power.com.pl -- Konrad Kubacki Starszy Programista - Lider Zespołu Programistów ifirma.pl Power Media S.A. ul. Grabiszyńska 241 B 53-234 Wrocław tel.: +48 71 769 43 00. faks: +48 71 321 00 16 http://www.power.com.pl Sąd Rejonowy dla Wrocławia-Fabrycznej VI Wydział Gospodarczy - Krajowego Rejestru Sądowego KRS: 281947 NIP: PL-898-16-47-572 Kapitał 640 000 zł w pełni opłacony ___ 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
Re: Eclipse 4.4 support for WOLips
Hello, On 01.08.2014, at 07:22, Konrad Kubacki wrote: > Currently, it's DIY (or better: build it yourself, from repository mentioned > in first mail). As a side-note: the repository/branch mentioned in the first post doesn’t seem to contain the latest changes concerning velocity, wizards and templates. I needed to fetch the actual pull request repository state to get the latest changes: git clone https://github.com/wocommunity/wolips.git wolips-4_4 cd wolips-4_4 git fetch origin pull/109/head:eclipse_4_4 git checkout eclipse_4_4 I’ve been running that build (without the now-existing velocity patch, because I have no m2e installed currently) for several days now and have not yet encountered a single WOLips-related issue in Luna (Eclipse 4.4, even with Gradle-based projects); although I should mention I don’t work with components very often. Thus far I’d say that this is a really great effort and a good step forward for WOLips. Greetings Dennis Bliefernicht ___ 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
