roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Glen Mazza (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (ROL-1952) Roller 5.0.1 does not work with PostgreSQL 9.1
Date Fri, 31 May 2013 11:02:20 GMT

     [ 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

Mime
View raw message