Re: Connection Pooling/JDBC Connections

[Thorbjørn Ravn Andersen <ravn@xxxxxxxxxx>]

James Perkins skrev:
> Thanks Thorbjørn,
> I have heard wonderful things about Hibernate, just haven't sat down and
> actually spent time to start digging into the details of it. I think I will
> soon though.
>
>   
You're welcome.

I just thought of two different scenarios.  One where you just need to 
load information from a database and then use it in an ad-hoc fashion, 
and one where you need to update data and push it back to the database.

The first case doesn't require much, and you may find that the Google 
persist project is just right.

The second I have found that the best bet these days are to use the new 
JPA standard, which have several implementations, one being with 
Hibernate as the engine.  This allows you to create and modify numerous 
Java beans which is easily persisted and which the engine knows how to 
optimize so that the actual SQL sent is as efficient as handcrafting them.