*
The moose likes JDBC and the fly likes Why Is oracle.jdbc.OracleDriver So Much Slower In 1.5 Than 1.4? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Why Is oracle.jdbc.OracleDriver So Much Slower In 1.5 Than 1.4?" Watch "Why Is oracle.jdbc.OracleDriver So Much Slower In 1.5 Than 1.4?" New topic
Author

Why Is oracle.jdbc.OracleDriver So Much Slower In 1.5 Than 1.4?

Bob Nedwor
hangman
Ranch Hand

Joined: Aug 17, 2005
Posts: 215

My db is Oracle9i Enterprise Edition Release 9.0.1.3.0, and the ojdbc14.jar is in my class path - just like it was when I was using 1.4.

C:\my_javas>java -version
java version "1.5.0_05"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05)
Java HotSpot(TM) Client VM (build 1.5.0_05-b05, mixed mode)

C:\my_javas>

Thanks for any hints as to how I can get back the same performance I had with 1.4, because it is taking 3-5 times longer with 1.5 .


Bob N
SCJP - 1.4
SCJD - (B&S) Used 1.5 And It Runs On Solaris10
SCWCD - Thanks to HFSJ!!
Bob Nedwor
hangman
Ranch Hand

Joined: Aug 17, 2005
Posts: 215

Never mind! I found the answer!

It seems there is a default proxy server in the 1.5 jre that needs to be disabled

Please see
http://forum.java.sun.com/thread.jspa?messageID=3491747
which partially reads:

**************************
The resolution of this is to turn off the new proxy server feature in JRE1.5. You do this by informing the jre that you do not have a default proxy server. This is done with the following lines of code placed somewhere in your application:

import java.net.ProxySelector;
.
.
ProxySelector.setDefault(null);

With this, the NetBIOS name queries do not emanate, and we revert back to the 1.4 behavior.

Mauro Zallocco.
**************************

Thanks so much to Mauro!
[ January 28, 2006: Message edited by: Bob Nedwor ]
 
wood burning stoves
 
subject: Why Is oracle.jdbc.OracleDriver So Much Slower In 1.5 Than 1.4?