roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthias Wimmer (JIRA)" <j...@apache.org>
Subject [jira] [Created] (ROL-1952) Roller 5.0.1 does not work with PostgreSQL 9.1
Date Mon, 26 Nov 2012 09:26:58 GMT
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

Mime
View raw message