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
