Re: cache behaviour

I was kinda discussing this with larry last night. Maybe we could have a typed cache that allows identity to be defined based on object properties. So, only a certain type of object could be placed into that cache and anything that is placed into the cache would need to conform to the particular ty

Re: cache behaviour

Might be worthwhile to start a wiki whiteboard page to discuss how this could be done. Without object identity, it would be quite hard. We could perhaps base it on .equals()/.hashCode() (hashcode not for uniqueness, but for performance).  Other thoughts? Cheers, ClintonOn 6/28/05, Paul Barry <[

Re: cache behaviour

No, it doesn't, as far as I know, but if you find out that it does, let me know, because fine-grain cache invalidation is a feature that I have been wanting ibatis to have for a long time. On 6/28/05, Ed Griebel <[EMAIL PROTECTED]> wrote: > I've just started looking at it, but doesn't using the OS

Re: Fwd: Post Generated Keys

And of course I sent my reply to Larry directly instead of the list :-D On tis, 2005-06-28 at 20:33 +0200, Joakim Olsson wrote: > That shouldn't happen since sequence.currval is limited to the current > session and only valid until the data has been commit:ed or rolled back > if I remember correct

Re: I guess one can not parameterize the table name

You might want to add the bit about this being a performance impactor, into the Wiki page. Would you mind?   Brice  On 6/28/05, Nathan Maves <[EMAIL PROTECTED]> wrote: Just a reminder but using this is a performance hit.  I have never run into the case where using this type of statement is useful. 

Re: Ibatis Cache not flushing

hmmm, very interesting. Can you file a JIRA report on this? Thanks, Brandon On 6/28/05, Rao, Satish <[EMAIL PROTECTED]> wrote: > Hi Brandon, > > I added namespace to and modified to include > namespace. Interestingly, I am back to my original problem. After > inserting a new user or deleting e

RE: Ibatis Cache not flushing

Hi Brandon, I added namespace to and modified to include namespace. Interestingly, I am back to my original problem. After inserting a new user or deleting existing user, the cache does not flush. -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June

Re: Ibatis Cache not flushing

I would recommend using namespaces if your project is of any significant size. Otherwise you may run into name conflicts between mapped statements in different sqlmap files. Brandon On 6/28/05, Rao, Satish <[EMAIL PROTECTED]> wrote: > I removed the namespace from and it worked just fine. > > Th

RE: Ibatis Cache not flushing

I removed the namespace from and it worked just fine. Thanks for your help. -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 1:17 PM To: user-java@ibatis.apache.org Cc: Rao, Satish Subject: Re: Ibatis Cache not flushing you are in a names

Re: Ibatis Cache not flushing

you are in a namespace. try: Brandon On 6/28/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > Satish, > > I am cc'ing the alias to get more help. > > Nathan > > > On Jun 28, 2005, at 11:04 AM, Rao, Satish wrote: > > Hi Nathan, > > Thanks for the prompt reply. >

Re: Ibatis Cache not flushing

Satish,I am cc'ing the alias to get more help.  NathanOn Jun 28, 2005, at 11:04 AM, Rao, Satish wrote: Hi Nathan,   Thanks for the prompt reply.   I already had caching turned on in the sqlmap config file. Here's the file entry     cacheModelsEnabled="true"   enhancementEnabled="false"   lazyLoadi

INSERT disrupts Resultset from Stored Procedure?

Dear all, Another stored procedure issue. I can't have the following INSERT INTO statement in my stored procedure. Otherwise, the queryForList won't work (throwing exception). Does this insert incur any resultset as well? Many thanks, Bing /// Stored Proced

Re: I guess one can not parameterize the table name

Just a reminder but using this is a performance hit.  I have never run into the case where using this type of statement is useful.  I find that copy and paste, then change the table name is much cleaner then select * from $table_name$Personal Preference!NathanOn Jun 28, 2005, at 10:45 AM, Brice Rut

Re: I guess one can not parameterize the table name

Just add that attribute to your definition in the XML. There isn't much else to give you ...   SQL goes here   Of course, order of attributes is not important at all ... this is just a sample!  On 6/28/05, Folashade Adeyosoye <[EMAIL PROTECTED]> wrote: Thanks   Can you give a sample showing ho

RE: I guess one can not parameterize the table name

Thanks   Can you give a sample showing how to use remapResutls=true   Can’t find it in the docs..   thanks   From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 11:44 AM To: user-java@ibatis.apache.org Subject: Re: I guess one can not parameterize the

Cache not being flushed

Title: Cache not being flushed I have the following xml                            

Re: I guess one can not parameterize the table name

It is in the docs, but not very prominently. The $$ syntax should be used with caution because of it's obvious potential for SQL injection attacks. Larry On 6/28/05, Brice Ruth <[EMAIL PROTECTED]> wrote: > Is this in the Wiki? If not, maybe it ought to be? I guess I could check > myself ... :)

Re: cache behaviour

I've just started looking at it, but doesn't using the OSCache model (plugin?) provide finer-grained flushing, based on the key for the dependant query? Thanks, -ed On 6/28/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > It will cache several objects returned, depending upon the cache > controller

Re: I guess one can not parameterize the table name

Is this in the Wiki? If not, maybe it ought to be? I guess I could check myself ... :) On 6/28/05, Nathan Maves <[EMAIL PROTECTED]> wrote: Yes you can.   You need to use $value$ as well as use remapResutls=true   Nathan   On Jun 28, 2005, at 9:35 AM, Folashade Adeyosoye wrote: Such as   sele

Re: I guess one can not parameterize the table name

select * from $value$ where TheStatus = 'ACTIVE' and type = COLOR --- Folashade Adeyosoye <[EMAIL PROTECTED]> wrote: > Such as > > > > select * from #value# where TheStatus = 'ACTIVE' and type = COLOR > > > > > > shardayyy > > > > > >

Re: I guess one can not parameterize the table name

Yes you can.You need to use $value$ as well as use remapResutls=trueNathanOn Jun 28, 2005, at 9:35 AM, Folashade Adeyosoye wrote:Such as select * from #value# where TheStatus = 'ACTIVE' and type = COLOR  shardayyy  

I guess one can not parameterize the table name

Such as   select * from #value# where TheStatus = 'ACTIVE' and type = COLOR     shardayyy    

Fwd: Post Generated Keys

Oops...accidentally replied to Steven directly. -- Forwarded message -- From: Larry Meadors <[EMAIL PROTECTED]> Date: Jun 28, 2005 9:15 AM Subject: Re: Post Generated Keys To: "Mitchell, Steven C" <[EMAIL PROTECTED]> Yes, that is possible in an environment where updates happen si

Re: PaginatedList question

Hi Clinton, I'm interested in knowing why you would discourage the use of the paginated list in a "high performance" system? In response to another post... In order to compute the number of pages (using the paginatedlist), a simple binary search method can be applied once when the result is firs

RE: Post Generated Keys

Larry, Your suggestion of using sequence.currval works great. I just left the ID column off of the insert statement. I assume there is some risk of getting the wrong ID during simultaneous updates. I'll get triggers turned off as soon as we cut over to the new application and go back to pre-gen

Re: Get return value of stored procedure

HAHAHAHA! Clinton, you made me laugh hard! "Undocumented stuff" is documented in the wiki! He he! ;-) Well, at least it is a better situation than Oracle's undocumented parameters. Daniel Silva. On 6/28/05, Clinton Begin <[EMAIL PROTECTED]> wrote: > > The syntax I used is the newer one...and

Re: Get return value of stored procedure

The syntax I used is the newer one...and yes it's undocumented right now You can find it in the "undocumented stuff" section of the wiki.  ;-) ClintonOn 6/28/05, Bing Qiao <[EMAIL PROTECTED]> wrote: I realized that too. Thanks.BTW, the inline parameter format given by Clinton:"{#value,mode=O

RE: Map of Objects for Result

Title: Message That is what I figured.  Thanks Nathan and Clinton for your help.     Thanks.Carson Reinke[EMAIL PROTECTED]P: 248.333.7700 x108  -Original Message-From: Clinton Begin [mailto:[EMAIL PROTECTED] Sent: Monday, June 27, 2005 10:50 PMTo: user-java@ibatis.apache

Re: PaginatedList question

Could you add your experience with this to the WIKI? Something in the FAQ re: "How do I get record/page counts for a mapped statement?" would be great. Larry On 6/28/05, Aladin <[EMAIL PROTECTED]> wrote: > Hi, > > Thanks for the responses. It's unfortunate that the documentation was > wrong..

Re: PaginatedList question

Hi, Thanks for the responses. It's unfortunate that the documentation was wrong... because that would have been a nice way of getting a general idea as to the number of pages in the set. Aladin Clinton Begin wrote: The documentation is mistaken. Previous() should not wrap for the pagin

Re: cache behaviour

It will cache several objects returned, depending upon the cache controller specified. One thing to be aware of is that the cache is not aware of object identity - which means that if you update *anything* in that cache, all of the objects in the cache are flushed, not just the one that was updated

cache behaviour

HI! I have a SQL select to return only one resutl each time, something like: Select * from product where id=#value#   and i want to cache the results. I don't know if the cache-model configuration form ibatis will store every object the query returns or it will replace each time the last obje

Re: BindException on db call

I didn't think it would try to bind any ports, which is what confused me - the only reference I can find to what it would be trying to bind is "JVM_Bind", and I'm not sure what this means (I think that this would normally be the place in the exception to mention the IP and port it was trying to bin

Re: Get return value of stored procedure

I realized that too. Thanks. BTW, the inline parameter format given by Clinton: "{#value,mode=OUT,jdbcType=INTEGER# = call TestReturnValue}" is not the same as that in the online document: "insert into PRODUCT (PRD_ID, PRD_DESCRIPTION) values (#id:NUMERIC#, #description:VARCHAR#);" Where can I