Re: Oracle8i ... Oracle9i, OCI? Thin? PLEASE!!!!!

john.ck_at_spray.se (John) writes:

> I ve found the oracle9i jdbc drivers, (thin and oci).
>
> But I still wonder the answers for questions
> > 1. I wonder what solutions ORACLE recommend for a case like this???

Don't know.

> > 2. Is it better to use OCI or Thin drivers (difference?)?

Sometimes you don't have the choice between an OCI and a thin driver. If you want your application to run on all kind of platforms you need the thin driver. If you have control over the platform, you can use the OCI driver.
To use the OCI driver, you need to install an Oracle client and configure Net8. So the OCI driver is suitable to run in the middle tier.

> > 3. which is performance IMPROVED?

I would tend to say that the OCI driver is faster since it has native C calls to the Net8 stack.
Though I have occurences where the thin driver is faster.

-- 
Leave it all to us, you'll never know what hit you.
			Monty Python - The Meaning of Life