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.
