[
https://issues.apache.org/jira/browse/ROL-1952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matthias Wimmer updated ROL-1952:
---------------------------------
Attachment: openjpa.diff
This is what I changed in Trunk to get it working at my system.
> 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
