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
