Re: insert going wrong after going from Sybase to MySQL

2010-01-23 Thread Jeff Butler
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/i

Re: insert going wrong after going from Sybase to MySQL

2010-01-23 Thread Clinton Begin
t; 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

RE: insert going wrong after going from Sybase to MySQL

2010-01-23 Thread StevenF
> -- 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-m

RE: insert going wrong after going from Sybase to MySQL

2010-01-22 Thread Niels Beekman
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,

Re: insert going wrong after going from Sybase to MySQL

2010-01-22 Thread StevenF
View this message in context: http://old.nabble.com/insert-going-wrong-after-going-from-Sybase-to-MySQL-tp27274795p27280982.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. - To unsubscribe, e-mail: user-jav

Re: insert going wrong after going from Sybase to MySQL

2010-01-22 Thread charlie bird
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&

Re: insert going wrong after going from Sybase to MySQL

2010-01-22 Thread charlie bird
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,

insert going wrong after going from Sybase to MySQL

2010-01-22 Thread StevenF
L? Any help is very welcome! Thanks! -- View this message in context: http://old.nabble.com/insert-going-wrong-after-going-from-Sybase-to-MySQL-tp27274795p27274795.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. -