RE: Two quick questions..

Title: Two quick questions.. I'll add to those questions   1) Be careful when updating cached data in a transactional environment.  If you update a cached object, then calling a rollback will undo db changes but not changes to the object in memory.  You should clone cached object before updat

Two quick questions..

Title: Two quick questions.. 1. Can I selectively use lazy loading for some results but not others? How do I specify this? I only see one global setting in sqlMapConfig.xml. 2. How does iBatis caching know that data/object to be retrieved is already in cache? Does it use SQL statement as key

Re: cacheModel - Database Down and external app flush

Thanks Sven for the quick response. I am a beginner to iBatis, so I apologize in advance if I don't know some of the answers to your questions. I'll try my best. In regards to 2), I figured that was the case by the same reasoning. I just wanted to make sure with someone who had more experience wi

Re: cacheModel - Database Down and external app flush

For 1): do you have the full nested stacktrace? Did you deactivate the ping query? and are you sure the exception originates in iBATIS (we'll see from the full stacktrace). The intention of a cache is to speed things up, it's not the intention to have a complete in-core database. For 2) Ther

cacheModel - Database Down and external app flush

I have a few questions regarding iBatis cacheModel. All help is greatly appreciated.   1) When the iBatis cacheModel is used, a connection to the database server appears to be still required. The data has been cached, so I'm not sure why the database server needs to be up after caching the

building query using values from 2 lists

Hi   I have two lists that I need to iterate in order in build my SQL statement.  I would like to know how I would go about in doing that using iBatis.   I have 2 list: partitionList=[01, 02]; IDList=[10001, 10002];   Basically it should look like this: SELECT DISTINCT NVL(attr_display_nam

Re: Procedures in iBatis

Sorry, I don't have an example of a stored procedure without any properties. I was assuming that you needed some result from your stored procedure call. What exactly is the use of doing select statements without having a result? [EMAIL PROTECTED] wrote: Hi, I don't have any property to specify

RE: Procedures in iBatis

Hi, I don't have any property to specify. Please let me know. Regards, Suman Mishra 203-719-1698 -Original Message- From: Beemsterboer Software [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 12:17 PM To: user-java@ibatis.apache.org Subject: Re: Procedures in iBatis Try t

Re: Procedures in iBatis

Try this: {call get_data()} [EMAIL PROTECTED] wrote: Hi, I have a sybase procedure which doesnt take any parameter. Its a combination of few select statements. Can someone please help me with the syntax where parameter property is blank. Can s

Procedures in iBatis

Hi,   I have a sybase procedure which doesnt take any parameter. Its a combination of few select statements. Can someone please help me with the syntax where parameter property is blank.   Can someone help me with this block -

Re: Using Joins

Hi Suresh,Give us your current SQLMap XML for this, and the code for the beans/POJOs involved.  Without seeing the configuration of your result maps, it's hard to help you.Ted On 18/04/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I am using following select query.   Select * fro