For 95% of your application, this won't be a problem. It's the 5% that
you will have to take out of the persistance layer and tune that will
be where your optimization of they query will be required.


On Thu, 10 Feb 2005 10:40:52 -0500, Brian McGovern
<[EMAIL PROTECTED]> wrote:
> Don't get me wrong, i wasn't knocking it. But my main concern is app speed 
> difference using stored procs or hibernate.
> 
> -----Original Message-----
> From: Lee Harrington [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 10, 2005 10:10 AM
> To: Struts Users Mailing List
> Subject: Re: Hibernate object relational mapping
> 
> I use hibernate...it's not a "tool for those who don't know sql" -- as
> I've been a database developer for 20+ years.
> 
> It's a tool for those who:
> 1.  don't want to have to write a lot of redundant code just to
> insert, update, delete
> 2. don't want to have to hand code "class.property =
> recordset.getField("fieldName")" out the yin yang
> 3.  don't want to have to hand code different data layers for
> different database systems
> 
> Consider on form submit....
> 
> You could write:
> 
> sqlStr = "insert into mytable (field1, field2.....field15') values (" +
> form.field1 + ",'" +
> form.field2 + "','" +
> .....
> form.field15 + "')"
> 
> and write your own handling of database errors
> 
> or  could write:
> 
> // copy form variable to an instance of your data class
> BeanUtils.copyProperties(metric,dynaForm);
> 
> // Call to "persist" (save) the record
> MetricService.getInstance().makePersistent(metric);
> 
> And there are MANY more reasons to use Hibernate over handcoding your
> own sql.  None of it having to do with "not having to know sql".
> 
> Lee
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 


-- 
Keith Sader
[EMAIL PROTECTED]
http://www.saderfamily.org/roller/page/ksader

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to