Hello,
I'm having an issue with "maxconnections" in openbd with oracle. My
config:
<datasource name="my_db">
<displayname>my_db</displayname>
<password>E5SRlQSWyeIhw==</password>
<connectionretries>0</connectionretries>
<sqldelete>false</sqldelete>
<sqlupdate>false</sqlupdate>
<username>ME</username>
<drivername>oracle.jdbc.OracleDriver</drivername>
<sqlstoredprocedures>true</sqlstoredprocedures>
<perrequestconnections>false</perrequestconnections>
<sqlinsert>false</sqlinsert>
<sqlselect>false</sqlselect>
<connectiontimeout>5</connectiontimeout>
<port>1521</port>
<server>myoraclehost</server>
<databasename>orcl</databasename>
<description></description>
<connectstring></connectstring>
<initstring></initstring>
<logintimeout>5</logintimeout>
<hoststring>jdbc:oracle:thin:@myoraclehost:1521:orcl</
hoststring>
<maxconnections>5</maxconnections>
<name>my_db</name>
</datasource>
When I load test my application, there seems to be no end to the
number of connections the app tries to make. Netstat shows the 5
limited connections established, then shows 100's of TIME_WAIT
connections to the database (and keeps going as requests come in).
Does the "maxconnections" parameter not work correctly? or am i
reading/doing something wrong? **note, the 5 established connections
are running a process that takes a long time...
tcp 0 0 ::ffff:127.0.0.1:42943 ::ffff:127.0.0.2:1521
ESTABLISHED
tcp 0 487 ::ffff:127.0.0.1:43005 ::ffff:127.0.0.2:1521
ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:43006 ::ffff:127.0.0.2:1521
ESTABLISHED
tcp 0 17 ::ffff:127.0.0.1:43007 ::ffff:127.0.0.2:1521
ESTABLISHED
tcp 0 17 ::ffff:127.0.0.1:43009 ::ffff:127.0.0.2:1521
ESTABLISHED
tcp 0 0 ::ffff:127.0.0.1:43023 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43022 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43021 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43020 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43019 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43018 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43017 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43016 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43015 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43014 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43013 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43012 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43011 ::ffff:127.0.0.2:1521
TIME_WAIT
tcp 0 0 ::ffff:127.0.0.1:43010 ::ffff:127.0.0.2:1521
TIME_WAIT
....
I was able to restrict sessions in oracle, which is good. Just
wondering what i can do on the application end.
thanks!
-chris
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
