OT: I *personally* disourage the use of HSQL DB as it does not feature decent isolation of transactions. Even dirty writes are possible... this is less than read uncommitted ...
Oliver
Jean-Baptiste Li�vremont wrote:
Hi there,
I'm using the Slide 2.0 / Tomcat 5.0.19 bundle.
I have the following configuration for my store in Domain.xml:
<store name="MelanieHSQL">
<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter name="adapter">org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter</parameter>
<parameter name="driver">org.hsqldb.jdbcDriver</parameter> <parameter name="url">jdbc:hsqldb:hsql://melanie:2901</parameter> <parameter name="user">tomcat</parameter> <parameter name="password">catalina</parameter> <!--parameter name="dbcpPooling">true</parameter> <parameter name="maxPooledConnections">10</parameter> <parameter name="isolation">SERIALIZABLE</parameter> <parameter name="compress">false</parameter--> </nodestore> <contentstore> <reference store="nodestore" /> </contentstore> <securitystore> <reference store="nodestore" /> </securitystore> <lockstore> <reference store="nodestore" /> </lockstore> <revisiondescriptorsstore> <reference store="nodestore" /> </revisiondescriptorsstore> <revisiondescriptorstore> <reference store="nodestore" /> </revisiondescriptorstore> </store>
As I launch tomcat, I have the following trace. What are the correct configuration options to use HSQLDB stores ?
Thanks in advance :)
Using CATALINA_BASE: /Users/lievremont/.prefix/share/slide/jakarta-slide-2.0-tomcat-5.0.19-1
Using CATALINA_HOME: /Users/lievremont/.prefix/share/slide/jakarta-slide-2.0-tomcat-5.0.19-1
Using CATALINA_TMPDIR: /Users/lievremont/.prefix/share/slide/jakarta-slide-2.0-tomcat-5.0.19-1/temp
Using JAVA_HOME: /Users/lievremont/.prefix/share/j2sdk1.4.2_04
24 juin 2004 12:11:54 org.apache.coyote.http11.Http11Protocol init
INFO: Initialisation de Coyote HTTP/1.1 sur le port 8080
24 juin 2004 12:11:54 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1274 ms
24 juin 2004 12:11:54 org.apache.catalina.core.StandardService start
INFO: D�marrage du service Catalina
24 juin 2004 12:11:54 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.0.19
24 Jun 2004 12:11:54 - org.apache.slide.common.Domain - INFO - Auto-Initializing Domain
24 Jun 2004 12:11:54 - org.apache.slide.common.Domain - INFO - Domain configuration : {org.apache.slide.lock=true, org.apache.slide.versioncontrol=true, org.apache.slide.debug=false, org.apache.slide.search=true, org.apache.slide.security=true, org.apache.slide.urlEncoding=UTF-8, org.apache.slide.domain=../slide/Domain.xml}
24 Jun 2004 12:11:55 - org.apache.slide.common.Domain - INFO - Initializing Domain
24 Jun 2004 12:11:55 - org.apache.slide.common.Domain - INFO - Domain configuration : {org.apache.slide.lock=true, org.apache.slide.versioncontrol=true, org.apache.slide.debug=false, org.apache.slide.search=true, org.apache.slide.security=true, org.apache.slide.urlEncoding=UTF-8, org.apache.slide.domain=../slide/Domain.xml}
24 Jun 2004 12:11:55 - org.apache.slide.common.Domain - INFO - Domain parameters: {logger-level=6, versioncontrol-exclude=, auto-version=checkout-checkin, historypath=/history, checkin-fork=forbidden, workingresourcepath=/workingresource, workspacepath=/workspace, default=slide, auto-version-control=false, logger=org.apache.slide.util.logger.SimpleLogger, checkout-fork=forbidden}
24 Jun 2004 12:11:55 - org.apache.slide.common.Domain - INFO - Initializing namespace : slide
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Loading namespace slide parameters
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Loading namespace definition
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Node store: org.apache.slide.store.impl.rdbms.JDBCStore
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Loading and registering driver 'org.hsqldb.jdbcDriver'
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Setting isolation level 'READ_COMMITTED'
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - WARNING - Not using DBCP pooling
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Security store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Lock store store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Revision descriptors store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Revision descriptor store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Content store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Node store: org.apache.slide.store.impl.rdbms.JDBCStore
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Loading and registering driver 'org.hsqldb.jdbcDriver'
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Setting isolation level 'READ_COMMITTED'
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - WARNING - Not using DBCP pooling
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Security store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Lock store store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Revision descriptors store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Revision descriptor store references nodestore
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Content store references nodestore
24 Jun 2004 12:11:55 - INFO - Setting object cache size for store MelanieHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting permission cache size for store MelanieHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting lock cache size for store MelanieHSQL to 100
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting descriptors cache size for store MelanieHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting descriptor cache size for store MelanieHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting content caching for store MelanieHSQL to false
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting content cache size for store MelanieHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting content cache byte size for store MelanieHSQL to 10000000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting transaction content cache size for store MelanieHSQL to 1000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting transaction content cache byte size for store MelanieHSQL to 1000000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting maximum byte size for content cache entry for store MelanieHSQL to 50000
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Registering Store MelanieHSQL (class org.apache.slide.store.ExtendedStore) with parameters {} on scope /
24 Jun 2004 12:11:55 - INFO - Setting object cache size for store CameronHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting permission cache size for store CameronHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting lock cache size for store CameronHSQL to 100
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting descriptors cache size for store CameronHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting descriptor cache size for store CameronHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting content caching for store CameronHSQL to false
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting content cache size for store CameronHSQL to 10000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting content cache byte size for store CameronHSQL to 10000000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting transaction content cache size for store CameronHSQL to 1000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting transaction content cache byte size for store CameronHSQL to 1000000
24 Jun 2004 12:11:55 - org.apache.slide.store.ExtendedStore - INFO - Setting maximum byte size for content cache entry for store CameronHSQL to 50000
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Registering Store CameronHSQL (class org.apache.slide.store.ExtendedStore) with parameters {} on scope /files/fiches
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Initializing Store MelanieHSQL(org.apache.slide.store.ExtendedStore)
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - WARNING - Could not set isolation level 'READ_COMMITTED'. Reason: java.sql.SQLException: This function is not supported
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error -33 on /actions: Access is denied in statement [select o.CLASS_NAME from OBJECT o, URI u where o.URI_ID = u.URI_ID and u.URI_STRING = '/actions']
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Initializing Store CameronHSQL(org.apache.slide.store.ExtendedStore)
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - WARNING - Could not set isolation level 'READ_COMMITTED'. Reason: java.sql.SQLException: This function is not supported
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error -33 on /actions: Access is denied in statement [select o.CLASS_NAME from OBJECT o, URI u where o.URI_ID = u.URI_ID and u.URI_STRING = '/actions']
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Loading namespace slide base data
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - WARNING - Could not set isolation level 'READ_COMMITTED'. Reason: java.sql.SQLException: This function is not supported
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error -33 on /: Access is denied in statement [select URI_ID from URI where URI_STRING='/']
org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : Access is denied in statement [select URI_ID from URI where URI_STRING='/']
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(StandardRDBMSAdapter.java:1403)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(StandardRDBMSAdapter.java:197)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createObject(StandardRDBMSAdapter.java:89)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject(AbstractRDBMSStore.java:476)
at org.apache.slide.store.AbstractStore.createObject(AbstractStore.java:557)
at org.apache.slide.store.ExtendedStore.createObject(ExtendedStore.java:436)
at org.apache.slide.common.Namespace.loadBaseData(Namespace.java:752)
at org.apache.slide.common.Domain.initNamespace(Domain.java:814)
at org.apache.slide.common.Domain.init(Domain.java:433)
at org.apache.slide.common.Domain.selfInit(Domain.java:747)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:235)
at wrappers.catalina.SlideRealm.start(SlideRealm.java:178)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1118)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Namespace base configuration was already done before
24 Jun 2004 12:11:55 - org.apache.slide.common.Namespace - INFO - Loading namespace slide configuration
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.JDBCStore - WARNING - Could not set isolation level 'READ_COMMITTED'. Reason: java.sql.SQLException: This function is not supported
24 Jun 2004 12:11:55 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error -33 on /actions/read: Access is denied in statement [select o.CLASS_NAME from OBJECT o, URI u where o.URI_ID = u.URI_ID and u.URI_STRING = '/actions/read']
24 Jun 2004 12:11:55 - org.apache.slide.common.Domain - ERROR - org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : Access is denied in statement [select o.CLASS_NAME from OBJECT o, URI u where o.URI_ID = u.URI_ID and u.URI_STRING = '/actions/read']
org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : Access is denied in statement [select o.CLASS_NAME from OBJECT o, URI u where o.URI_ID = u.URI_ID and u.URI_STRING = '/actions/read']
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(StandardRDBMSAdapter.java:1403)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveObject(StandardRDBMSAdapter.java:356)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveObject(AbstractRDBMSStore.java:436)
at org.apache.slide.store.AbstractStore.retrieveObject(AbstractStore.java:498)
at org.apache.slide.store.ExtendedStore.retrieveObject(ExtendedStore.java:408)
at org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:1057)
at org.apache.slide.common.NamespaceConfig.getConfiguredNode(NamespaceConfig.java:805)
at org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(NamespaceConfig.java:675)
at org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:836)
at org.apache.slide.common.Domain.initNamespace(Domain.java:819)
at org.apache.slide.common.Domain.init(Domain.java:433)
at org.apache.slide.common.Domain.selfInit(Domain.java:747)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:235)
at wrappers.catalina.SlideRealm.start(SlideRealm.java:178)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1118)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
24 Jun 2004 12:11:55 - org.apache.slide.common.Domain - INFO - Domain initialization complete
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
Caused by: java.lang.NullPointerException
at org.apache.slide.common.NamespaceConfig.getParameter(NamespaceConfig.java:569)
at org.apache.slide.common.NamespaceAccessTokenImpl.<init>(NamespaceAccessTokenImpl.java:83)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:244)
at wrappers.catalina.SlideRealm.start(SlideRealm.java:178)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1118)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
... 6 more
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
