This content has been marked as final. Show 7 replies
Welcome to the forum!
Thanks for posting yor full database version. Since JDBC involves java you should post the full Java version you are using.
I use ojdbc6 drive in RedHat6 in get database connection time about 20 seconds, in Windows xp in about 300 milliseconds, don't know what the problem is, will drive replacement for ojdbc14, Windows xp and RedHat6 in get database connection in the same time, about 300 ms
What does 'will drive replacement for ojdbc14' mean?
That jar file does not support Oracle 11gR2 so you need to upgrade to a jar file that does. You mention ojdbc6 so which jar did you use in Redhat? Which one in XP? What machine is the DB itself on? Is it on the same box you are connecting from?
Here is the official Oracle JDBC page that shows the Oracle DB versions supported for each of the JDBC drivers available and also describes the JDBC jars and what JDK versions they support.
Please note that JDK 1.4 is not supported by the 11 drivers.
DB version:Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit
JDK version: 1.6.0_17
RedHat6, ojdbc6 drive connection time slowly,connection time about 20-50 seconds
windows xp ,ojdbc6 drive connection time very soon,about 200-300 milliseconds
The above RedHat6 connection slow problem,
I will drive replacement for ojdbc14 drive, connection quickly.about 200-300 milliseconds
Why ojdbc6 in redhat6 in get connection time slow, JDK version 1.6, I try to download the latest ojdbc6 get connection time also is very slow.about 20-50 seconds
Thank you for your reply, I'm sorry, I have no problem detailed description to you.
Lasted three machine
1, database machine : RedHat6 system
2, Testing a machine 1 : RedHat6 system
3, Testing a machine 2 : winxp system
Test database connection time
Testing a machine 1: RedHat6 jdk1.6.0 _17 ojdbc6
Testing a machine 2: winxp jdk1.6.0 _17 ojdbc6
String url = "jdbc:oracle:thin:@192.168.1.2:1521:test";
String user = "test";
String pwd = "test";
long s = System.currentTimeMillis();
Connection c = DriverManager.getConnection(url, user, pwd);
long e = System.currentTimeMillis();
1,testing a machine 1: database connection time of 20-50 seconds
2,testing a machine 2: database connection time for 200-300 milliseconds
In the test machine 1, appear for connection time slowly, I try to be ojdbc6 replacement for ojdbc14, connect time change very quickly. About 200-300 milliseconds.
Testing a machine 1: RedHat6 jdk1.6.0 _17 ojdbc14
I also try to update the JDK6U33, the latest ojdbc6, did not solve the problem for connection time very slow.
So I will drive replacement for ojdbc14, only to replace it, get the database connection time to quickly
Don't know why ojdbc6 in redhat6 in get connection time slow reason, can you help me
Edited by: 949716 on 2012-7-30 下午9:49
Edited by: 949716 on 2012-7-30 下午9:54