Sorry to confuse the situation, let me try to clarify. Yes, the root issue is the database connection pooling.
I have an openBD application endpoint waiting for http form posts or gets (ie: https://myserver/action.cfm). When I do load testing on it, via Jblitz or other QA tools, (posting http) - openBD performs great, and the database connections remain low (1-5 connections to oracle). I had a new client integrate, and they are a java development house. So the developer thought it would be great to just open persistent connections with my service. Once he started sending requests to my public endpoint, the oracle connections from openBD to oracle jump beyond the 'maxconnections' parameter set. In fact, each request he makes seems to just initiate a new connection from openBD to oracle. So if he sends 50 requests, openBD opens 50 connections to oracle. What I pasted above is a snippet of code the java dev sent me, when i asked, 'how are you making requests to my service?'. Again, i'm not too 'java literate', and his code may be horrible. However, the fact that his is able to build *something* that forces openBD to open new connections to oracle passed the maxconnection parameter, could pose a serious stability issue if it were to be done maliciously. I was hoping the snippet would clarify what he was doing to cause the issue. I hope that's a little more clear.. I appreciate the help. -chris On Mar 19, 4:24 pm, Alan Williamson <[email protected]> wrote: > Chris where did this code come from? > > I am confused ... i thought you were talking about the database > connection pooling. There is no such code around that world that looks > like this. > > On 19/03/2012 18:38, chris schiffman wrote: > > > > > > > > > I may have spoken too soon on this.. It seems to only *not* work when > > a client connection attempts to open up a persistent socket connection > > with the OBD application. I'm not a java programmer, but here is a > > snippet that causes the problem: > > > .... > > SchemeRegistry schemeRegistry = new SchemeRegistry(); > > schemeRegistry.register( new Scheme("https", > > 443,SSLSocketFactory.getSocketFactory())); > > ThreadSafeClientConnManager cm = new > > ThreadSafeClientConnManager(); > > cm.setMaxTotal(20); > > > HttpClient client = new DefaultHttpClient(cm); > > HttpGet get = new HttpGet( url + "?" + content); > > String line = ""; > > StringBuilder sb = new StringBuilder(); > > HttpResponse response; > > response = client.execute(get); > > HttpEntity entity = response.getEntity(); > > .... > > > When that code is executed to hit my application (which has 10 > > maxconnections set in the datasource connection), it still opens up > > and establishes all 20.. Any other thoughts? > > > thanks, > > -chris -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
