It would be good to consolidate the “debunking” into a single site. You know, this bothered me SO much January 02, – 8: Contact me directly if you need help with this. Just in case anyone doesn’t get the point yet. What do you recommend for a average OLTP system, is it still ‘old rule’ use oci as it’s native or is thin so much improved now?
|Date Added:||28 April 2014|
|File Size:||42.48 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Please be advised that internal and outsourcing budgets are separate, so I am afraid you are not allowed to use your gas money to take a taxi or use public transportation in the meantime. It should not increase maintenance issues at all instead differencs upgrading the thin jdbc drivers you would upgrade the Oracle8 client software which has the jdbc drivers in it.
Difference between thin driver and oci driver (JDBC and Relational Databases forum at Coderanch)
I borrowed a lot of information for my presentation from what I learned here and from your books. It’s probably also worth mentioning that because the thin driver doesn’t use Net8, you can’t do any of the things you would normally be able to do by setting a sqlnet.
LordOfThePigs Yes you can use tnsnames. Your Attention please Mr. I’ve modified the unix script to work with windows. Post as a guest Name. Thus, it is only an option on platforms that have native Oracle drivers available and it is differennce a “pure” Java implementation. Just in case anyone doesn’t get the point yet. Jean de Lavarene 1, 1 9 Thiin provides four types of drivers for their database, but I’ll only enumerate the two you asked about.
Java Programming with Oracle JDBC by Donald Bales
Oracle recommends to use the JDBC thin driver which is what most customers use. For a moment keep aside shared pool, hard differejce and soft parse and talk about PreparedStatement and Statement as they are the only way to execute statements from java.
tyin BTW I work for Oracle and my group is responsible for the development of these drivers. Sounds good to me: We presently use the thin driver to connect to an Oracle8i 8.
The implicit cursor myth The prepared statement myth Ocj hit-ration myth The separate index and table myth. Could please share some more info on OCI. Here is my modified java code. Oracle9i Enterprise Edition Release 9. Thanks in advance, Nic. February 15, – 3: Dev Gym Classes, workouts and quizzes on Oracle Database technologies. We had thin driver with 9i and had perfomance problems during high load on system, then we switched to oci – and everything was fine.
What does one conclude from this?