Re: Exception in clearBinding with MySql 4.1

[Unico Hommes]

Try using MySql41RDBMSAdapter instead (part of the just released 2.1b1 
distribution), there is a slight incompatibility with DELETE semantics 
in MySql 4.1.

--
Unico
Michele Costabile wrote:
keep having this exception during startup
org.apache.slide.common.ServiceAccessException: Service org.apache.slide.store.i
[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(M
ySqlRDBMSAdapter.java:60)
I checked with the sources and line numbers appear to be different,
but it should be here
   public void removeObject(Connection connection, Uri uri, ObjectNode object)
       throws ServiceAccessException, ObjectNotFoundException {
       PreparedStatement statement = null;
       try {
 

          clearBinding(connection, uri);
       

           // delete links
           try {
               statement =
                   connection.prepareStatement(
I am running MySql 4.1.3b with mysql-connector-java-3.0.14-production-bin.
This is server status
mysql> status
--------------
\mysql\bin\mysql.exe  Ver 14.5 Distrib 4.1.3b-beta, for Win95/Win98 (i32)
Connection id:          3
Current database:
Current user:           [EMAIL PROTECTED]
SSL:                    Not in use
Using delimiter:        ;
Server version:         4.1.3b-beta-nt-max
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1_swedish_ci
Server characterset:    latin1_swedish_ci
TCP port:               3306
Uptime:                 19 sec
Which version of SQL has been tested?
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]