Oracle Driver to Optimize?

[Deepan Devadasan]

Hi...

We all are used to using the Classes/Interfaces in java.sql.* package for DB Related matters?

I was also able to find some Classes in the Oracle JDBC Driver, sometimes with analogy to the ones found in the above...?

Can we achieve any optimizations by using the API provided in the JDBC driver itself..

Please also advice me whether it is in any way specific to storing and querying with Unicode Strings?

Thanks in advance

[Mark Spritzler]

I'll just say this. The Oracle JDBC driver does not completely implement the JDBC Spec. There are third party Oracle Drivers that are complete and in some ways better. If you use the Oracle specific classes you are tying yourself to the Oracle JDBC Driver and it would require more work for you if you change databases or its drivers.

Mark

[Deepan Devadasan]

Hi Mark..

I buy that idea..

So what is the best idea to grab the drivers, if not from Oracle itself for its own DBs


Thanks

[Mark Spritzler]

Originally posted by Theepan Thevathasan:
Hi Mark..

I buy that idea..

So what is the best idea to grab the drivers, if not from Oracle itself for its own DBs


Thanks

Just because a vendor themselves have a driver doesn't necessarily make it the best. And Oracle does a lot of things that I would call wrong. Like when you install the Oracle client, it puts its stuff up front in the path, which can really cause problems because they use an older JRE, and if you have a newer JRE on your machine, nothing on your machine will really use the newer JRE.

I suggest doing a Google search for other JDBC drivers for Oracle.

Mark

[Deepan Devadasan]

mark,

resourceful...

Thanks for the thoughts, you justified....