topic Configure Alfresco with HSQL database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/configure-alfresco-with-hsql-database/m-p/147657#M103059 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN> 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.</SPAN><BR /><BR /><SPAN> I modified file C:\alfresco\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\domain\hibernate-cfg.properties and changed:</SPAN><BR /><BR /><SPAN>#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect</SPAN><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.HSQLDialect </SPAN><BR /><BR /><SPAN>but I cannot start Alfresco due this errors:</SPAN><BR /><BR /><SPAN>21:37:51,782 ERROR [repo.transaction.TransactionUtil] Error rolling back transaction</SPAN><BR /><SPAN>java.lang.IllegalStateException: No user transaction is active</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:461)</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Database does not exists: file:C:\WINDOWS\system32\alf_data\hsql_data\alfresco</SPAN><BR /><BR /><SPAN>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).</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Radek Budar</SPAN></BODY></HTML> Tue, 11 Dec 2007 21:03:44 GMT radek_budar 2007-12-11T21:03:44Z Configure Alfresco with HSQL database https://connect.hyland.com/t5/alfresco-archive/configure-alfresco-with-hsql-database/m-p/147657#M103059 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: Tue, 11 Dec 2007 21:03:44 GMT https://connect.hyland.com/t5/alfresco-archive/configure-alfresco-with-hsql-database/m-p/147657#M103059 radek_budar 2007-12-11T21:03:44Z Re: Configure Alfresco with HSQL database https://connect.hyland.com/t5/alfresco-archive/configure-alfresco-with-hsql-database/m-p/147658#M103060 <HTML><HEAD></HEAD><BODY><SPAN>Thanks LuisSala for answer. It was the solution of my problem. I must the path to HSQL DB write&nbsp; as absolute with double-backslash ("C:\\…")</SPAN></BODY></HTML> Fri, 28 Dec 2007 19:53:49 GMT https://connect.hyland.com/t5/alfresco-archive/configure-alfresco-with-hsql-database/m-p/147658#M103060 radek_budar 2007-12-28T19:53:49Z