Re: ibatis cache miss duplicate request

2008-05-08 Thread Clinton Begin
The cache only blocks when it's updating from the first result. It won't stop the other requests from executing. So it's the latter. That should be very unlikely, and if it's not, maybe consider seeding the cache (if the requests are that predictable) or use a second level caching solution. Inc

ibatis cache miss duplicate request

2008-05-08 Thread Vic Cekvenich
Hello again list :-). When I have a cache miss on a select that runs long; and another request comes to ibatis, does it run the query both times? ...or if there are 10 requests that come on a cache miss. tia, .V

Re: How to get the generated key from insert with Oracle

2008-05-08 Thread Larry Meadors
Not with a sequence, I've been told that they are 'session' aware, so if you get id 123 in your session, no one else ever will. Larry On Thu, May 8, 2008 at 4:21 PM, Chris O'Connell <[EMAIL PROTECTED]> wrote: > Even if I am executing all of this inside a transaction, don't I still have > concur

RE: How to get the generated key from insert with Oracle

2008-05-08 Thread Chris O'Connell
Even if I am executing all of this inside a transaction, don't I still have concurrency issues with this approach? -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 5:12 PM To: user-java@ibatis.apache.org Subject: Re: How to get the generated ke

Re: How to get the generated key from insert with Oracle

2008-05-08 Thread Larry Meadors
I think this would be the preferred SQL for that: select ids.currval from dual ...where ids is your sequence's name. Larry

How to get the generated key from insert with Oracle

2008-05-08 Thread Chris O'Connell
So, I need to insert a User record. I cannot change the database tables, so I am stuck with the current behavior of my database. On insert, there is a trigger that selects a value from a SEQUENCE and updates the key with that value. I would like to return that value from the insert statement to

Re: sqp maps, namespaces a queries' IDs

2008-05-08 Thread Christopher Lamey
If you set useStatementNamespaces to 'false', you will not be able to use the 'ns.query' notation - you are disabling the feature. If you set useStatementNamespaces to 'true', you are enabling the feature and can use the 'ns.query' notation. On 5/8/08 2:56 PM, "Filipe David Manana" <[EMAIL PROTEC

RE: sqp maps, namespaces a queries' IDs

2008-05-08 Thread Niels Beekman
No, if you enable namespaces, you must specify them when you're executing queries. Of course you can create utility classes that do this. Niels From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Filipe David Manana Sent: Thursday, May 08, 2008 10:5

Re: sqp maps, namespaces a queries' IDs

2008-05-08 Thread Filipe David Manana
Ah! So, even with false (default) for the useStatementNamespaces setting, I will be able to use the Namespace.queryName notation? right? thanks a lot On Thu, May 8, 2008 at 10:24 PM, Christopher Lamey <[EMAIL PROTECTED]> wrote: > Hello, > > Yes you can. > > Please see page 10 of the iBATIS PDF

Re: sqp maps, namespaces a queries' IDs

2008-05-08 Thread Christopher Lamey
Hello, Yes you can. Please see page 10 of the iBATIS PDF, specifically the section on useStatementNamespaces for details. Cheers, Chris On 5/8/08 1:47 PM, "Filipe David Manana" <[EMAIL PROTECTED]> wrote: > Hi, > > In my app I have several sql maps (each one in a separate xml file). Each > sq

sqp maps, namespaces a queries' IDs

2008-05-08 Thread Filipe David Manana
Hi, In my app I have several sql maps (each one in a separate xml file). Each sql map has a diferent purpose, so each one has a different namespace. It happens that I have different sql maps (different namespaces) with queries (select) that have the same ID. When I use SqlMapClient method like que

Problem exposing protected setters for iBatis

2008-05-08 Thread Kezerashvili, Denis
Here is the problem that I have: I have an Entity class that has a private field ID (the actual name is id), which contains the db id for the entity persisted. I have a public getId() and protected setId() methods. iBATIS sets id when the record is inserted into the db, nobody else should be sett