M:M question

2005-05-22 Thread Sergey Livanov
Could you advise as to how to better solve the problem. There is th table M:M with the following structure CLASSFK number , PROPERTY FK number , QUANTITY number . In my application I define PROPERTY & QUANTITY for the CLASS class (with the help of checkbox ) upon which I need t

Re: Blob

2005-05-22 Thread Brandon Goodin
umm... how dumb do you have to be to do something like that? uurmm... oh yeah... i did that too! Brandon On 5/22/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > One almost unrelated thing on this (that I have screwed up before) is > that you may want to leave out the blob unless you really, really

Re: Blob

2005-05-22 Thread Larry Meadors
One almost unrelated thing on this (that I have screwed up before) is that you may want to leave out the blob unless you really, really need it. :-) Imagine 10-20 users in a web app loading up these lists...and all of those blobs getting suffed into memory. ;-) Larry On 5/22/05, Lieven De Keyze

Re: Blob

2005-05-22 Thread Brandon Goodin
This should help: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F Brandon On 5/22/05, Lieven De Keyzer <[EMAIL PROTECTED]> wrote: > I want to retrieve the values from a table where 1 column is of type Blob. > My Bean to stor

Blob

2005-05-22 Thread Lieven De Keyzer
I want to retrieve the values from a table where 1 column is of type Blob. My Bean to store these values has a field of type java.sql.Blob and the appropriate getters and setters. My resultmap looks like this: When my webapplication actually needs this data, I get

Re: [New Feature] SQL Map Interface Binding -for your review

2005-05-22 Thread Clinton Begin
Thanks for asking that question. We have to be VERY clear.  These are NOT DAOs!  Nor are they a replacement for DAOs. DAOs are coarse grained classes.  Mappers are more fine grained. You're right, you would have another set of interfaces, and to some people this may be too many.  I agree. In a

Re: Cache entry invalidation on updates

2005-05-22 Thread Brandon Goodin
The iBatis caching key is based on the SQL query that is sent to the database. The full results are cached under that key in the particular specified CacheModel. It does not retain the individual object dentity (OID) of all the individual objects returned in a query. This means that if you have an

Cache entry invalidation on updates

2005-05-22 Thread Oscar Picasso
Is there a way to invalidate a cache entry on update? Let say I have the following select using a cache model (result class = User): select id, username, password from users where useraname = #username#; and the following update (parameter class = User): update users set password = #password# w

Re: [New Feature] SQL Map Interface Binding -for your review

2005-05-22 Thread Aitor Imaz
So if I understand correctly, the mapper class will select the appropriate interface by looking at the statement name? It could by a nice addition, although I think it might have the risk of requiring too many interface files. Also, what would happen with the current SqlMap Dao templates? Ait

[New Feature] SQL Map Interface Binding -for your review

2005-05-22 Thread Clinton Begin
The dev list has already seen this.  I just want to make sure anyone who doesn't subscribe to the dev list gets a chance to provide some feedback... - Although quite simple, there are some tradeoffs with the typical SqlMapClient methods like:     Document doc = (Do