Re: iBatis and ORM's

2005-11-05 Thread Clinton Begin
Yep, we have a wiki.  It's linked from the homepage ("Wiki" in the sidebar). I've added this to the Feedback and Experiences section. Cheers, ClintonOn 11/5/05, Paul Benedict <[EMAIL PROTECTED]> wrote: Does iBATIS have a free wiki? There should be asection for good and bad testimonials. This is

[VOTE] Discontinue Support for: iBATIS Java 1.x, JDK 1.3 and DTDs at ibatis.com

2005-11-05 Thread Clinton Begin
Hi everyone: == What? == I'm going to raise a vote and recommend to discontinue support for:   * iBATIS 1.x (including 2.0 compat package)   * All JDKs 1.3 and earlier (and therefore old JDBC versions)   * DTDs hosted by iBATIS.com == Why? == I'm basing my recommendations on the following fact

Re: iBatis and ORM's

2005-11-05 Thread Paul Benedict
Does iBATIS have a free wiki? There should be a section for good and bad testimonials. This is one worth keeping. __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

Re: iBatis and ORM's

2005-11-05 Thread Clinton Begin
Fantastic.  Thanks for sharing Adib! I may even forward this on to a few people. Cheers, ClintonOn 11/5/05, Adib Saikali <[EMAIL PROTECTED]> wrote: Here are is a record of my experiences with Hibernate on a recent webproject where I was the team lead and had complete control over choice oftechno

RE: iBatis and ORM's

2005-11-05 Thread Adib Saikali
Here are is a record of my experiences with Hibernate on a recent web project where I was the team lead and had complete control over choice of technology. This message is in the spirit of theory vs. practice. A wise programmer once told me that "Simple things should be simple and hard things sho

Re: Caching (please help)

2005-11-05 Thread Michael Campbell
On 11/5/05, Clinton Begin <[EMAIL PROTECTED]> wrote: > Yes, the cache should work for nested selects. But have you tried just > calling them directly to see if it might be a bug? > > Also, just for fun, try the LRU cache, instead of MEMORY. For more fun, try qualifying the cache name with any n

Re: Caching (please help)

2005-11-05 Thread Clinton Begin
Yes, the cache should work for nested selects.  But have you tried just calling them directly to see if it might be a bug? Also, just for fun, try the LRU cache, instead of MEMORY. Clinton On 11/5/05, Paul Benedict <[EMAIL PROTECTED]> wrote: Clinton,No luck yet.Does caching work inside of a neste

Re: Caching (please help)

2005-11-05 Thread Paul Benedict
Clinton, No luck yet. Does caching work inside of a nested object too? Say I have object A with inner objects B and C. I have the result map for object A call "select" on the queries for B and C. I have 2 caches respectively attached to the queries of B and C. Will those be employed for B and C?

Re: Caching resultMap sub-selects

2005-11-05 Thread Michael Campbell
It's in Jira already. I had (mistakenly) just attached the source as the body of the issue, but Clinton removed it in a later revision (I assume(?) he kept the actual source somewhere). He disagreed as to my placement of the code, which might in fact not BE the "right" place, but it works for me.

Re: parameterMap for Oracle's "select * from Table(f(x))"

2005-11-05 Thread Clinton Begin
What does the rest of the exception say? ClintonOn 11/4/05, Balayn, Anna <[EMAIL PROTECTED]> wrote: Can someone help? I am having a problem executing the following statement with queryWithRowHandler(): rmap" parameter Map="pmap">     select * from TABLE (func(? )) This is wor

Re: Caching (please help)

2005-11-05 Thread Clinton Begin
Unfortunately, in order for it to cache, I believe you need a parameter.  We could consider that a bug, albeit rare.  But try adding a dummy parameter to test it. Cheers, ClintonOn 11/5/05, Paul Benedict <[EMAIL PROTECTED]> wrote: I've spent the last two weeks trying to get thecaching to work, but

Caching (please help)

2005-11-05 Thread Paul Benedict
I've spent the last two weeks trying to get the caching to work, but I can confirm iBATIS is not caching any result I configure it for. Obviously this isn't anyone else's problem but mine, but I really feel hopeless here and don't know what else to do. Here is my cache: Here is my s

Re: iBatis and ORM's

2005-11-05 Thread Alan Chandler
On Saturday 05 Nov 2005 14:51, Clinton Begin wrote: > This is really good discussion. I hope you guys help Kim with the FAQ, and > post your feature requests to JIRA (I think "use iBATIS as a spreadsheet" > is already in there). ;-) Just dumped a simplified example of use of groupBy clause into th

Re: Caching resultMap sub-selects

2005-11-05 Thread Paul Benedict
Michael, Please submit that as a patch :-) It really bugs me too. I consider this a must have feature of iBATIS. Better developer tools encourages greater use of the product. Paul --- Michael Campbell <[EMAIL PROTECTED]> wrote: > On 11/5/05, Paul Benedict <[EMAIL PROTECTED]> > wrote: > > > Whi

Re: Caching resultMap sub-selects

2005-11-05 Thread Michael Campbell
On 11/5/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > While it is not clear, I think it is recommending to > add a cache to the getProductsByCatId method (not the > parent getCategoryResult). Is that correct? I have > many sub-selects and it makes sense to put the cache > there, the only problem

Caching resultMap sub-selects

2005-11-05 Thread Paul Benedict
For this example: The sqlmap guide says: "The only consideration is that if you were to enable caching, then the using the separate select (not the join) solution could result in a cached instance being returned." While it is not clear, I think it is recommending to add a cache to the g

Re: iBatis and ORM's

2005-11-05 Thread Clinton Begin
This is really good discussion.  I hope you guys help Kim with the FAQ, and post your feature requests to JIRA (I think "use iBATIS as a spreadsheet" is already in there).  ;-) Cheers, ClintonOn 11/5/05, Alan Chandler <[EMAIL PROTECTED]> wrote: On Saturday 05 Nov 2005 09:38, Abdullah Kauchali wrot

Re: iBatis and ORM's

2005-11-05 Thread Larry Meadors
Getting kind of philosophical here... On 11/5/05, Alan Chandler <[EMAIL PROTECTED]> wrote: > Wow - thank you very much. I had long been wondering why I was so attracted > to iBatis rather than Hibernate given that the latter is obviously the way > everyone has been going. Its made a light come o

Re: iBatis and ORM's

2005-11-05 Thread netsql
What iBatis lets ME do is create a DAO base class that I can re-use. Eventualy DAO maps to a ... model suchas as TableModel (wahtever else... and TableModel maps to a jTableView. And TableModel is my "disconected row set/data set" that matheces my view requirment). The pooint of OO is to increas

Re: iBatis and ORM's

2005-11-05 Thread Alan Chandler
On Saturday 05 Nov 2005 09:38, Abdullah Kauchali wrote: > Alan Chandler wrote: > >http://home.chandlerfamily.org.uk/archive/26/ibatis-v-hiberbate) > > > In simple terms, Hibernate maps Java Objects to database tables. > iBatis maps Java Objects to SQL statements. > > > Hang on a sec here, don't w

Re: iBatis and ORM's

2005-11-05 Thread Abdullah Kauchali
Alan Chandler wrote: http://home.chandlerfamily.org.uk/archive/26/ibatis-v-hiberbate) In simple terms, Hibernate maps Java Objects to database tables. iBatis maps Java Objects to SQL statements. Hang on a sec here, don't we also map Java Classes to database tables with iBatis? A User cla

Re: iBatis and ORM's

2005-11-05 Thread Abdullah Kauchali
Alan Chandler wrote: Wow - thank you very much. I had long been wondering why I was so attracted to iBatis rather than Hibernate given that the latter is obviously the way everyone has been going. Its made a light come on in my head. Yeah, I like the way Clinton writes about these thin

Re: iBatis and ORM's

2005-11-05 Thread Abdullah Kauchali
Clinton Begin wrote: Try this with Hibernate: int i = (Integer) client.queryForObject ("countUsersInGroup", "MyGroup"); SELECT Count(1) FROM Users WHERE GroupName = #groupName# So, we're saying Hibernate has to receive results from all (including ad hoc) queries to /map/ to Java class

Re: iBatis and ORM's

2005-11-05 Thread Alan Chandler
On Friday 04 Nov 2005 15:17, Clinton Begin wrote: > Quick comparison... > > ORM > > 1) Maps classes to tables, and columns to fields. > 2) Must support Object Identity > 3) Generates SQL > > SQL Mapping > > 1) Maps objects (not necessarily a custom type, or even the same type) to > statements > 2)