[Building Sakai] Sakai 2.5.3 with HSQLDB

[Steve Swinsburg]

Hi Claudia,

HSQL doesn't support some transactions, so search doesn't work in it. You'll need to disable search if you want to use HSQL.

cheers,
Steve




On 18/05/2010, at 11:55 PM, Claudia Roberta wrote:

> Hi list!
> 
> I installed Sakai 2.5.3 with HSQLDB. When I start tomcat:
> Errors in catalina.out: (partial listing)
> 
> 
> ERROR: Failed to check transaction table  (2010-05-18 10:47:07,859 main_org.sakaiproject.search.transaction.impl.TransactionSequenceImpl)
> java.sql.SQLException: Table not found in statement [select txid  from search_transaction]
>         at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
>         at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
>         at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
>         at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
>         at org.sakaiproject.search.transaction.impl.TransactionSequenceImpl.check(TransactionSequenceImpl.java:91)
>         at org.sakaiproject.search.transaction.impl.TransactionSequenceImpl.getNextId(TransactionSequenceImpl.java:143)
>         at org.sakaiproject.search.indexer.impl.SearchBuilderQueueManager.init(SearchBuilderQueueManager.java:108)
> 
> 
> Any idea?
> 
> Thanks
> 
> -- 
> Claudia Roberta 
> Intermídia - ICMC/USP - São Carlos, SP - Brasil
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100519/2cadfaf2/attachment.html