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
