You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Matthias Wimmer <m...@tthias.eu> on 2012/11/25 06:00:11 UTC
Problem with Roller 5.0.1 and PostgreSQL 9.1
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.
--
Matthias Wimmer
Contact details: http://matthias.wimmer.tel/
Re: Problem with Roller 5.0.1 and PostgreSQL 9.1
Posted by Glen Mazza <gl...@gmail.com>.
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.
>