How to clear the Cache when i want to?

Hi All,   I am using OSCache for caching query results in iBatis.  I have a cachemodel with flushinterval as 12.  How do i initiate the flush cache myself?   Is there any way i can get the handle to CacheController and call flush on it.   Thanks Prashanth. Yahoo! FareChase - Search multip

Nested Lists [signed]

I've got a bit of a tricky question. I'm trying to retrieve a list of objects from the database. That's the easy part. The hard part is that two properties in the object are also lists. So, when I call the list query, it in turn will call two sub-queries to populate the properties. I've read a

Re: Reusing resultmap for nested object

Thanks for responding Gilles. Thats great news. I just couldn't find it in the docs. I also missed it in the Not Yet Documented on the wiki. Thanks again. Gonna go refactor my maps now. Huy Gilles Bayon wrote: This syntax is supported . On 11/16/05, *Medium* <[EMAIL PROTECTED]

isNotNull / insert / custom type handler

Is this a bug, or am I doing something wrong? Here's my insert statement. INSERT INTO Deployment ( environmentId, deploymentTypeId, deploymentStatusId, deploymentTime ,threadCountOverride ) VALUES ( #environmentId#, #deploymentTypeId#,

Re: FW: returning value from stored procedure

Kevin, since your "id" parameter is in/out I would pass in an inital value, also I think your JDBC type for that parameter wants to be "NUMERIC" not "NUMBER" Regards, Mike Fagan Broderick, Kevin wrote: Hi, Apologies, errors in previous mail. I’m trying to get the return v

Re: Reusing resultmap for nested object

This syntax   is supported .  On 11/16/05, Medium <[EMAIL PROTECTED]> wrote: Hi,Is there a way to reuse a resultmap for a nested object ?I know how to map it as specified by the docs but its getting a bit unwieldly with all the repetition.Docs: Goal: Any help would be greatly appreciated. A simp

FW: returning value from stored procedure

Hi, Apologies, errors in previous mail. I’m trying to get the return values from a stored procedure. Working from the standard example below, Would I be calling the procedure like this:   try {    map.put(“id”, null);    map.put(“email”, “[EMAIL PROTECTED]”)

returning value from stored procedure

  Hi, I’m trying to get the return values from a stored procedure. Working from the standard example below, Would I be calling the procedure like this:   try {    map.put(“email1”, “[EMAIL PROTECTED]”);    map.put(“email1”, “[EMAIL PROTECTED]”);   sqlMapCl

Re: handle auto_increment insert into mysql

Your problem has been discussed previously on this list (http://www.mail-archive.com/user-java@ibatis.apache.org/msg01752.html) Use the tag. INSERT INTO folder (parent_id, owner, foldername) VALUES (#parentId#, #owner#, #foldername#) SELECT LAST_INSERT_ID() AS folderId Good luck,

handle auto_increment insert into mysql

Hello, I am trying to get the hang of using IBATIS. In order to get my hands wet I am running the reumann struts lesson. It is working, and I am trying to add some tables to the example, to get a feel for the framework. But one of the tables has an "auto_increment" (mysql) on it. So when I do a

How to unsubscribe?

Hello, I have tried sending an email to [EMAIL PROTECTED] and it errors out. Is there a different way to unsubscribe from this list? Regards, Joshua