[opencms-dev] OAMP Comment Module - pageview problem

[Henrik F. Gøtzsche]

Setup:
OpenCms ver. 7.0.5
Oracle ver. 10.1.0.5.0
OAMP Webform Module ver. 1.3.1
OAMP Comment Module ver. 1.0.0

Problem:
Comment page view does not work as expected. 

I have created 8 comments. 

When the comment form is configured to show 3 comments per page,
4 comments are actually shown, as is the page icons 
'Prev', '1', '2' '3' and 'Next'. Clicking 'Next' returns an 
empty comment page.

When configured to show 5 comments per page, 6 are shown (n+1, 
looks like a pattern) along with the page icons. Again clicking 
'Next', returns an empty page.

Clicking 'Next' throws an exception:

02 okt 2009 09:42:49,738 ERROR [cms.comments.CmsCommentsAccess: 364] ORA-00933: SQL command not properly ended
java.sql.SQLException: ORA-00933: SQL command not properly ended
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
	at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
  ...

Tested with same result on:
Firefox ver. 3.0.14
Internet Explorer ver. 8.0.6
Opera ver. 9.52
all on Windows Vista

Any hints or workarounds?

Best regards
Henrik

---
Henrik F. Gøtzsche
WebSektionen
Digital Infrastruktur og Service
Det Kongelige Bibliotek

e-mail: hfg at kb.dk
tlf: 33 47 48 48