AnsweredAssumed Answered

Configure Alfresco with HSQL database

Question asked by radek.budar on Dec 11, 2007
Latest reply on Dec 28, 2007 by radek.budar
Hi all,

I have trouble with configuration Alfresco with HSQL Database. I downloaded community pack, but Alfresco was with mySQL preconfigurated. I need run Alfresco with HSQL DB.

I modified file C:\alfresco\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\domain\hibernate-cfg.properties and changed:

#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.dialect=org.hibernate.dialect.HSQLDialect

but I cannot start Alfresco due this errors:

21:37:51,782 ERROR [repo.transaction.TransactionUtil] Error rolling back transaction
java.lang.IllegalStateException: No user transaction is active
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:461)



Caused by: java.sql.SQLException: Database does not exists: file:C:\WINDOWS\system32\alf_data\hsql_data\alfresco

It is the problem, Alfresco HSQL databse is located at C:\alfresco\alf_data, not in C:\WINDOWS\system32\.., but I do not know, where I can say, that HSQL DB si located on other path. I added C:\alfresco on system path variable (PATH variable).

Thanks
Radek Budar

Outcomes