ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: insert going wrong after going from Sybase to MySQL
Date Sat, 23 Jan 2010 22:54:37 GMT
Keep the selectKey after the statement for MySQL and other auto-increment
style key generators.  Only sequences like those supported by Oracle should
come before the statement.

Also, a full stack trace might help.

Clinton

On Sat, Jan 23, 2010 at 3:20 PM, StevenF <steven@web2.filipowicz.com> wrote:

>
> Hi Guys,
>
> Still no luck here.
>
> I have this, but doesn't work:
> ----------------------------
>     <statement id = "insertChesser"
> parameterClass="nl.chessone40.domain.Chesser" >
>     <selectKey resultClass="int" keyProperty="chesserId">
>       select last_insert_id() as value
>    </selectKey>
>         INSERT INTO Chesser
>            (login,
>            password,
>            firstName,
>            lastName,
>            credits)
>        values
>            (#login#,
>            #password#,
>            #firstName#,
>            #lastName#,
>            #credits#)
>     </statement>
> ----------------------------
>
> Also tried:
> ----------------------------
>    <insert id = "insertChesser"
> parameterClass="nl.chessone40.domain.Chesser" >
>     <selectKey resultClass="int" keyProperty="chesserId">
>       select last_insert_id() as value
>    </selectKey>
>         INSERT INTO Chesser
>            (login,
>            password,
>            firstName,
>            lastName,
>            credits)
>        values
>            (#login#,
>            #password#,
>            #firstName#,
>            #lastName#,
>            #credits#)
>     </insert >
> ---------------------------
>
> This gives an error:
> SqlMapClient operation; uncategorized SQLException for SQL []; SQL state
> [null]; error code [0]; Insert statements cannot be executed as a query.;
> nested exception is java.sql.SQLException: Insert statements cannot be
> executed as a query.
>
> What is the difference between <statement id="...> and <insert id="...> ?
>
> Thanks for the help!!
>
>
> Niels Beekman-2 wrote:
> >
> > Your XML is simply invalid, use an editor that supports DTD validation.
> > The selectKey element can only be used inside select elements.
> >
> > I also think that resultClass="java.lang.Long" is obsolete, and should
> > be removed.
> >
> > Niels
> >
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/insert-going-wrong-after-going-from-Sybase-to-MySQL-tp27274795p27290482.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message