caching and obect refs

just out of interest, how do people handle the sharing of object refs from an ibatis cache? If I cache a reference to a Product instance and a second user obtains that reference from the cache, the cache will effectively be tainted by any transient modification that user makes to the instance. i.e

Re: Having two N plus 1 groups

Larry Meadors wrote: I don't think you'll be able to accomplish that without using either 2 queries or a rowhandler. RowHandlers are really simple to write (1 method in the interface), and then you get all the data in one query, and can do pretty much anything you want with it. Larry Ok, that

RE: Ibatis caching Empty ResultSet

Thanks, Larry. That might be all we need to work around what we've done. That's a great help, thanks! I'll dig through version control myself. We've also noticed a very Sybase-specific (but unrelated) problem that can be worked around, and I'll be sure to add it to the wiki. (Since I noticed t

Re: Having two N plus 1 groups

Thanks for the solution. Using two query did it and I don't have to worry about N+1 problem here as we need to load only one reportGroup (getReportGroupById) but not their collection. Will try rowhandler later. Thanks once again for quick response. Larry Meadors wrote: > > I don't think you'l

Re: Ibatis caching Empty ResultSet

Yes, that behavior did change, but I'm not positive when...it's been a while. Larry On Thu, Jul 10, 2008 at 4:34 PM, Shannon, Bryan <[EMAIL PROTECTED]> wrote: > Can someone please confirm whether or not iBatis used to cache the empty > resultset in previous versions? > > We have a similar situat

RE: Using flat files instead of a relational database

We've used the HXTT drivers for clipper (dbase) files in the past... You just use that as your Datasource. The difference the usage is the "simulated" sql that the driver provides to you. There was nothing different in the configuration; just specify the correct URL and the correct driver name an

RE: Ibatis caching Empty ResultSet

Can someone please confirm whether or not iBatis used to cache the empty resultset in previous versions? We have a similar situation to Serge, in his slightly older thread, in which our code relied on iBatis not returning the null result for the second SELECT. (ie NOT caching an empty result) Upo

n+1...how to know if doing correctly?

Hi, Probably a naive question, though is there a way to verify that when we write our queries and execute them, we are actually writing them properly and not following into the n+1 problem? Basically what can we look at to see that it is having the n+1 problem and then that it isn't? Thanks, Josh

Re: Finding the next primary key value.

Look at the tag. Larry On Thu, Jul 10, 2008 at 8:00 AM, kiran vuppla <[EMAIL PROTECTED]> wrote: > > > I would like to insert data in to database using IBatis but I am > not sure what value I need to use for "primary key" column as I am not what > is the next primary key value. Can you some on

Finding the next primary key value.

   I would like to insert data in to database using IBatis but I am not sure what value I need to use for "primary key" column as I am not what is the next primary key value. Can you some one let me know how to find the nextPrimaryKey Value in a table? Here sessionID is primarykey for which I n

Re: Having two N plus 1 groups

[EMAIL PROTECTED] On 7/10/08, Larry Meadors <[EMAIL PROTECTED]> wrote: > > I don't think you'll be able to accomplish that without using either 2 > queries or a rowhandler. > > RowHandlers are really simple to write (1 method in the interface), > and then you get all the data in one query, and can

Re: Having two N plus 1 groups

*unsubscribe me, please!* ** *Thx!* On 7/10/08, Larry Meadors <[EMAIL PROTECTED]> wrote: > > I don't think you'll be able to accomplish that without using either 2 > queries or a rowhandler. > > RowHandlers are really simple to write (1 method in the interface), > and then you get all the data

Re: Having two N plus 1 groups

I don't think you'll be able to accomplish that without using either 2 queries or a rowhandler. RowHandlers are really simple to write (1 method in the interface), and then you get all the data in one query, and can do pretty much anything you want with it. Larry On Thu, Jul 10, 2008 at 5:36 AM

Re: Having two N plus 1 groups

I am having similar problems but can't find any solution. Here is my case. report_group can have many report_types and many reports. No relation exists for report_type and reports. Here is the result of a query to get a report_group. report_group_id report_id report_type_id 100

Using flat files instead of a relational database

Hello, I know when you're not using a relational databases, you can use JDBC drivers for flat files (CSV). Is there someone who already do that and can give me an exemple ? What is different in the config files excluding the URL and the class of the driver Many thanks -- View this message in c