[Building Sakai] Sakai 2.5.3 with HSQLDB

[Jean-Francois Leveque]

I'm afraid search doesn't work with HSQLDB.

This is why you're getting this error.

Either:
- Set search.enable to false in your sakai.properties 
(http://confluence.sakaiproject.org/display/DOC/Sakai+Properties+Reference+-+S)
- Use a RDBMS that can work with search: MySQL or Oracle

Cheers,

Jean-Francois

Claudia Roberta a écrit :
> 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"