Most probably it is a problem with the Schema? I tried it only for testing purposes and have not continued to work on this issue.
Arnis Ziedins -----Original Message----- From: Unico Hommes [mailto:[EMAIL PROTECTED] Sent: lundi, 5. juillet 2004 14:26 To: Slide Users Mailing List Subject: Re: JDBCStore with MySQL problem Did you ever find a solution to this? I am running into the same problem with MySQL 4.1.3 beta and mysql-connector 3.1.2-alpha. Looks more like a bug in MySQL though. -- Unico Arnis Ziedins wrote: >I am trying to run SLIDE 2.0 and MySQL with the following configuration: >MySQL version: 4.1.2-alpha-debug >Driver version: mysql-connector-java-3.0.14-production >SQL script: >http://cvs.apache.org/viewcvs.cgi/*checkout*/jakarta-slide/src/conf/schema/ M >ySql-4.1-Schema.sql?rev=1.2 > >The database seems to be set-up and running normally (the tables are created >and I can get a connection to db). >Nevertheless I got the exception listed below. What setting have been used >to test MySql-4.1-Schema.sql?rev=1.2? >What could possibly be wrong? > >14 Jun 2004 16:32:09 - org.apache.slide.common.Namespace - INFO - >Registering Store tx (class org.apache.slide.store.ExtendedStore) with >parameters {} on scope / >14 Jun 2004 16:32:09 - org.apache.slide.common.Namespace - INFO - >Initialising Store tx(org.apache.slide.store.ExtendedStore) >14 Jun 2004 16:32:10 - org.apache.slide.common.Namespace - INFO - Loading >namespace slide base data >14 Jun 2004 16:32:10 - org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - >ERROR - SQL error 1109 on /: Base table or view not found, message from >server: "Unknown table 'binding' in MULTI DELETE" >org.apache.slide.common.ServiceAccessException: Service >[EMAIL PROTECTED] access error : Base >table or view not found, message from server: "Unknown table 'binding' in >MULTI DELETE" > at >org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRD B >MSAdapter.java:60) > at >org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Standard R >DBMSAdapter.java:197) > at >org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createObject(Standar d >RDBMSAdapter.java:89) > at >org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject(AbstractR D >BMSStore.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) > > >The store configuration: > > ><definition> > <store name="tx"> > <nodestore >classname="org.apache.slide.store.impl.rdbms.JDBCStore"> > <parameter >name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</paramet e >r> > <parameter >name="driver">com.mysql.jdbc.Driver</parameter> > <parameter >name="url">jdbc:mysql://localhost:3306/slidestructure</parameter> > <parameter name="user">root</parameter> > <parameter name="password">arnis</parameter> > <parameter > name="isolation">SERIALIZABLE</parameter> > <parameter name="compress">false</parameter> > <parameter name="dbcpPooling">true</parameter> > <parameter > name="maxPooledConnections">10</parameter> > </nodestore> > <securitystore> > <reference store="nodestore"/> > </securitystore> > <lockstore> > <reference store="nodestore"/> > </lockstore> > <revisiondescriptorsstore> > <reference store="nodestore"/> > </revisiondescriptorsstore> > <revisiondescriptorstore> > <reference store="nodestore"/> > </revisiondescriptorstore> > <contentstore> > <reference store="nodestore"/> > </contentstore> > </store> > <scope match="/" store="tx"/> ></definition> >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.706 / Virus Database: 462 - Release Date: 14.06.2004 > > > > >--------------------------------------------------------------------- >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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.713 / Virus Database: 469 - Release Date: 30.06.2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.713 / Virus Database: 469 - Release Date: 30.06.2004 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]