Slide 2.1 and MySQL 4.1________ ServiceAcessException (Urgent)

[Gbenga Bello <rg...@yahoo.com>]

Hello Mirko,

I went through the mailing list and I saw that you
have been able to successully use slide with MySQL
4.1.9

I am having errors in switching from slide 2.0 with
MySQL 4.0 to Slide 2.1 MySQL 4.1.9

I am using the slide api. At
Domain.init(/root/Domain.xml);

I get ServiceAccessException from the JDBCStore =>
org.apache.slide.common.ServiceAccessException:
Service
org.apache.slide.store.impl.rdbms.JDBCStore@11ff436
access error : Unknown table 'BINDING' in MULTI DELETE
	at org.apache.slide.store.impl.rdbms.... I have
attached the detailed error stacktrace below

I am running Fedora Core 3 Linux, I am using the MySQL
4.1 DB Schema that shipped w slide 2.1. 

Please could u give me an insight into wat's the cause
of the problem and how to solve it.

I will be glad to hear from you today

Thanks

CODE SNIPPET
====================================================
 protected void setUp() throws Exception {
            super.setUp();
            // Initialization
            String namespace = "jdbc_store";
            Domain.init("/root/slide/Domain.xml");
            this.token =
                    Domain.accessNamespace(new
SecurityToken(
                                           new
String()),namespace);
            this.structure =
token.getStructureHelper();
            this.security  =
token.getSecurityHelper();
            this.lock      = token.getLockHelper();
            this.content   = token.getContentHelper();

    }


ERROR
======================================================

20 Mar 2005 20:41:25 -
org.apache.slide.store.ExtendedStore - INFO - Setting
transaction content cache size for store jdbc to 1000
20 Mar 2005 20:41:25 -
org.apache.slide.store.ExtendedStore - INFO - Setting
transaction content cache byte size for store jdbc to
1000000
20 Mar 2005 20:41:25 -
org.apache.slide.store.ExtendedStore - INFO - Setting
maximum byte size for content cache entry for store
jdbc to 50000
20 Mar 2005 20:41:26 -
org.apache.slide.common.Namespace - INFO - Registering
Store jdbc (class
org.apache.slide.store.ExtendedStore) with parameters
{} on scope /
20 Mar 2005 20:41:26 -
org.apache.slide.common.Namespace - INFO -
Initializing Store
jdbc(org.apache.slide.store.ExtendedStore)
20 Mar 2005 20:41:27 -
org.apache.slide.common.Namespace - INFO - Loading
namespace jdbc_store base data
org.apache.slide.common.ServiceAccessException:
Service
org.apache.slide.store.impl.rdbms.JDBCStore@11ff436
access error : Unknown table 'BINDING' in MULTI DELETE
	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.init(Domain.java:367)
	at
org.apache.slide.common.Domain.init(Domain.java:343)
	at
com.onespace.webdav.Smysqlstore.setUp(Smysqlstore.java:61)
	at
com.onespace.webdav.Smysqlstore.<init>(Smysqlstore.java:51)
	at
com.onespace.webdav.Smysqlstore.main(Smysqlstore.java:2261)
20 Mar 2005 20:41:28 -
org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter -
ERROR - SQL error 1109 on /: Unknown table 'BINDING'
in MULTI DELETE
20 Mar 2005 20:41:28 -
org.apache.slide.common.Namespace - INFO - Namespace
base configuration was already done before
org.apache.slide.structure.ObjectNotFoundException: No
object found at /actions/read
	at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveObject(StandardRDBMSAdapter.java:283)
	at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveObject(AbstractRDBMSStore.java:436)



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org