RE: How to set datasource thread save?

2007-04-22 Thread Kyohyoh Choh
ate sqlMapClientTem = null; sqlMapClientTem = getSqlMapClientTemplate(); sqlMapClientTem.setDataSource(datasource); domain = sqlMapClientTem.queryForObject(selectID , inobj); Thank you [添付ファイル "winmail.dat" は Kyohyoh Choh/Japan/IBM が削除しました]

How to set datasource thread save?

2007-04-20 Thread Kyohyoh Choh
Hello all Our application use Spring+iBATIS, need to switch among multiple datasources based on user's request datasourceid parameter. We are testing setDataSource() method of SqlMapClientDAOSupport class. We found if we set our DAO class which extends SqlMapClientDAOSupport to be singleton cl

RE: How can I change datasource connect info on the fly w/iBATIS and Spring?

2007-04-16 Thread Kyohyoh Choh
Hello Thank you for point out the cachemodel. To switch different datasources for diffrent users and retrieve the data correctly, we don't want to iBATIS to cache the data, though it maybe have some performance impart. In the sqlmapconfig.xml, we do not turn the cacheModelsEnabled="false", so

Re: How can I change datasource connect info on the fly w/iBATIS and Spring?

2007-04-16 Thread Kyohyoh Choh
Hello Our application has a similar requirement that need to switch among multiple datasources dynamicly, although we do not need to create datasource in fly. We defined the datasources in ApplicationContex.xml, then using getBean to load the datasource depand on the user's request parameter an

iBATIS return null while processing concurrent accesses

2007-04-11 Thread Kyohyoh Choh
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