Ok, don't know for sure, but wouldn't you be able to loop through the list after the batch has executed and check the id (keyProperty) on your records?
-----Original Message----- From: Westhveg [mailto:westhstud...@gmail.com] Sent: 09 July 2009 11:47 AM To: user-java@ibatis.apache.org Subject: RE: Retrieve inserted id in mass insert using SqlMapExecutor. Hello meindert-3, Thanks for your reply. This is correct and in my case is already working. But my problem is when I use batch processes. Remembering the code: public List<T> createRecordsMassively(final List<T> records) { getSqlMapClientTemplate().execute(new SqlMapClientCallback() { public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException { executor.startBatch(); for (T record : records) { executor.insert("insertRecord", record); } //List<BatchResult> result = executor.executeBatchDetailed(); int rowsAffected = executor.executeBatch(); return new Integer(rowsAffected); } }); /*Deal with result*/ } In the line 'executor.insert("insertRecord", record);' I always recieve 0. I think this is because is a batch process and it's being executed after, in line 'executor.executeBatch()'. So, just for clarify, if I execute 'insertRecord' WITHOUT batch process, it returns the ID. If I use Batch process (the reason of this post) I always recieve 0. Thanks, Westhveg meindert-3 wrote: > > Put the name of the property that hold the ID in the sql map and the > record get's updated with the id and your insert statement returns the id > object > > Here is MS SQl example, just replace SELECT @@IDENTITY with the correct > query for Mysql to fetch the ID > <insert id="ibatorgenerated_insert" parameterClass=".." > > <!-- > WARNING - This element is automatically generated by Apache iBATIS > ibator, do not modify. > This element was generated on Fri Mar 06 08:29:29 GMT 2009. > --> > insert into online_upload_log (id, userid, actmonth, basemonth, > datestamp, result) > values (#uploadLogId:INTEGER#, #userid:INTEGER#, #actmonth:INTEGER#, > #basemonth:BIT#, > #datestamp:TIMESTAMP#, #result:LONGVARCHAR#) > <selectKey resultClass="java.lang.Integer" keyProperty="uploadLogId" > > SELECT @@IDENTITY > </selectKey> > </insert> > > Meindert > > -----Original Message----- > From: Westhveg [mailto:westhstud...@gmail.com] > Sent: 09 July 2009 10:34 AM > To: user-java@ibatis.apache.org > Subject: Retrieve inserted id in mass insert using SqlMapExecutor. > > > Hello, > > My environtment is: > > Java 1.6 > iBatis 2.3.4 > Spring 2.5.6 > MySQL > > > I've a method to create records massively (I write directly, it can has > sintax errors; just take the idea): > > public List<T> createRecordsMassively(final List<T> records) { > > getSqlMapClientTemplate().execute(new SqlMapClientCallback() { > > public Object doInSqlMapClient(SqlMapExecutor executor) throws > SQLException { > executor.startBatch(); > > for (T record : records) { > executor.insert("insertRecord", record); > } > > //List<BatchResult> result = executor.executeBatchDetailed(); > int rowsAffected = executor.executeBatch(); > return new Integer(rowsAffected); > } > }); > > /*Deal with result*/ > > } > > It works well. The problem is: I want to know which records are correctly > inserted and which aren't. I need the Id in order to execute some logic > with > each inserted record. ¿What's the way? ¿How can I retrieve the id of the > inserted records? > > > Thanks in advance, > > Westhveg > -- > View this message in context: > http://www.nabble.com/Retrieve-inserted-id-in-mass-insert-using-SqlMapExecutor.-tp24406261p24406261.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > Checked by AVG - www.avg.com > Version: 8.5.375 / Virus Database: 270.13.8/2223 - Release Date: 07/08/09 > 21:51:00 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > -- View this message in context: http://www.nabble.com/Retrieve-inserted-id-in-mass-insert-using-SqlMapExecutor.-tp24406261p24407224.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org Checked by AVG - www.avg.com Version: 8.5.375 / Virus Database: 270.13.8/2223 - Release Date: 07/08/09 21:51:00 --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
