aspose file tools*
The moose likes JDBC and the fly likes Large Data Objects Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Large Data Objects" Watch "Large Data Objects" New topic
Author

Large Data Objects

vaagesh Chnadra
Greenhorn

Joined: Jan 06, 2010
Posts: 6
Hi,

We have requirement to retrieve the large data objects from Data base.
Suggest us which of the framework is better among below three.

1. Hibernate
2.I-Batis
3.JDBC
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Both Hibernate and IBatis use JDBC (as do any ORM).


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
vaagesh Chnadra
Greenhorn

Joined: Jan 06, 2010
Posts: 6
Thanks Paul. Which of these (Hibernate/I-batis) have better performance to fecth the largeer data objects
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

My guess would be the performance of either with relation to large objects would be fairly insignificant when compared with the expense of the database access itself, or in other words I'm not sure it is a meaningful metric to decide between the two. Which suits your needs more? Which one's concepts are you more comfortable with?
Ashutosh Gawande
Greenhorn

Joined: Aug 19, 2009
Posts: 11
I think ORM frame work doesn't make sense to me when we want to just retrive some data, plain JDBC / spring + jdbc should give better performance
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Ashutosh Gawande wrote:I think ORM frame work doesn't make sense to me when we want to just retrive some data, plain JDBC / spring + jdbc should give better performance

Why?
Ashutosh Gawande
Greenhorn

Joined: Aug 19, 2009
Posts: 11
As you will not be going through the extensive lines of code written to parse the data obtained, by hibernate to some plain object.
ORM only make sense if you have mid sized domain model with complex relationships like agressions, associations, lazy loading etc. If the model is simple/small the only thing helpful is you don't have to write dao code and sqls, but thats not so bad when you have smaller domain model.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

If your domain model were very basic then yes I agree, an ORM may be overkill, but not for performance reasons. I'd be very surprised if you saw much more than a small, perhaps even negligible difference between Hibernate and JDBC for loading what I assume to be LOBs or similar data types. The bottleneck in both cases is still the database round trip, not what happens to the data after it has been retrieved.

Of course, if you access this data repeatedly, Hibernate will probably show better performance because it comes with caching by default.

 
Consider Paul's rocket mass heater.
 
subject: Large Data Objects