From: Oliver E. <ol...@eg...> - 2007-02-01 08:11:53
|
Hi Chuck and Anjo dbRemoveJdbc2InfoGlobal=false thanks, you made my day with your tips! i was close for reverting back to the old framwork but found that wonder has a property to not set the jdbc2info in the connection dictionary and the new creation of a db connection within a new OSC do not happen anymore! thanks a lot! oliver On 2/1/07, Oliver Egger <ol...@eg...> wrote: > Hi Anjo > > That's actually the exact requirement I have. an OSC per (logged in) > user, since i have > a limited db connections available i need pooling. however with the > current version each > new OSC creates a new jdbc connection to the database. I tried to > debug it, however it is > mysterious for me where this connection is created, i suspect it has > something to do that > Context.createAdaptorChannel is called for every new OSC however from > here im lost with my EOF knowledge. Any pointer where I could further > look into where the connections are created? > > Cheers, Oliver > > > > > >> RXJDBCAdaptor's ConnectionBroker > > >> I want to understand more of the concept of Oliver's earlier post. > > >> Is the concept of the ConnectionBroker to allow more than one > > >> database connection per ObjectStore? > > >> Would having this setting enabled (to at least 2) prevent the > > >> above bottleneck? > > > I don't know what the issues of having multiple connections on a > > > single OSC are. Firstly, I really don't know if there's any > > > benefit given that EOF is single threaded in a single OSC, and more > > > importantly I don't know if there are terrible transaction > > > impedance mismatches with the way EOF was designed. This is not an > > > informed opinion, just a wary eye. I'd be curious to find this out > > > also. > > > > Nope. The idea is just the other way round. Say you have a lot of mem > > for many OSCs but don't want a of DB connections, then you can have > > the connection broker pick the a connection for a single transaction > > only and release it afterwards. As it's always whole transactions > > getting swiped over to the next free connection, I couldn't imagine > > where there should be a problem? > > > > Cheers, Anjo > > > > ------------------------------------------------------------------------- > > Using Tomcat but need to do more? Need to support web services, security? > > Get stuff done quickly with pre-integrated technology to make your job easier. > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > _______________________________________________ > > Wonder-disc mailing list > > Won...@li... > > https://lists.sourceforge.net/lists/listinfo/wonder-disc > > > > > -- |