If you are going to choice hibernate, CMP, JDBC, JDO, TopLink and so on, I
suggest that you look at the springframework. This framework gives you
support to all this options besides transaction control with AOP.
This framework suggests you to developer with interfaces and you can replace
the persitence layer easyly.
Good Luck


>From: emylonas <emylonas@(protected)>
>Reply-To: An interest list for Sun Java Center J2EE Pattern Catalog
><J2EEPATTERNS-INTEREST@(protected)>
>To: J2EEPATTERNS-INTEREST@(protected)
>Subject: Re: Persistence with JDBC ???
>Date: Tue, 11 Oct 2005 08:49:51 -0300
>
>If you don't want to use a free software for persistence, use TopLink. It's
>a commercial Persistence Framework owned by Oracle, which has builtin
>functionalities in JDeveloper. It's excellent!!!
>
>Good luck
>
>
>Em (18:50:52), An interest list for Sun Java Center J2EE Pattern Catalog
>escreveu:
>
>
> >Hi everybody, I'm migrating a legacy system from pl/sql to J2EE.
> >Initially i had to use an implementation of JDO, but after trying to
> >translate lots of query without getting a good performance and, in many
> >cases, being almost impossible to translate them, we are planning to use
> >other persistence system. Some people suggested me to use JDBC and call
> >directly stored functions or execute statements.
> >I've tried it and it performs much faster than with JDO. I think it's
> >normal, since now we are avoiding to create the objects and simplifying
> >considerably the number of queries (JDO generates lots).
> >
> >Although JDBC is faster, I know that there are some issues I should
> >consider before adopting it. The one that more worries me is the cache
> >management. The system manages lots of data and users, and same queries
> >are invoked once and other.
> >
> >Do you think that JDBC is a good solution? Is that enough for a big
> >web-based system?
> >
> >I know that I could use Hibernate but initially the chiefs didn't want
> >to use free software for persistence, since is a very critical system
> >and they always want to have some comercial ''support''..
> >Another thing is that the system is based only in servlets (with Struts)
> >and doesn't use any kind of EJB.
> >
> >Thanks in advance!!
> >
> >====================================================================
> >Companion Site: http://www.corej2eepatterns.com
> >J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
> >List Archive:
> >http://archives.java.sun.com/archives/j2eepatterns-interest.html
> >Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
> >listserv@(protected)
> >
> >----------
>
>====================================================================
>Companion Site: http://www.corej2eepatterns.com
>J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
>List Archive:
>http://archives.java.sun.com/archives/j2eepatterns-interest.html
>Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
>listserv@(protected)

====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)