Since there are lot's of mentioned frameworks ... Spring DAO is also nice to use. I like Spring's JDBCTemplate. Easy to use with SQL and no aditional object-based layer, like Hibernate, is needed.
-Matthias On 4/5/06, Alexandre Poitras <[EMAIL PROTECTED]> wrote: > And EJB3 is heavily inspired of Hibernate. Really I wouldn't go the > JDO way. By the way, JPA is going to be the official persistence > specification. > > On 4/5/06, Jonathan Harley <[EMAIL PROTECTED]> wrote: > > 101questionjsf wrote: > > > Currently, i'm using JDBC statements, and using Oracle db. But got a > > > feeling > > > these JDBC statements are going to be Oracle specific... Please help me > > > confirm this is true? > > > > Very likely. Oracle's dialect of SQL is proprietary. > > > > > If using Hibernate, will it tie to Oracle db or it will be regardless of > > > the > > > backend db, it can just run in any db without any modification > > > > No, it won't tie you to Oracle if you use HQL as your query language, as it > > is database-neutral. However, it will tie you to Hibernate! > > > > You might want to look at JDO, which is the current standard for using > > databases (and other kinds of datastore) from Java. There are over a dozen > > implementations of the JDO standard, some commercial and some free like > > JPOX. As it's a standard, it's trivial to switch between products as long > > as you don't use vendor extensions (and as JDO is a mature standard, you > > probably won't need to). If you want to avoid being tied to one > > vendor, standards are always the way to go. > > > > > > Jon > > -- > > ..................................................................... > > Dr Jonathan Harley . > > . Email: [EMAIL PROTECTED] > > Zac Parkplatz Ltd . Office Telephone: 024 7633 1375 > > www.parkplatz.net . Mobile: 079 4116 0423 > > > > > -- > Alexandre Poitras > Québec, Canada > -- Matthias Wessendorf Zülpicher Wall 12, 239 50674 Köln http://www.wessendorf.net mwessendorf-at-gmail-dot-com