best Oracle Driver

bimki · **Posted:** Fri May 13, 2005 1:23 pm

Hi,

my application sends plenty queries per second.

Whitch Oracle driver do You recommend?

I tried to use oracle.jdbc.driver.OracleDriver and com.ddtek.jdbc.oracle.OracleDriver but performance was much worse than with mySQL database for the same application!!!

my Oracle version : 9.2.0.1, driver was the newst from Oracle website.

regards,

duffymo · **Joined:** Wed Dec 17, 2003 10:13 am **Posts:** 33

Maybe you didn't set up the Oracle database properly. Indexes, maintaining referential integrity, etc. can have a big impact on performance.

No offence, but I'd doubt myself before I suspected the JDBC driver. Do you know Oracle as well as you do MySQL? My experience is that Oracle tends to be more complex. Are you using InnoDB tables in MySQL to maintain referential integrity?

The JDBC driver from Oracle is as good as any. I'd Google for info re: performance.

%
[/quote]

bimki · **Posted:** Fri May 13, 2005 4:28 pm

it was _standard_ configuration of mySQL and _standart_ (general purpose) for Oracle

In simple experiment - whitch contains about 10 sql queries, Oracle is much better

but when Hibernate generates more than 1000 sql queries (whitch is normal for object manipulation) Oracle becomes poor results compared to mySQL and MS sql server :(

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

increase oracle sql area.it is too small, probably

oracle is better for complex database (many queries), but it have to set correct

regards

rhasselbaum · **Joined:** Thu Oct 07, 2004 4:45 pm **Posts:** 92

I'm also on a hunt for the "best" Oracle driver to use with Hibernate. I use the Oracle 10g driver for JDK 1.4 (ojdbc14.zip) because it's the only one from Oracle that seems to handle large (>4k) LOBs correctly without resorting to a Hibernate UserType. However, as others have pointed out, you need to set "hibernate.jdbc.batch_size" to 0 or LOBs don't work.

Is there a driver out there that works with Oracle 9i, handles LOBs correctly, AND supports a batch size > 0?

bimki · **Posted:** Thu May 26, 2005 5:14 pm

hi,

maybye there is, but probably not for free :(

I leaved Oracle and I now I'm using SQL Server. It looks work better with Hibernate despite it is Microsoft product ;)

Regards,

rhasselbaum · **Joined:** Thu Oct 07, 2004 4:45 pm **Posts:** 92

A commercial driver is fine if it does the job. Surely there must be some driver out there that meets this criteria.

christian · **Posted:** Thu May 26, 2005 5:57 pm

datadirect