AnsweredAssumed Answered

Alfresco with hsql db

Question asked by venu on Jan 18, 2006
Hi,

I am new to Hibernate. Can someone please help me configure the application to run with HSQL db (if it is possible)?

I tried the following:

1. In hibernate.cfg.properties –>
hibernate.dialect=org.hibernate.dialect.HSQLDialect
2. In repository.properties –>
# Database configuration

db.driver=org.hsqldb.jdbcDriver
db.name=alfresco
db.url=jdbc:hsqldb:D:/venu/alfresco/data/alfresco
db.username=sa
db.password=
3. The hsql.jar is placed in WEB-INF/lib folder.

I used the alfresco-war-1.1.2.zip with tomcat 5.0. I am getting the following error:

11:28:35,544 ERROR [tool.hbm2ddl.SchemaUpdate] could not get database metadata
java.sql.SQLException: Table not found: SYSTEM_SEQUENCES in statement [select sequence_name from system_sequences]

Any help will be appreciated…

Regards
Venu

Outcomes