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. But anyway we are drifting away from your earlier point of how the connections are managed. Basic difference between thin and thick client. Originally posted by Sunil Aggarwal: Oracle’s connection pooling software October 11, – 1: I’ve just modified the perftest.
|Date Added:||20 May 2005|
|File Size:||14.28 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Which driver should I use?
[Oracle-l] Again – JDBC thin vs. thick – Grokbase
I see a lot of “thin is faster” or “thick is faster”, but no data to support the conclusion or a description of how the testing was conducted. If we relocate a database, then he just has to create a new connection pool and switch the applications.
FYI, I’m on the thick side, though loosing weight rapidly, 11kg in 9 weeks From http: Is that official enough? Anyway, I had a lot of great responses and questions. Sign up using Facebook.
Thick vs thin client – 11g R2 Java thin client vs. I recently gave a presentation to the development group on why you should use PreparedStatement instead of Statement.
It looks like you are using an AD Blocker!
Oracle-L: Differences between Oracle JDBC thin and thick drivers
The copy here in our group seems to have taken legs, so recalling from memory, I recall that under some circumstances the thin is faster and other times the thick is faster. Wednesday, September 15, 8: This is a type-4 driver where Java language call will be converted to network calls and will be sent to the Oracle DataBase Server. Sep 15, ’04 at 7: Help is on the way February 16, – 4: I also believe that’s the case, but I would need an official source to prove it, and I can’t seem to find any.
BTW I work for Oracle and my group is responsible for the development of these drivers. OCI vs Thin October 12, – 1: Also a manageability difference January 02, – 4: I just got some more feedback.
We presently use the thin driver to connect to an Oracle8i 8. As you can see, I’m not an expert at this, I’m just a developper that is super-annoyed thkck having to keep the Oracle client and drivers in sync all the time. I own a book named “Expert One On One Oracle” “Chapter 3 Locking and concurrency” The author goes into the issues about locking and concurency in great details, and I understood that chapter.
I myself would much prefer to use the thin client.
OK, here some unintended jdbf email exchange I had with Dennis about the topic. Tom, Thanks Again, you are simply the best I would figure my “Parse” and “Execute” counts to be the same as the PreparedStatement version.
If you are writing an applet, you must use the Thin driver.
January 04, – 6: They say the last time they used that version they got a flat tire, so they are in the process of re-inventing the wheel. Press any key to continue. DominicDougherty Apr 15th, Tom, I’m installing a tnick product that runs on a Tomcat application server, connected to a database. If anyone has any info on this that they can share, it would be greatly appreciated.