Re: Cached list from queryForList() ...

2006-11-15 Thread Eric Tan
a copy of the cached object and modifications are made to this copy and not the cached object. Regards, Eric - Original Message ---- From: Eric Tan <[EMAIL PROTECTED]> To: user-java@ibatis.apache.org Sent: Wednesday, 8 November 2006 12:26:15 AM Subject: Re: Cached list from queryF

Re: Cached list from queryForList() ...

2006-11-07 Thread Eric Tan
read/write cache works?Thanks,Eric- Original Message From: Larry Meadors <[EMAIL PROTECTED]>To: user-java@ibatis.apache.orgSent: Monday, 6 November 2006 11:29:55 PMSubject: Re: Cached list from queryForList() ...Yes: Make sure that the cache is not marked as read-only.LarryOn 11/6/06,

Cached list from queryForList() ...

2006-11-06 Thread Eric Tan
Hi,I was testing Spring Acegi Security's AfterInvocationProviderManager which deals with domain object instance security (ACL). With ibatis caching enabled and queryForList(), I realised that returned result list was the actual cached list. With AfterInvocationProviderManager performing object filt

Re: Updating Multiple Tables per Single Root Object

2006-07-25 Thread Eric Tan
Hi Jeff, Larry,Can you please provide a simple example of what the stored procedure for solving N+1 looks like?I cant use stored procedures mainly due to management concerns about portability, but am really curious how this N+1 case can be done using stored procedures.Thanks,EricJeff Butler <[EMAIL

Re: Isolation level support at the DAO framework level ...

2006-07-12 Thread Eric Tan
ither that or throw a bunch of UnsupportedOperationExceptions.   If you could describe what you're trying to achieve then maybe we could help you find a way to do it.   Jeff Butler   On 7/10/06, Eric Tan <[EMAIL PROTECTED]> wrote: HiSince 2.0.9, the SQL Maps framework has the ability

Isolation level support at the DAO framework level ...

2006-07-10 Thread Eric Tan
HiSince 2.0.9, the SQL Maps framework has the ability to specify isolation level per transaction, eg: sqlMap.startTransaction(Connection.TRANSACTION_REPEATABLE_READ); However, using the DAO framework, there is still no way to specify an isolation level using DaoManager.startTransaction(). Jus

Re: many-to-many relationship practice

2006-07-10 Thread Eric Tan
Hi,There should not be any association class in your domain model. Your domain model should be independent from your data model.Your code would look like your second option, but your might use the entire category object as input:Add item to category...CategoryDao.saveCategory( category ); Then crea

Re: How to set connection isolation level with iBatis DAO and SQL Mapper framework?

2006-05-16 Thread Eric Tan
I just found out that since 2.0.9, isolation level is supported at the SQL Map framework, eg.sqlMap.startTransaction(Connection.TRANSACTION_REPEATABLE_READ);However, from the DAO framework, there is still no way to specify an isolation level using the DaoManager.startTransaction().Is there a way to

How to set connection isolation level with iBatis DAO and SQL Mapper framework?

2006-05-12 Thread Eric Tan
HiI am trying out iBatis DAO and SQL Mapper framework in WebLogic 8.1 server.My dao.xml and sql-map-config.xml are configured as follows:            .  .              Since I am getting my data source from WebLogic through JNDI, how can I set the connection isolation level (eg.