You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "James Liao (JIRA)" <je...@portals.apache.org> on 2005/11/09 11:22:20 UTC

[jira] Created: (JS2-404) Hsql db 1.7.1 does not support addBatch

Hsql db 1.7.1 does not support addBatch
---------------------------------------

         Key: JS2-404
         URL: http://issues.apache.org/jira/browse/JS2-404
     Project: Jetspeed 2
        Type: Bug
  Components: Persistence and DAO  
    Versions: 2.0-FINAL    
 Environment: WinXP, JDK1.4.2_10
    Reporter: James Liao


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Commented: (JS2-404) Hsql db 1.7.1 does not support addBatch

Posted by "James Liao (JIRA)" <je...@portals.apache.org>.
    [ http://issues.apache.org/jira/browse/JS2-404?page=comments#action_12357192 ] 

James Liao commented on JS2-404:
--------------------------------

I've passed all the unit test cases with hsqldb-1.8.0.2 except portal statistics component(hsqldb does not seem to support the hard coding sql) and case TestAggregator and case TestRenderer in  portal component.

> Hsql db 1.7.1 does not support addBatch
> ---------------------------------------
>
>          Key: JS2-404
>          URL: http://issues.apache.org/jira/browse/JS2-404
>      Project: Jetspeed 2
>         Type: Bug
>   Components: Persistence and DAO
>     Versions: 2.0-FINAL
>  Environment: WinXP, JDK1.4.2_10
>     Reporter: James Liao
>  Attachments: hsqldb-upgrade.diff
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Updated: (JS2-404) Hsql db 1.7.1 does not support addBatch

Posted by "James Liao (JIRA)" <je...@portals.apache.org>.
     [ http://issues.apache.org/jira/browse/JS2-404?page=all ]

James Liao updated JS2-404:
---------------------------

    Attachment: hsqldb-upgrade.diff

1. Replace all the hsqldb version with ${hsql.version}
2. Add hsql.version to project.properties in src root.

> Hsql db 1.7.1 does not support addBatch
> ---------------------------------------
>
>          Key: JS2-404
>          URL: http://issues.apache.org/jira/browse/JS2-404
>      Project: Jetspeed 2
>         Type: Bug
>   Components: Persistence and DAO
>     Versions: 2.0-FINAL
>  Environment: WinXP, JDK1.4.2_10
>     Reporter: James Liao
>  Attachments: hsqldb-upgrade.diff
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Closed: (JS2-404) Hsql db 1.7.1 does not support addBatch

Posted by "David Le Strat (JIRA)" <je...@portals.apache.org>.
     [ http://issues.apache.org/jira/browse/JS2-404?page=all ]
     
David Le Strat closed JS2-404:
------------------------------

    Fix Version: 2.0-FINAL
     Resolution: Fixed

Closing this issue.  Issues with the TestRenderer, TestAggregator and PortalStatistics unit test should be addressed through separately.

> Hsql db 1.7.1 does not support addBatch
> ---------------------------------------
>
>          Key: JS2-404
>          URL: http://issues.apache.org/jira/browse/JS2-404
>      Project: Jetspeed 2
>         Type: Bug
>   Components: Persistence and DAO
>     Versions: 2.0-FINAL
>  Environment: WinXP, JDK1.4.2_10
>     Reporter: James Liao
>     Assignee: David Le Strat
>      Fix For: 2.0-FINAL
>  Attachments: hsqldb-upgrade.diff
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Assigned: (JS2-404) Hsql db 1.7.1 does not support addBatch

Posted by "David Le Strat (JIRA)" <je...@portals.apache.org>.
     [ http://issues.apache.org/jira/browse/JS2-404?page=all ]

David Le Strat reassigned JS2-404:
----------------------------------

    Assign To: David Le Strat

> Hsql db 1.7.1 does not support addBatch
> ---------------------------------------
>
>          Key: JS2-404
>          URL: http://issues.apache.org/jira/browse/JS2-404
>      Project: Jetspeed 2
>         Type: Bug
>   Components: Persistence and DAO
>     Versions: 2.0-FINAL
>  Environment: WinXP, JDK1.4.2_10
>     Reporter: James Liao
>     Assignee: David Le Strat
>  Attachments: hsqldb-upgrade.diff
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org