Re: mySQL

From: PerfectDayToChaseTornados (pdtct_at_emailaddress.invalid)
Date: 01/19/05


Date: Wed, 19 Jan 2005 19:52:18 GMT


"Frances Del Rio" <fdr58@yahoo.com> wrote in message
news:357fatF4ii89tU1@individual.net...
|
|
| PerfectDayToChaseTornados wrote:
|
| > "Frances Del Rio" <fdr58@yahoo.com> wrote in message
| > news:352tn7F4hshg7U1@individual.net...
| > | klynn47@comcast.net wrote:
|
| oh man.. is this an API??? what's ORM? I can't believe how complicated
| this db thing is turning out to be.. is this "hibernate" better than
| using jdbc? or is this a query language?
|
| thanks again.. Frances

Hi Frances,

An ORM is an Object Relational Mapping tool or framework. Basically it lets
you map Java objects to relational databases (& usually uses JDBC & sql
under the covers). Yes it has an API, it does all the stuff you would end up
doing manually & saves you from re-inventing the wheel. A good ORM tool will
also do it more efficiently than you could, unless you are a real DB expert.
The people that write these things are usually extremely clever people with
very in depth database knowledge, much more than us mere mortals :-)

In Hibernate, for example you can create a class & provide a simple XML file
to map this class to your database table(s)& columns (it can even create the
db tables for you from the xml & even the classes if you want it to - it is
very versatile). You then call a factory class to lookup or persist your
objects for you & you do not need to write any sql. It is a really good idea
to have a reasonable understanding of how databases work though when using
these tools. Hibernate is great & it is free & there is a really good forum
on the site, where people are very helpful. The authors of Hibernate have
also written an excellent book "Hibernate in Action" which can take you from
being a newbie, to being fairly skilled. It also teaches quite a lot about
databases & sql on the way. I wouldn't jump straight into using it, you'd be
better to learn some sql & database stuff first. But then try it out, you'd
be amazed how much easier, cleaner & more efficient it makes your code :-)

-- 
-P
"Programs that are hard to read are hard to modify.
  Programs that have duplicated logic are hard to modify.
  Programs with complex conditional logic are hard to modify"
( Kent Beck)


Relevant Pages

  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)
  • Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??
    ... I even had one tell me "SQL injection? ... about databases, server management, mail, or anything. ... I have a ghostwriter who keeps me active on the mailing lists. ...
    (php.general)
  • DataArchitect Version 3.5 Now On HP-UX
    ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. ... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects ...
    (comp.sys.hp.mpe)