Writing subqueries

2010-01-27 Thread fran . cois
Hi all. As a new iBatis user, I'd like to know how is it possible to write a statement like this one: INSERT into table1 (ville, nom, datn) SELECT l.ville, l.nom, v.datn from mtab l, dpart b, table3 v where b.nom=l.nom and (b.nom,v.datn) not in (SELECT x.nom,x.datn from table1 x) Any example

ibator build from source 1.2.1 running error

2010-01-27 Thread kevin zhao
Hi there, I'm trying to build ibator from source that I downloaded form this address http://people.apache.org/builds/ibatis/ibator/ibator-1.2.1-681.zip. The tool I'm building with is Maven2 and the build is OK as I got the jar file generated. However, I got some error when I was trying to run it

Re: Execute in the same transaction

2010-01-27 Thread Andrea Selva
Hi, i think that the statements are executed in 2 transaction because your connection pool contains more than one connection. To execute the two in the same transaction i suppose you should do something like this: your_sqlMap_cleint_instance.startTransaction();

Re: ibator build from source 1.2.1 running error

2010-01-27 Thread Jeff Butler
I'm not sure, but you could try compiling with the latest source. There have been a lot of changes in Ibator since 1.2.1. You can checkout the latest source tree here: http://svn.apache.org/repos/asf/ibatis/java/ibator/trunk/core/ Ibator now builds with Maven2 so you should already have

Re: Writing subqueries

2010-01-27 Thread Nathan Maves
yes On Jan 27, 2010, at 1:11 AM, fran.c...@free.fr wrote: Hi all. As a new iBatis user, I'd like to know how is it possible to write a statement like this one: INSERT into table1 (ville, nom, datn) SELECT l.ville, l.nom, v.datn from mtab l, dpart b, table3 v where b.nom=l.nom and