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?
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).