You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Andrew Badstubner <an...@badstubner.com> on 2004/04/21 03:16:01 UTC
SQL Error with MySqlRDBMSAdapter
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
org.apache.slide.store.impl.rdbms.JDBCStore@8a0544 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: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: SQL Error with MySqlRDBMSAdapter
Posted by Oliver Zeigermann <oz...@c1-fse.de>.
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
> org.apache.slide.store.impl.rdbms.JDBCStore@8a0544 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: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
>
> .
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org