I can't use a stored procedure because I can't change the database. I have to get the code (begin transaction...go) working with ibatis syntax... isn't it possible? I've read te documentation but I don't understand how can I retrieve the identity in the same way like the sql syntax.
Michela Clinton Begin wrote: > > Not sure where to start with this one, but you might want to read the > entire > user guide. > * You shouldn't start the transaction in your statement > * Look up <selectKey> specifically in the docs > * This looks like a proc body, so you might want to look up stored proc > support > * In this case, it might be necessary to return it as an output > parameter > > You'll have to play with it to see what works best for you. > > Clinton > > On Wed, May 20, 2009 at 1:25 PM, m.montano <[email protected]> wrote: > >> >> Hi all, i'm a newbie in ibatis... I'm working on MS sql server 2000, >> driver >> jtds. >> The problem is: I have this transaction to execute >> >> begin transaction >> declare @id_audio varchar(20) >> set @id_a = cast(IDENT_CURRENT('file') + ident_incr('file') as varchar) >> INSERT INTO FILEMD (furl, F1, F2, IDA) >> VALUES ('val furl', 'val f1', '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: >> //begin transaction >> sqlMap.startTransaction(); >> >> 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'm not sure how to retrieve 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. >> >> > > -- View this message in context: http://www.nabble.com/Help-with-identity-tp23641858p23642321.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
