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?

Uploader: Doura
Date Added: 28 April 2014
File Size: 42.48 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 67736
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.

Stack Overflow works oc with JavaScript enabled. It only gets you part way there. I wonder if there are any issues that we may encounter in the JDBC Drivers perspective while upgrading. For one of our projects we were using the JDBC driver – classes Our web application uses Servlets and JSPs we do not use appletswhich are housed in a Difderence engine.


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.

Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. I made it multi-user, just to show — just to prove for once and for all that using statements is a bad bad idea. It will require the installation of the Oracle8 client on the machine with the tomcat engine. Is that still true?

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.

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

What does one conclude from this?