Craig Ringer wrote
> I'm fairly new to Java (sorry!) and struggling with the=20
> database access=20
> area. My PostgreSQL database is fairy complex and significant=20
> parts of=20
> its user interface are through stored procedures etc. I've=20
> been looking=20
> into Hibernate / Hibernate EntityManager and other EJB3-compatible=20
> tools, but they all seem to be oriented toward=20
> database-independence and=20
> using the DB as a dumb storage engine. They even implement their own=20
> outer joins (!) and other core DB functionality. Currently=20
> I'm trying to=20
> figure out why a "SELECT c FROM customer c;" (Hibernate-style) is=20
> introducing a WHERE clause for on the customer's bank_id when=20
> executed=20
> ... so I'm not impressed so far.
A lot of ORMs are designed for ease of persisting objects, not ease of
real=
ising databases.
Though I haven't used it, so can't guess whether it would be a good match
f=
or your needs or not... one tool I think may make the database to object
ma=
pping easier is ActiveObjects.
> However, I've also looked at raw JDBC code, and it seems to be very=20
> verbose with a lot of manual data conversion and little language=20
> integration.
I use and quite like Spring-JDBC. Among other things, it makes JDBC use
muc=
h less verbose.
In Java, a lot of projects use some form of data-binding between their GUI
=
and Objects, then an ORM to persist those Objects to a DB.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement,
custo=
mer focus, and courage. This email with any attachments is confidential
and=
may be subject to legal privilege. If it is not intended for you please
a=
dvise by reply immediately, destroy it and do not copy, disclose or use it
=
in any way.
__________________________________________________________________
This email has been scanned by the DMZGlobal Business Quality
Electronic Messaging Suite.
Please see http://www.dmzglobal.com/dmzmessaging.htm
for details.
__________________________________________________________________
-
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
|
