Thanks for all the input, i'll try a few things and post results. -chris On Mar 15, 5:06 pm, Alex Skinner <[email protected]> wrote: > You can use the Datasourcecreate() function and then use a normal jdbc > connection string which should give you the control you need, I use this > approach with multi host jdbc setups > > A > > On 16 March 2012 00:00, Peter Farrell <[email protected]> wrote: > > > > > > > > > > > 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 > > -- > Alex Skinner > Managing Director > Pixl8 Interactive > > Tel: +448452600726 > Email: [email protected] > Web: pixl8.co.uk
-- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
