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(MySqlRDB MSAdapter.java:60) at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(StandardR DBMSAdapter.java:197) at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createObject(Standard RDBMSAdapter.java:89) at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject(AbstractRD 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</paramete 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]
