Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.205 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=nP9eKFDUj3vEB2NJ6y/gWdKmiUPk+8Q5C7WiWQypBZVU4qgjZ7O6M98J3aY2suwjs1pxJ29gJjDVW6+fh4rzeat77mGLOaJVOBbNo/OJmCVkMdlo/NJUcbPzjcL0iS+ilopQLr6+Ub/pL03taxlSTrWHvCxz3w7xi04UnKkHTIY=
Message-ID: <a10a823c05071312504f11d805@mail.gmail.com>
Date: Wed, 13 Jul 2005 13:50:40 -0600
From: Larry Meadors <larry.meadors@gmail.com>
Reply-To: lmeadors@apache.org
To: user-java@ibatis.apache.org
Subject: Re: multiple delete in sqlmap
In-Reply-To: <42D5376C.3080106@univ-nancy2.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <42D5376C.3080106@univ-nancy2.fr>

did you try to do this through JDBC?

Larry


On 7/13/05, olivier ZILLER <Olivier.Ziller@univ-nancy2.fr> wrote:
> hello,
>=20
> i'm using sqlmap and mysql and try to execute a delete statement like thi=
s :
>=20
>     <!-- Suppression d'un objet -->
>     <delete id=3D"deleteObjet"
>         parameterClass=3D"fr.unire.portal.channels.fun.csof.beans.Objet" =
>
>         delete from FUN_ERR_OBJ where NUM_OBJ =3D #numObj#;
>         delete from FUN_INFO_OBJ_LOV where NUM_OBJ =3D #numObj#;
>         delete from FUN_INFO_OBJ where NUM_OBJ =3D #numObj#;
>         delete from FUN_GRP_INFO_OBJ where NUM_OBJ =3D #numObj#;
>         delete from FUN_LANG_OBJ where NUM_OBJ =3D #numObj#;
>         delete from FUN_ARB_OBJ where NUM_FILS_OBJ =3D #numObj#;
>         delete from FUN_CDM_OBJ where NUM_OBJ =3D #numObj#;
>         delete from FUN_PERS_OBJ where NUM_OBJ =3D #numObj#;
>         delete from FUN_OBJET where NUM_OBJ =3D #numObj#;
>     </delete>
>=20
> but i get this error :
>=20
> --- The error occurred in
> /properties/channels/fr_unire/csof/sql-objet.xml.
> --- The error occurred while applying a parameter map.
> --- Check the deleteObjet-InlineParameterMap.
> --- Check the statement (update failed).
> --- Cause: java.sql.SQLException: Syntax error or access violation
> message from server: "You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near ';         delete from FUN_INFO_OBJ_LOV where NUM_OBJ
> =3D 23;         delete from F' at line 1"
> Caused by: java.sql.SQLException: Syntax error or access violation
> message from server: "You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near ';         delete from FUN_INFO_OBJ_LOV where NUM_OBJ
> =3D 23;         delete from F' at line 1"
>     at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate=
(GeneralStatement.java:87)
>     at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecuto=
rDelegate.java:500)
>     at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecuto=
rDelegate.java:523)
>     at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.=
java:93)
>     at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.ja=
va:65)
>     at
> fr.unire.portal.channels.fun.csof.dao.ObjetDAO.deleteObjet(ObjetDAO.java:=
481)
>     ... 18 more
> Caused by: java.sql.SQLException: Syntax error or access violation
> message from server: "You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near ';         delete from FUN_INFO_OBJ_LOV where NUM_OBJ
> =3D 23;         delete from F' at line 1"
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
>     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
>     at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
>     at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:13=
71)
>     at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)
>     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)
>     at java.lang.reflect.Method.invoke(Method.java:324)
>     at
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS=
tatementLogProxy.java:57)
>     at $Proxy2.execute(Unknown Source)
>     at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.=
java:84)
>     at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpd=
ate(GeneralStatement.java:196)
>     at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate=
(GeneralStatement.java:74)
>     ... 23 more
>=20
> any idea on how to do that?
>=20
> regards
>=20
>=20
> --
> Olivier ZILLER
> CRI Gestion
> Universite NANCY2
> 25 rue Baron Louis
> BP 454 NANCY CEDEX
> tel: 03 54 00 11 12 / 06 85 74 89 77 / poste 604
> fax : 03 83 30 05 65
>