Re: the return result of insert, update, and delete in SqlMapClient API

2005-12-13 Thread Leonardo Kenji Shikida
I believe it means the number of affected rows (just like jdbc) On 12/13/05, John Chien <[EMAIL PROTECTED]> wrote: > The SqlMapClient API indicates: > > public int insert(String statementName, Object parameterObject) throws > SQLException. > public int update(String statementName, Object parameter

Re: mysql autoincrement zero value

2005-12-07 Thread Leonardo Kenji Shikida
( On 12/7/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > Why are you inserting into an auto_increment field? > > Larry > > > On 12/7/05, Leonardo Kenji Shikida <[EMAIL PROTECTED]> wrote: > > if I try to insert an object with id=0 into a mysql table that hav

mysql autoincrement zero value

2005-12-07 Thread Leonardo Kenji Shikida
if I try to insert an object with id=0 into a mysql table that have an autoincrement id column, strange things happens mysql silently inserts that object with messy values. very dangerous. is there any workaround for this in mysql or ibatis? or will I have to check explictly for zeroed ids and th

Re: how to commit a connection?

2005-12-06 Thread Leonardo Kenji Shikida
sorry. It was an stupid question. You actually answered what I've asked. thanks Kenji

Re: how to commit a connection?

2005-12-06 Thread Leonardo Kenji Shikida
hat the following method, myClass.executeSomeSqlWithoutIbatisHere(con); in this given context, means an actual update? > Cheers, > Clinton > > > On 12/5/05, Leonardo Kenji Shikida <[EMAIL PROTECTED]> wrote: > > I have an application that uses ibatis and an older legacy d

how to commit a connection?

2005-12-05 Thread Leonardo Kenji Shikida
I have an application that uses ibatis and an older legacy database schema, both in the same mysql database. I would like to share the same connection to ibatis methods and the legacy code, so I could use transactions to control both applications I have a snippet as follows SqlMapClient dbclient