iBATIS return null while processing concurrent accesses

[Kyohyoh Choh <CH...@jp.ibm.com>]

Hello all

We are using Spring(1.1.5)+iBATIS(2.0) in our system, for sqlMapClient, we
use org.springframework.orm.ibatis.support.SqlMapClientDaoSupport to access
a DB2 database. When we have multiple users access the system concurrently,
we have found sometimes iBATIS returned null though there are data in the
tables. From the JDBC trace result, it seems iBATIS doesn't send sql
request to DB2 when null result returned. This doesn't happen when single
user access the system. And we don't see CPU/Memory resouce problem when
this happened.

Any idea for this? Thank you very much

how to find SQL Query based on StatementID

[ra...@axa.com.au]

Iam using Spring with iBatis framework
I have the following requirement. I have to implement Batch execute 
function
which takes the list of statementId and Parame Object and it has to 
identify which operation it has to perform, and call the corresponding 
method.

The statementId might refer to any of the update/insert or delete . So i 
have to findout the whether the underlying SQL is update or insert or 
delete from the statementID. Is it possible programatically?

to be precise

public void executeBatch(DatabaseServiceVO databaseServiceVO) throws 
ApplicationRuntimeException {
getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor) throws 
SQLException {
executor.startBatch();
String statementId = databaseServiceVO.getStatementID();
/************************************************** *****/
Here i want to identify whether it is insert/update/delete
based on the statementId. Is it possible.? if possible how to do 
that? so that based on that i will call
executor.insert or executor.delete or executor.update
/************************************************** *****/

executor.executeBatch();
}
});
}


When i posted this query to Spring forum they directed me to ask Ibatis 
forum.

http://forum.springframework.org/showthread.php?p=111346#post111346

Can you please provide me help on this.

Thanks and regards,
Ravi
Consultant for AXA,
AXA Towers
Off   : +61-3-9618-4677
Mob : +61-0411-44-5298
AXA and AllianceBernstein: Winner of 'Morningstar Fund Manager of the Year
2006 - Australia'.
*********************************************************************************
Important Note
This email (including any attachments) contains information which is 
confidential and may be subject to legal privilege.  If you are not 
the intended recipient you must not use, distribute or copy this 
email.  If you have received this email in error please notify the 
sender immediately and delete this email. Any views expressed in this 
email are not necessarily the views of AXA.   Thank you.
**********************************************************************************