roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthias Wimmer...@tthias.eu>
Subject Problem with Roller 5.0.1 and PostgreSQL 9.1
Date Sun, 25 Nov 2012 05:00:11 GMT
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/

Mime
View raw message