This question is Whilst you are here, check out some content from the AskTom team: Just Great March 07, – 3: You know, this bothered me SO much January 02, – 8: Thanks and Best Regards -Hemal Deshmukh. Here is my modified java code. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.

Uploader: Shaktigore
Date Added: 6 December 2011
File Size: 6.61 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 57711
Price: Free* [*Free Regsitration Required]

Anyway, I had a lot of great responses and questions. 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.

Sign up using Email and Password.

Thanks for being a member of the AskTOM community. As you can see, I’m not an expert at this, I’m just a developper that is super-annoyed at having to keep the Oracle client and drivers in sync all the time. Now we are planing to upgrade to oracle 10g.

Difference Between Thin and OCI drivers | Oracle Community

Or is there a way to get the thin driver to read this file as well. Jean de Lavarene 1, 1 9 The only way to achieve the best performance is to fix the code the use PreparedStatement correctly. What other impact can it have wrt to deployment, performance, maintenance etc. April 11, – Your input on this is highly appreciated. But, then we have to query the database each time. I own a book named “Expert Ditference On One Oracle” “Chapter 3 Locking and concurrency” The author goes into the issues about locking and an in great details, and I understood that chapter.


Is that still true? I made it multi-user, just to show — just to prove for once and for all that using statements is difverence bad bad idea.

Java Programming with Oracle JDBC by Donald Bales

Tofiq 5 13 First, I modified your program to execute the test using 4 different possible scenarios for inserting data. For a moment keep aside shared pool, hard parse and soft parse and talk about PreparedStatement and Statement as they are the only way to execute statements from java.

My DB is 9i Rel2, and classes And the extra clarifications can probably be added to your answer later on. Oracle recommends to use the JDBC thin driver which is what most customers use. This link describes more beetween Programming and comparison to ProC concepts. It’s great when you provide simple tests to debunk misinformation.

Tom, We have a 4 node 11gr1 RAC database supporting a web facing application. I’ve modified the unix script to work with windows. We have to wait for a reply from the Patent Office before getting final approval, so please be patient. Help is on the way Dlfference 16, – 4: Thanks and Best Regards -Hemal Deshmukh.


OCI Versus Thin Drivers – Java Programming with Oracle JDBC [Book]

Hi Tom, I love your response above. Back to OCI vs. Post as a guest Name. Our TNS is configured in the following format and on any given day load balancing seems to work fine. Thank you for the quick response, We will implement instance caging right away. It bftween be good to consolidate the “debunking” into a single site. Thin Driver Performance August 05, –