Use the <insert... form.
Then do this in Java:
Integer id = sqlMap.insert("insertChesser", parameter);
<statement> is a holdover from iBATIS 1.x I believe.
Jeff Butler
On Sat, Jan 23, 2010 at 4:20 PM, StevenF <ste...@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-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
