DriverManager.getConnection - Performance

DriverManager.getConnection - Performance

Post by SDR Gm » Wed, 30 Jan 2002 02:48:53



Hi all!

Since I have migrated to Java2 the getConnection is very slow which
means approx. 3 to 12 seconds. Under JDK 1.1.8 it only took 200 to 300 ms!

Any idea, why i may do wrong?

Regards,
              Fritz.

 
 
 

DriverManager.getConnection - Performance

Post by Joseph Weinstei » Wed, 30 Jan 2002 03:29:34



Quote:

> Hi all!

> Since I have migrated to Java2 the getConnection is very slow which
> means approx. 3 to 12 seconds. Under JDK 1.1.8 it only took 200 to 300 ms!

> Any idea, why i may do wrong?

> Regards,
>               Fritz.

Look at the JVM source for DriverManager. I'll bet it hasn't changed much at all.
Try instantiating a Driver instance directly, and calling Driver.connect().
This will test the driver without DriverManager in the picture.

Joe Weinstein

 
 
 

1. DriverManager.setLoginTimeout() causes DriverManager.getConnection() to time out

Hi,

after changing the login timeout using DriverManager.setLoginTimeout() I
don't get connections any more. The method
DriverManager.getConnection() blocks for a number of seconds (the timeout
value?) and after that throws a timeout exception.
Without setting the timeout getConnection return almost immediately and
succesfully.

Marek Kruszewski

2. Order Entry Application

3. jdbc DriverManager.getConnection problem

4. DTS Import/export wizard error

5. Question aboutr of JDBC DriverManager.getConnection()

6. Upgrade Fails - Need Fix Q300676 HELP

7. DriverManager.getConnection()

8. format of DriverManager.getConnection URL

9. timeout when calling DriverManager.getConnection()

10. DriverManager.getConnection Synchronized

11. DriverManager.getConnection()

12. DriverManager.getConnection() fails under JDK 1.1.8 but not 1.2