[JS2-404] Hsql db 1.7.1 does not support addBatch

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-FINAL
• Fix Version/s: 2.0-FINAL
• Component/s: Persistence and DAO
• Environment: WinXP, JDK1.4.2_10
• Assignee: David LeStrat
• Reporter: Jian Liao
• Created: 09/Nov/05 19:21
• Updated: 13/Nov/05 06:03
• Resolved: 13/Nov/05 06:03

Description

It seems that hsqldb-1.7.1 does not support addBatch, it always has the following exception:

java.sql.SQLException: This function is not supported
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcPreparedStatement.getNotSupported(Unknown Source)
at org.hsqldb.jdbcPreparedStatement.addBatch(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.addBatch(DelegatingPreparedStatement.
java:171)
at org.apache.jetspeed.statistics.impl.BatchedStatistics.flush(BatchedStatistics.java:166)
at org.apache.jetspeed.statistics.impl.BatchedStatistics.checkAndDoFlush(BatchedStatistics.j
ava:81)
at org.apache.jetspeed.statistics.impl.BatchedStatistics.run(BatchedStatistics.java:127)
at java.lang.Thread.run(Thread.java:534)

Upgrade to hsqldb-1.8.0.2 will solved it.