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:[email protected]]
> Sent: 09 July 2009 10:34 AM
> To: [email protected]
> 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: [email protected]
> For additional commands, e-mail: [email protected]
>
>
> 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: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
--
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: [email protected]
For additional commands, e-mail: [email protected]
