More than likely the maxconnections xml node isn't being used at the driver level. Is there a jdbc string parameter that can control this? I'm not familiar with oracle enough. If there is a param, we can update the admin to build in the max connection param. On Mar 15, 2012 6:56 PM, "chris schiffman" <[email protected]> wrote:
> 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 > -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
