Re: Problem with Roller 5.0.1 and PostgreSQL 9.1

Hi Matthias, it would be good to add your email text and patch as an 
Apache Roller issue: https://issues.apache.org/jira/browse/ROL. Should 
anyone incur any PostgreSQL hiccups as a result of this upgrade they can 
add their comments directly to the JIRA item this way.

I submitted a patch (https://issues.apache.org/jira/browse/ROL-1950) 
fixing the broken link you mentioned and a few other issues I found.

Cheers,
Glen


On 11/25/2012 12:00 AM, Matthias Wimmer wrote:
> Hi list,
>
>
> I am currently experimenting with Roller 5.0.1. While doing so I noticed
> some problems where Roller did not work as expected. For example I was
> not able to delete categories from a Weblog.
> By checking the roller.log I noticed, that this was caused by OpenJPA
> generating SQL queries PostgreSQL 9.1 does not accept:
>
> ERROR 2012-11-25 00:00:00,422 TurnoverReferersTask:runTask - unexpected
> exception
> <openjpa-2.0.1-r422266:989424 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: FEHLER: ungültige
> ESCAPE-Zeichenkette
>    Hinweis: ESCAPE-Zeichenkette muss null oder ein Zeichen lang sein.
>    {prepstmnt 439112063 DELETE FROM referer WHERE id IN (SELECT DISTINCT
>    t0.id FROM referer t0 WHERE (t0.excerpt IS NULL OR t0.excerpt LIKE ?
>    ESCAPE '\\')) [params=?]} [code=0, state=22025]
>    FailedObject: DELETE FROM referer WHERE id IN (SELECT DISTINCT t0.id
>    FROM referer t0 WHERE (t0.excerpt IS NULL OR t0.excerpt LIKE ? ESCAPE
>    '\\')) [java.lang.String]
>
> This problem is also described at
> https://issues.apache.org/jira/browse/OPENJPA-2056
>
> As far I can see, I could solve this problem by upgrading OpenJPA to
> version 2.2.0 using the attached changes in Trunk.
>
>
> Regards,
> Matthias
>
>
> BTW: The link on http://roller.apache.org/downloads.html to the project
> mailing lists is broken.
>