Problem with Roller 5.0.1 and PostgreSQL 9.1
Matthias Wimmer <[email protected]>
| Newsgroups | gmane.comp.java.roller.user |
|---|---|
| Message-ID | <20121125050011.GA14682@rescue> |
Hi list,
I am currently experimenting with Roller 5.0.1. While doing so I noticed
some problems where Roller did not work as expected. For example I was
not able to delete categories from a Weblog.
By checking the roller.log I noticed, that this was caused by OpenJPA
generating SQL queries PostgreSQL 9.1 does not accept:
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]
This problem is also described at
https://issues.apache.org/jira/browse/OPENJPA-2056
As far I can see, I could solve this problem by upgrading OpenJPA to
version 2.2.0 using the attached changes in Trunk.
Regards,
Matthias
BTW: The link on http://roller.apache.org/downloads.html to the project
mailing lists is broken.
--
Matthias Wimmer
Contact details: http://matthias.wimmer.tel/
openjpa.diff
(text/x-diff, 3.4 KB)
Index: weblogger-web/pom.xml
===================================================================
--- weblogger-web/pom.xml (Revision 1413288)
+++ weblogger-web/pom.xml (Arbeitskopie)
@@ -66,10 +66,6 @@
<artifactId>openjpa</artifactId>
<exclusions>
<exclusion>
- <groupId>commons-pool</groupId>
- <artifactId>commons-pool</artifactId>
- </exclusion>
- <exclusion>
<groupId>org.apache.geronimo.specs</groupId>
<artifactId>geronimo-jms_1.1_spec</artifactId>
</exclusion>
Index: pom.xml
===================================================================
--- pom.xml (Revision 1413288)
+++ pom.xml (Arbeitskopie)
@@ -331,9 +331,9 @@
<dependency>
<groupId>org.apache.openjpa</groupId>
<artifactId>openjpa</artifactId>
- <version>2.0.1</version>
+ <version>2.2.0</version>
<scope>compile</scope>
- </dependency>
+ </dependency>
<dependency>
<groupId>javax.mail</groupId>
Index: weblogger-business/pom.xml
===================================================================
--- weblogger-business/pom.xml (Revision 1413288)
+++ weblogger-business/pom.xml (Arbeitskopie)
@@ -48,10 +48,6 @@
<artifactId>openjpa</artifactId>
<exclusions>
<exclusion>
- <groupId>commons-pool</groupId>
- <artifactId>commons-pool</artifactId>
- </exclusion>
- <exclusion>
<groupId>org.apache.geronimo.specs</groupId>
<artifactId>geronimo-jms_1.1_spec</artifactId>
</exclusion>
@@ -236,7 +232,7 @@
<!-- Ensure tests will run even if 'openjpa' profile not active -->
<forkMode>once</forkMode>
- <argLine>-javaagent:"${user.home}/.m2/repository/org/apache/openjpa/openjpa/2.0.1/openjpa-2.0.1.jar"</argLine>
+ <argLine>-javaagent:"${user.home}/.m2/repository/org/apache/openjpa/openjpa/2.2.0/openjpa-2.2.0.jar"</argLine>
<systemProperties>
<property>
Index: planet-business/pom.xml
===================================================================
--- planet-business/pom.xml (Revision 1413288)
+++ planet-business/pom.xml (Arbeitskopie)
@@ -40,10 +40,6 @@
<artifactId>openjpa</artifactId>
<exclusions>
<exclusion>
- <groupId>commons-pool</groupId>
- <artifactId>commons-pool</artifactId>
- </exclusion>
- <exclusion>
<groupId>org.apache.geronimo.specs</groupId>
<artifactId>geronimo-jms_1.1_spec</artifactId>
</exclusion>
@@ -197,7 +193,7 @@
<!-- Ensure tests will run even if 'openjpa' profile not active -->
<forkMode>once</forkMode>
- <argLine>-javaagent:"${user.home}/.m2/repository/org/apache/openjpa/openjpa/2.0.1/openjpa-2.0.1.jar"</argLine>
+ <argLine>-javaagent:"${user.home}/.m2/repository/org/apache/openjpa/openjpa/2.2.0/openjpa-2.2.0.jar"</argLine>
<systemProperties>
<property>
smime.p7s
(application/x-pkcs7-signature, 4 KB) - not displayed