Matthias Wimmer created ROL-1952:
------------------------------------
Summary: Roller 5.0.1 does not work with PostgreSQL 9.1
Key: ROL-1952
URL: https://issues.apache.org/jira/browse/ROL-1952
Project: Roller
Issue Type: Bug
Components: JPA Backend
Affects Versions: 5.0
Environment: PostgreSQL 9.1.6
Reporter: Matthias Wimmer
Assignee: Roller Unassigned
Attachments: openjpa.diff
Roller 5.0.1 cannot be used together with PostgreSQL version 9.1. This is
because Roller uses OpenJPA 2.0.1 which is not compatible with PostgreSQL 9.1.
The problem can be fixed by updating OpenJPA to version 2.2.0. I tried this on
trunk and it seems to work for me.
The exception I get in the log when using the original 5.0.1 bundle is:
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]
(Sorry for my postgresql returing a German error message. It means: “ERROR:
invalid ESCAPE sequence. Note: ESCAPE string has to be null or one character
long.”)
The problem is also described in the bug tracker of OpenJPA:
https://issues.apache.org/jira/browse/OPENJPA-2056
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
