Re: iBatis 3 transaction isolation level control

2010-01-23 Thread Clinton Begin
I've implemented this and committed it to trunk. SqlSessionFactory now has two new openSession methods... SqlSession openSession(TransactionIsolationLevel level); SqlSession openSession(ExecutorType execType, TransactionIsolationLevel level); Clinton On Thu, Jan 14, 2010 at 1:38 AM, Simone

RE: insert going wrong after going from Sybase to MySQL

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

Re: insert going wrong after going from Sybase to MySQL

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

Re: insert going wrong after going from Sybase to MySQL

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