ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Help with identity
Date Wed, 20 May 2009 19:58:12 GMT
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 <koalina82@gmail.com> 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 <koalina82@gmail.com> 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.
>
>

Mime
View raw message