I am trying to configure Slide to use MySql as the backend, as
described in the docs on the web site. The problem is that
MySql doesn't seem to like the SQL that it is being fed. I
have built slide from source using the 2.0 RC1 tag, and
created the tables using the provided db scripts (thanks!!). I
can see when it starts that some data is being added to the db
(a few rows in previously empty tables), but it very quickly
dies. I am running Tomcat 5 and MySql 3.23.55. Any ideas?
Many Thanks,
Andy
**************************************
* store config from Domain.xml
**************************************
<definition>
<store name="MySqlStore">
<nodestore
classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter
name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
<parameter name="driver">com.mysql.jdbc.Driver</parameter>
<parameter name="url">jdbc:mysql://localhost/Slide</parameter>
<parameter name="user">xxx</parameter>
<parameter name="password">xxx</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>
<scope match="/" store="MySqlStore"/>
</definition>
**************************************
* snip from catalina.out
**************************************
INFO: Starting Servlet Engine: Apache Tomcat/5.0.19
20 Apr 2004 20:11:22 - org.apache.slide.common.Domain - INFO -
Auto-Initializing Domain
20 Apr 2004 20:11:22 - 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.sli
de.search=true, org.apache.slide.security=true,
org.apache.slide.urlEncoding=UTF-8,
org.apache.slide.domain=../slide/Domain.xml}
20 Apr 2004 20:11:22 - org.apache.slide.common.Domain - INFO -
Initializing Domain
20 Apr 2004 20:11:22 - 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.sli
de.search=true, org.apache.slide.security=true,
org.apache.slide.urlEncoding=UTF-8,
org.apache.slide.domain=../slide/Domain.xml}
20 Apr 2004 20:11:22 - org.apache.slide.common.Domain - INFO -
Domain parameters: {logger-level=6, versioncontrol-exclude=,
auto-version=checkout-checkin, historypath=/history,
checkin-fork=forbidd
en, workingresourcepath=/workingresource,
workspacepath=/workspace, default=slide,
auto-version-control=true,
logger=org.apache.slide.util.logger.SimpleLogger,
checkout-fork=forbidden}
20 Apr 2004 20:11:22 - org.apache.slide.common.Domain - INFO -
Initializing namespace : slide
20 Apr 2004 20:11:22 - org.apache.slide.common.Namespace -
INFO - Loading namespace slide parameters
20 Apr 2004 20:11:22 - org.apache.slide.common.Namespace -
INFO - Loading namespace definition
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Node store: org.apache.slide.store.impl.rdbms.JDBCStore
20 Apr 2004 20:11:23 -
org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Loading
and registering driver 'com.mysql.jdbc.Driver'
20 Apr 2004 20:11:23 -
org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Setting
isolation level 'SERIALIZABLE'
20 Apr 2004 20:11:23 -
org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Using
DBCP pooling
20 Apr 2004 20:11:23 -
org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Number of
connections set to 10
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Security store references nodestore
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Lock store store references nodestore
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Revision descriptors store references nodestore
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Revision descriptor store references nodestore
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Content store references nodestore
20 Apr 2004 20:11:23 - INFO - Setting object cache size for
store MySqlStore to 10000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting permission cache size for store MySqlStore to 10000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting lock cache size for store MySqlStore to 100
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting descriptors cache size for store MySqlStore to
10000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting descriptor cache size for store MySqlStore to 10000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting content caching for store MySqlStore to false
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting content cache size for store MySqlStore to 10000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting content cache byte size for store MySqlStore to
10000000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting transaction content cache size for store
MySqlStore to 1000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting transaction content cache byte size for store
MySqlStore to 1000000
20 Apr 2004 20:11:23 - org.apache.slide.store.ExtendedStore -
INFO - Setting maximum byte size for content cache entry for
store MySqlStore to 50000
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Registering Store MySqlStore (class
org.apache.slide.store.ExtendedStore) with parameters {} on
scope /
20 Apr 2004 20:11:23 - org.apache.slide.common.Namespace -
INFO - Initializing Store
MySqlStore(org.apache.slide.store.ExtendedStore)
20 Apr 2004 20:11:24 - org.apache.slide.common.Namespace -
INFO - Loading namespace slide base data
20 Apr 2004 20:11:24 -
org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - ERROR -
SQL error 1064 on /: Syntax error or access violation,
message from server: "You have an error in your SQL synt
ax near 'BINDING from BINDING c, URI u where c.URI_ID =
u.URI_ID and u.URI_STRING = '/'' at line 1"
org.apache.slide.common.ServiceAccessException: Service
[EMAIL PROTECTED] access
error : Syntax error or access violation, message from
server: "You have an error
in your SQL syntax near 'BINDING from BINDING c, URI u where
c.URI_ID = u.URI_ID and u.URI_STRING = '/'' at line 1"
at
org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:60)
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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
