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
