Use the is a holdover from iBATIS 1.x I believe.
Jeff Butler
On Sat, Jan 23, 2010 at 4:20 PM, StevenF wrote:
>
> Hi Guys,
>
> Still no luck here.
>
> I have this, but doesn't work:
>
> parameterClass="nl.chessone40.domain.Chesser" >
>
> select last_ins
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 wrote:
>
> Hi Guys,
>
> Still n
Hi Guys,
Still no luck here.
I have this, but doesn't work:
select last_insert_id() as value
INSERT INTO Chesser
(login,
password,
firstName,
lastName,
credits)
value
te...@web2.filipowicz.com]
Sent: Friday, January 22, 2010 11:32 PM
To: user-java@ibatis.apache.org
Subject: Re: insert going wrong after going from Sybase to MySQL
Hi Thanks for the reply!
Ok so I did this:
INSERT INTO Chesser
(login,
password,
Hi Thanks for the reply!
Ok so I did this:
INSERT INTO Chesser
(login,
password,
firstName,
lastName,
credits)
values
(#login#,
#password#,
#firstName#,
#lastName#,
CORRECTION
select last_insert_id()
Damn these fat fingers
--- On Fri, 22/1/10, StevenF wrote:
> From: StevenF
> Subject: insert going wrong after going from Sybase to MySQL
> To: user-java@ibatis.apache.org
> Date: Friday, 22 January, 2010, 15:19
>
> Hi All,
>
> I'm switching the database o
MySql doesn't do @@IDENITY
Use this:
select last_insert_id
instead
--- On Fri, 22/1/10, StevenF wrote:
> From: StevenF
> Subject: insert going wrong after going from Sybase to MySQL
> To: user-java@ibatis.apache.org
> Date: Friday, 22 January, 2010, 15:19
>
> Hi All,
>
> I'm switching the
