You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "Glen Mazza (JIRA)" <ji...@apache.org> on 2013/05/31 13:02:20 UTC
[jira] [Resolved] (ROL-1952) Roller 5.0.1 does not work with
PostgreSQL 9.1
[ https://issues.apache.org/jira/browse/ROL-1952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Glen Mazza resolved ROL-1952.
-----------------------------
Resolution: Fixed
Fix Version/s: 5.1
While I haven't tested on PostgreSQL 9.1, I did upgrade OpenJPA to 2.2.2 on trunk, so your problem should go away at least there.
> 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
> Fix For: 5.1
>
> 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