Cache Flushing question

2005-11-10 Thread Paul Benedict
Can the cache be flushed according to a primary key? For instance, the cache can be configured to flush when certain methods are invoked -- but it would be more efficent to simply flush the actual object which has that primary key; and leave the rest of the cache alone. Any thoughts on this idea

RE: Cacheing rowless queries?

2005-11-10 Thread Paul Benedict
No. A non-result means the resultMap is not yet attempted to be populated; an empty result means the resultMap was used in a query with no rows returned. The difference between a NULL and 0, effectively. I like your idea anyhow. --- "Voorhoeve, Niels {PBG}" <[EMAIL PROTECTED]> wrote: > Well, I

RE: Cacheing rowless queries?

2005-11-10 Thread Voorhoeve, Niels {PBG}
Well, I guess the key would be the same...based on the query and the parameters. If it returns no rows/objects then put a regular old java.lang.Object in the cache. If it had not been attempted yet or returned rows then the key wouldn't be there. Is that what you meant by non-result vs. empty re

Re: Cacheing rowless queries?

2005-11-10 Thread Paul Benedict
Niels, That's like a really awesome idea. What kind of marker do you propose to determine a non-result from an empty result? I would find this super valuable. While you're at it, I don't think caching works unless you pass in parameters; I have MANY parameterless queries and I haven't been able

Cacheing rowless queries?

2005-11-10 Thread Voorhoeve, Niels {PBG}
Hi, How difficult / desirable would it be to code a feature in the cacheing mechanism to keep track of queries that do not return any objects? In our case, we end up hitting the database many times for queries that don't return objects. It would be nice to check a cache of non-results to avoid t

RE: Reload SqlMap xml file

2005-11-10 Thread Ming Xue
thanks guys. There seem to be no easy way to handle this problem. I hope this feature can be added into future releases. -Original Message- From: Michael Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:39 PM To: user-java@ibatis.apache.org Subject: Re: Reload SqlMa

Re: oracle hints are treated as comments

2005-11-10 Thread j-lists
iBatis does remove the line breaks and if it stops it'll break my production DB2 app! (And I don't know what it will do to my DB2/400 version) -J :-)On 11/10/05, Paul Benedict <[EMAIL PROTECTED]> wrote: I believe the XML spec does not allow the double dash to appear within a body. The -- is res