Re: ibatis and streams

2005-02-26 Thread Admin
I somtimes try something in JDBC in test, then re:do in iBatis. This may be one of those cases. .V Nathan Coast wrote: Hi, Does ibatis support blob types, specifically to stream blobs in / out of the database? I notice something about blobs are mentioned for the 2.0.9 release. Are there any

Re: java.util.HashMap as resultClass

2005-02-26 Thread Admin
It's not that much space wasted. .V Pascal DeMilly wrote: Hi, I would like to retrieve a Map with whose key is the 1st column of my query and the value is the 2nd column. For example right now I do: select id=getItemNameMap resultClass=java.util.HashMap select SKU, Description from Items

oops

2005-02-26 Thread Admin
I posted to old msgs...oops. .V

iBATIS vs Hibernate

2005-02-26 Thread Tim Christopher
Hi, Can anyone point me in the right direction of a site that compares iBATIS to similar products, ie. Hibernate. Cheers, Tim Christopher Ps. Is it possible to specifiy a flush interval in a unit other than hours? Also is there an upper limit for the time?

Is this overkill?

2005-02-26 Thread Tim Christopher
Hi, What would you suggest I do if I needed to print a list of the days of the week that the shop is open, ie. Monday, Wednesday, Saturday. This list is subject to change by the user (admin) via an online form and so the details will be stored in a database. To create a WeekDay object and a

Re: iBATIS vs Hibernate

2005-02-26 Thread Paul Barry
I don't know of a site with a detailed comparision, and if you find one, let me know. But I can tell you this difference boils down to this; iBATIS maps Java Objects to the results of SQL Queries, whereas Hibernate maps Java Objects directly to database tables, traditional Object-Relational

Re: Is this overkill?

2005-02-26 Thread Paul Barry
Using the object isn't any more effort than using a String and it also provides more flexibility. If you find that your WeekDay object ends up with more properties later, no need to modify the service interface. public class WeekDay { private String name; //Getters/Setters... } public

Re: websphere ejb transaction rollback and SQL Stored Procedure

2005-02-26 Thread Clinton Begin
Tim, Although I can't pinpoint the exact problem, I would suggest you NOT use iBATIS DAO in your particular case. It's simply too many transaction managers. All you really need is a factory for your DAOs. Your transactions are controlled by the container and the SQL and JDBC is handled by

Re: Modeling 1:N where N=0

2005-02-26 Thread Clinton Begin
iBATIS will populate child objects if there is ANY non-null data mapped to the child in the result map. If you don't want iBATIS to create the child, make sure it's mapped to null data...there's really no reason why you shouldn't be able to achieve this. Cheers, Clinton On Fri, 25 Feb 2005

Re: iBATIS vs Hibernate

2005-02-26 Thread Larry Meadors
On a related note: I am in the process of refactoring an application where I work that used Hibernate. One of the screens that was timing out after over 10 minutes is now coming up in under one minute. In my experience, the performance of Hibernate (especially when dealing with large datasets) is