BTW: Leave out the begin/commit transaction lines... iBATIS will do that through the driver.
On Wed, May 20, 2009 at 1:58 PM, Clinton Begin <[email protected]>wrote: > You're better off with JDBC then. There's too much of a mismatch for this > SQL. It might not be impossible, but it certainly wouldn't be easy. > Try it out, but if iBATIS is a hammer, this isn't a nail... > > Clinton > > > On Wed, May 20, 2009 at 1:53 PM, m.montano <[email protected]> wrote: > >> >> 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. >> >> >
