That fixed it. Many thanks.
---- Original message ----
>Date: Wed, 21 Apr 2004 09:08:01 +0200
>From: Oliver Zeigermann <[EMAIL PROTECTED]>
>Subject: Re: SQL Error with MySqlRDBMSAdapter
>To: Slide Users Mailing List <[EMAIL PROTECTED]>
>
>The store works with MySQL 4.x only.
>
>Oliver
>
>Andrew Badstubner wrote:
>> 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]
>>
>>
>> .
>>
>
>
>---------------------------------------------------------------------
>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]
