Re: [Springframework-developer] How to do batch with Spring using Ibatis

[Dmitriy K. <dko...@ru...>]

Oops, didn't see your email. Glad that you solved it ;-)

Cheers,
Dmitriy.

Dmitriy Kopylenko wrote:

> Stefan,
>
> declare FamiliesBO argument as final i.e.
>
> public void deleteFamily(final FamiliesBO fbo) throws 
> DataAccessException {...}
>
> Regards,
> Dmitriy.
>
>
> Stefan D Sookraj wrote:
>
>> OK,
>> I put 'public' in front of the line and that got rid of the error. i.e.
>>  
>> public Object doInSqlMapClient(SqlMapExecutor executor) throws 
>> SQLException
>>  
>> now, the only issue I am having is that I am having an error on the 
>> passed in business object (fbo).
>>  
>> The error is: 'Cannot refer to a non-final variable fbo inside an 
>> inner class defined in a different method'
>>  
>>  
>> public void deleteFamily(FamiliesBO fbo) throws DataAccessException {
>>  
>>       getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
>>          public Object doInSqlMapClient(SqlMapExecutor executor) 
>> throws SQLException {
>>             executor.startBatch();
>>             executor.delete("AuthMaint.deleteCatExtendName", 
>> fbo.getMethodElement());
>>             Iterator itr = fbo.getRepItem().iterator();
>>             while (itr.hasNext()) {
>>                Map m = (HashMap) itr.next();
>>                executor.delete("AuthMaint.deleteDocMap", m);
>>                executor.delete("AuthMaint.deleteRepItem", m);
>>             }
>>             executor.delete("AuthMaint.deleteContentEdition", 
>> fbo.getMethodElement());
>>             executor.delete("AuthMaint.deleteMthElem", 
>> fbo.getMethodElement());
>>  
>>             executor.executeBatch();
>>          }
>>       });
>>  
>>    }
>>  
>>  
>>  
>>  
>>  
>>  
>>  
>>  
>> Juergen,
>> Thank you for the response. I am getting this error trying to 
>> implement the code snippit you provided.
>>  
>> At this line I get the error:
>> Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException
>>  
>> Error:
>> Cannot reduce the visibility of the inherited method from 
>> SqlMapClientCallback
>>  
>>  
>> I am doing this in my DAO in my doUpdate method.
>>  
>>  
>>  
>>  
>>  
>>  
>>  
>>  
>>  
>> Saturday, July 31, 2004 10:51 AM
>> To: <spr...@li...>
>> cc:
>> From: jürgen höller [werk3AT] <jue...@we...>
>> Subject: Re: [Springframework-developer] How to do batch with Spring 
>> using Ibatis
>>  
>>  
>>  
>> Implement a custom SqlMapClientCallback for this, a la:
>>  
>> getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
>> Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
>> executor.startBatch();
>> executor.update(...);
>> executor.update(...);
>>  
>> executor.executeBatch();
>> }
>> });
>>  
>> Generally, a SqlMapClientCallback allows you to call any methods on 
>> the passed-in com.ibatis.sqlmap.client.SqlMapExecutor object. The 
>> template will automatically convert SQLExceptions to 
>> DataAccessExceptions, just like it does for the convenience 
>> operations defined on the template itself.
>>  
>> Juergen
>>  
>>  
>> ________________________________
>>  
>> Von: spr...@li... im Auftrag 
>> von Stefan D Sookraj
>> Gesendet: Sa 31.07.2004 16:08
>> An: spr...@li...
>> Cc: spr...@li...; cli...@ib...
>> Betreff: [Springframework-developer] How to do batch with Spring 
>> using Ibatis
>>  
>>  
>>  
>>  
>>  
>>  
>>  
>> How do you invoke the underlying Ibatis API batch methods from 
>> Spring? I am
>> using org.springframework.orm.ibatis.SqlMapClientTemplate, but the 
>> iBatis
>> batch API is not exposed. If I use Ibatis API directly, I have to handle
>> the SQLExceptions. Is this the right way to be able to use the IBatis 
>> batch
>> API from Spring? Thank you.
>>  
>>  
>>  
>> -------------------------------------------------------
>> This SF.Net email is sponsored by OSTG. Have you noticed the changes on
>> Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
>> one more big change to announce. We are now OSTG- Open Source Technology
>> Group. Come see the changes on the new OSTG site. www.ostg.com
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>  
>>  
>>  
>>  
>> -------------------------------------------------------
>> This SF.Net email is sponsored by OSTG. Have you noticed the changes on
>> Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
>> one more big change to announce. We are now OSTG- Open Source Technology
>> Group. Come see the changes on the new OSTG site. www.ostg.com
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by OSTG. Have you noticed the changes on
> Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> one more big change to announce. We are now OSTG- Open Source Technology
> Group. Come see the changes on the new OSTG site. www.ostg.com
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer