JDBC vs Oracle client connection

Dear BO Experts,

I always have used connections based on JDBC driver, but few days I performed some tests with the same connection but using Oracle client.

To be honest, the JDBC connection is not so stable and gives errors from time to time. I can not validate free hand sql queries in report that take more than 30 minutes.

On the other hand, the connection based on Oracle client works perfect…

I was wondering, what is the benefit of using a JDBC connection when it works better with Oracle client?


Victor_BCN :es: (BOB member since 2009-09-15)

If your JDBC driver isnt multithreaded (it likely is to be fair!) then you would possibly see performance gains using native Oracle (or OCI as we used to call it) as thats multithreaded.

Obviously you`d only see that effect where your report sends multiple queries simultaneously (i.e. newer versions of Webi or Crystal).

ABILtd :uk: (BOB member since 2006-02-08)

Thanks ABILtd!

how to know if my JDBC is multithread or not? :crazy_face:

Victor_BCN :es: (BOB member since 2009-09-15)