Re: Exception in clearBinding with MySql 4.1

[Oliver Zeigermann]

Could you provide the full stack trace for the exception, please?

Oliver

Michele Costabile wrote:

Thanks, that shoul work, but I still have a nullPointerException.
My Domain.xml is like this

<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
    <parameter 
name="adapter">org.apache.slide.store.impl.rdbms.MySql41RDBMSAdapter</parameter>
    <parameter name="driver">com.mysql.jdbc.Driver</parameter>
    <parameter name="url">jdbc:mysql://localhost/slide</parameter>
    <parameter name="user">root</parameter>
    <parameter name="dbcpPooling">true</parameter>
    <parameter name="maxPooledConnections">10</parameter>
    <parameter name="isolation">SERIALIZABLE</parameter>
    <parameter name="compress">false</parameter>
 </nodestore>

What am I doing wrong?

On Tue, 10 Aug 2004 16:30:35 +0200, Unico Hommes <[EMAIL PROTECTED]> wrote:

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]

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