topic HSQLDB and 2.1.0? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83371#M55992 <HTML><HEAD></HEAD><BODY><SPAN>Hi - </SPAN><BR /><BR /><SPAN>I built a version of the alfresco sdk from svn (version 741 I believe, from last Friday) and I've been able to get it running with mysql with no problems.&nbsp; For some of our testing, however, I was thinking it might be nice to run against hsqldb.&nbsp; When starting up the application against hsqldb, I see these errors:</SPAN><BR /><BR /><SPAN>07:35:17,130 INFO&nbsp; [domain.schema.SchemaBootstrap] Generating unmodified schema creation script: /tmp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.HSQLDialect-35750.sql</SPAN><BR /><SPAN>07:35:17,235 INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script: /tmp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.HSQLDialect-35750.sql</SPAN><BR /><SPAN>07:35:17,363 INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/2.0/${db.script.dialect}/AlfrescoPostCreate-2.0-FKIndexes.sql</SPAN><BR /><SPAN>07:35:17,955 ERROR [web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: could not insert: [org.alfresco.repo.attributes.MapAttributeImpl]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2108)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2588)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:180)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:108)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.attributes.hibernate.AttributeDAOHibernate.save(AttributeDAOHibernate.java:133)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.attributes.MapAttributeImpl.&lt;init&gt;(MapAttributeImpl.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.attributes.AttributeConverter.toPersistent(AttributeConverter.java:84)</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: This function is not supported</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hsqldb.jdbc.Util.sqlException(Lorg.hsqldb.HsqlException<img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" />Ljava.sql.SQLException;(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hsqldb.jdbc.Util.notSupported()Ljava.sql.SQLException;(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Ljava.lang.String;I)Ljava.sql.PreparedStatement;(Unknown Source)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:394)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:370)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object<img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" />Ljava.lang.Object;(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.util.GetGeneratedKeysHelper.prepareStatement(GetGeneratedKeysHelper.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:487)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.prepare(IdentityGenerator.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:30)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2108)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2588)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:180)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:108)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)</SPAN><BR /><BR /><BR /><SPAN>So this would be with spring 2.0.2, hibernate 3.2.1 and hsqldb 1.8.0.&nbsp; The only configuration I touched when flipping from mysql to hsql was in custom-hibernate-dialect.properties and custom-repository.properties.</SPAN><BR /><BR /><SPAN>my db settings are now:</SPAN><BR /><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.HSQLDialect</SPAN><BR /><BR /><SPAN>db.username=sa</SPAN><BR /><SPAN>db.password=</SPAN><BR /><SPAN>db.pool.initial=10</SPAN><BR /><SPAN>db.pool.max=100</SPAN><BR /><BR /><SPAN>db.schema.update=true</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># HSQL connection</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.driver=org.hsqldb.jdbcDriver</SPAN><BR /><SPAN>db.url=jdbc:hsqldb:file:/tmp/test/hsql_data/alfresco;ifexists=false;shutdown=true;</SPAN><BR /><BR /><BR /><SPAN>Any clues?</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Tue, 01 May 2007 14:57:50 GMT rob_golkosky 2007-05-01T14:57:50Z HSQLDB and 2.1.0? https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83371#M55992 Hi - I built a version of the alfresco sdk from svn (version 741 I believe, from last Friday) and I've been able to get it running with mysql with no problems.&nbsp; For some of our testing, however, I was thinking it might be nice to run against hsqldb.&nbsp; When starting up the application against hsqldb, Tue, 01 May 2007 14:57:50 GMT https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83371#M55992 rob_golkosky 2007-05-01T14:57:50Z Re: HSQLDB and 2.1.0? https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83372#M55993 <HTML><HEAD></HEAD><BODY><SPAN>I run into the same issue. I am using the Alfresco 2.1.0dev nightly build (Alfresco Community Tomcat) of today (May 1st 2007) and have not changed any configuration files at all.</SPAN><BR /><BR /><SPAN>It seems the hsqldb support is broken in the head at the moment?</SPAN><BR /><BR /><SPAN>I have not tried to use MySQL yet.</SPAN><BR /><BR /><SPAN>regards,</SPAN><BR /><BR /><SPAN>Edgar</SPAN></BODY></HTML> Tue, 01 May 2007 19:24:51 GMT https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83372#M55993 edgar 2007-05-01T19:24:51Z Re: HSQLDB and 2.1.0? https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83373#M55994 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Thanks for the feedback.&nbsp; We'll fix this swiftly.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Thu, 03 May 2007 10:54:50 GMT https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83373#M55994 derek 2007-05-03T10:54:50Z Re: HSQLDB and 2.1.0? https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83374#M55995 <HTML><HEAD></HEAD><BODY><SPAN>As of the current svn contents, this seems to be fixed.&nbsp; That is, it worked for me.&nbsp; For a few days last week I'd turned on the get_generated_keys feature in hibernate.&nbsp; Mea culpa, mea culpa.&nbsp; The HSQL jdbc driver doesn't support that feature.&nbsp; Let us know if there's still a problem.</SPAN></BODY></HTML> Thu, 03 May 2007 13:02:49 GMT https://connect.hyland.com/t5/alfresco-archive/hsqldb-and-2-1-0/m-p/83374#M55995 britt 2007-05-03T13:02:49Z