[Proxool-developer] Long time of getting connections

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Good day,
=20
I'm using Proxool and I 've investigated the problem of long time of =
getting connection
=20
Code:
                long s1=3DSystem.currentTimeMillis();
                connection =3D =
DriverManager.getConnection("oracle_logging");
                long s2=3DSystem.currentTimeMillis();
                log.info("Time of getting connection:"+(s2-s1));
=20
=20
In properties I configured 25 of max connections and 12 of min =
connections:
=20
<proxool> =20
  <alias>oracle_logging</alias>  =20
  =
<driver-url>jdbc:oracle:thin:@//172.18.64.30:1521/SIEBEL78</driver-url>  =

  <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> =20
  <driver-properties>    =20
  <property name=3D"user" value=3D"IVRUS"/>   =20
  <property name=3D"password" value=3D"IVRUS"/>   =20
  </driver-properties>   =20
  <prototype-count>12</prototype-count>
  <minimum-connection-count>12</minimum-connection-count>
  <maximum-connection-count>25</maximum-connection-count>   =20
   <statistics>1m,15m,1d</statistics> =20
   <statistics-log-level>INFO</statistics-log-level>
  <house-keeping-test-sql>select 1</house-keeping-test-sql> =20
<house-keeping-sleep-time>300</house-keeping-sleep-time>
  </proxool>
=20
=20
In logs I have sometimes 19 seconds of executing method getConnection.
=20
Main Question IS : How I can avoid this trouble???
=20
log file:
=20
14 =CC=C9=D3=D4 2006 12:51:00,401 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:79
14 =CC=C9=D3=D4 2006 12:51:01,323 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:51:02,338 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:51:02,338 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:51:09,791 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:51:10,807 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:51:16,698 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:51:18,214 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:16
14 =CC=C9=D3=D4 2006 12:51:55,324 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:02,465 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:03,746 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:05,012 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:32
14 =CC=C9=D3=D4 2006 12:52:08,496 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:30,762 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:15625
14 =CC=C9=D3=D4 2006 12:52:30,809 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:14672
14 =CC=C9=D3=D4 2006 12:52:30,809 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:13657
14 =CC=C9=D3=D4 2006 12:52:30,840 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:13688
14 =CC=C9=D3=D4 2006 12:52:30,840 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:7281
14 =CC=C9=D3=D4 2006 12:52:30,840 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:6250
14 =CC=C9=D3=D4 2006 12:52:30,872 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:5688
14 =CC=C9=D3=D4 2006 12:52:30,872 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:4672
14 =CC=C9=D3=D4 2006 12:52:30,872 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:4563
14 =CC=C9=D3=D4 2006 12:52:30,872 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:3547
14 =CC=C9=D3=D4 2006 12:52:30,887 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:3453
14 =CC=C9=D3=D4 2006 12:52:30,887 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:3453
14 =CC=C9=D3=D4 2006 12:52:30,887 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:1125
14 =CC=C9=D3=D4 2006 12:52:40,872 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:41,887 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:45,325 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:48,325 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:49,028 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:49,513 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:50,622 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:31
14 =CC=C9=D3=D4 2006 12:52:50,622 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:31
14 =CC=C9=D3=D4 2006 12:52:50,653 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:47
14 =CC=C9=D3=D4 2006 12:52:52,247 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:52,981 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:56,607 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:52:59,388 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:53:00,607 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 12:53:21,857 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:19266
14 =CC=C9=D3=D4 2006 12:53:21,904 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:17469
14 =CC=C9=D3=D4 2006 12:53:21,904 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:17469
14 =CC=C9=D3=D4 2006 12:53:21,935 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:16016
14 =CC=C9=D3=D4 2006 12:53:21,935 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:14484
14 =CC=C9=D3=D4 2006 13:02:41,074 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:359
14 =CC=C9=D3=D4 2006 13:02:43,871 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:2141
14 =CC=C9=D3=D4 2006 13:02:43,871 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:1125
14 =CC=C9=D3=D4 2006 13:02:43,871 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:1125
14 =CC=C9=D3=D4 2006 13:09:01,552 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 13:09:02,552 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 13:09:03,583 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 13:09:29,131 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:18891
14 =CC=C9=D3=D4 2006 13:14:40,764 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 13:14:41,779 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 13:14:42,779 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:0
14 =CC=C9=D3=D4 2006 13:14:47,436 [INFO ] com.incom.proxool.DBBroker =
{DBLogBroker_.java:51} - Time of getting connection:16

[Proxool-developer] Long time of getting connections

UNMAINTAINED!

[Proxool-developer] Long time of getting connections