Re: Help with identity

2009-05-20 Thread Clinton Begin
', @id_a) > >> >> INSERT INTO ANNUNCI (idann, F3, F4, ida) > >> >> VALUES ('val idann', 'val f3', 'valore f4', @id_a) > >> >> commit transaction > >> >> GO > >> >> > >> >>

Re: Help with identity

2009-05-20 Thread m.montano
val f2', @id_a) >> >> INSERT INTO ANNUNCI (idann, F3, F4, ida) >> >> VALUES ('val idann', 'val f3', 'valore f4', @id_a) >> >> commit transaction >> >> GO >> >> >> >> I'm trying with: >

Re: Help with identity

2009-05-20 Thread Clinton Begin
a) >> >> commit transaction >> >> GO >> >> >> >> I'm trying with: >> >> //begin transaction >> >> sqlMap.startTransaction(); >> >> >> >> int idAudio = 000;//to retrieve + increment ...how? >> >

Re: Help with identity

2009-05-20 Thread Clinton Begin
> >> I'm trying with: > >> //begin transaction > >> sqlMap.startTransaction(); > >> > >> int idAudio = 000;//to retrieve + increment ...how? > >> > >> amdr.setIdAudio(idAudio ); > >> sqlMap.insert("insertFileMD", amd

Re: Help with identity

2009-05-20 Thread m.montano
dio ); >> sqlMap.insert("insertFileMD", amdr); >> ann.setIdAudio(idAudio ); >> sqlMap.insert("insertAnnuncio", ann); >> >> sqlMap.commitTransaction(); >> //commit transaction >> >> >> I'm not sure how to retrieve th

Re: Help with identity

2009-05-20 Thread Clinton Begin
int idAudio = 000;//to retrieve + increment ...how? > > amdr.setIdAudio(idAudio ); > sqlMap.insert("insertFileMD", amdr); > ann.setIdAudio(idAudio ); > sqlMap.insert("insertAnnuncio", ann); > > sqlMap.commitTransaction(); > //commit transaction > > > I&#x

Help with identity

2009-05-20 Thread m.montano
rieve the idAudio (the identity column in FILEMD)... can please you help me? thanx for support, have a nice day, Michela -- View this message in context: http://www.nabble.com/Help-with-identity-tp23641858p23641858.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.