i don't have the answer, but we see this same issue all the time.... simon
On 28 October 2010 13:38, Farrukh Ijaz <[email protected]> wrote: > Hi Gurus, > How can I release the JDBC connection that is hooked by > ERXJDBCConnectionAnalyser class? > I've defined following properties: > er.extensions.ERXJDBCAdaptor.useConnectionBroker = true > dbMinConnectionsGLOBAL=1 > dbMaxConnectionsGLOBAL=5 > dbMaxCheckoutGLOBAL=600 > dbDebugLevelGLOBAL=3 > I've following code being called one of my direct actions for testing > purpose: > public WOActionResults monitorAction() { > NSMutableDictionary<String, String> dictStatus = new > NSMutableDictionary<String, String>(); > for (EOModel m : EOModelGroup.defaultGroup().models()) { > ERXJDBCConnectionAnalyzer ca = new ERXJDBCConnectionAnalyzer(m); > try { > ca.testConnection(); > dictStatus.put(m.name(), "OK"); > } catch (Throwable t) { > dictStatus.put(m.name(), "Error: " + t.getMessage()); > } > } > WOComponent page = pageWithName(Monitor.class.getName()); > page.takeValueForKey(dictStatus, "dictStatus"); > return page; > } > If I set the useConnectionBroker property to "false", it works okay. > Otherwise I get following exception. > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:84) - Checking JDBC connection with > information {minConnections = "1"; ... ... ... ... ... ... > 2010-10-28 15:33:39,297 INFO XXXXXXXX[-:12345 0] > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:105) - Trying to create JDBCAdaptor... > 2010-10-28 15:33:39,297 INFO XXXXXXXX[-:12345 0] > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:115) - Successfully created adaptor > er.extensions.jdbc.ERXJDBCAdaptor > 2010-10-28 15:33:39,298 INFO XXXXXXXX[-:12345 0] > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:126) - Trying to create plugin... > 2010-10-28 15:33:39,298 INFO XXXXXXXX[-:12345 0] > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:131) - Created plugin > com.webobjects.jdbcadaptor.PostgresqlPlugIn > 2010-10-28 15:33:39,298 INFO XXXXXXXX[-:12345 0] > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:170) - Trying to load JDBC driver > org.postgresql.Driver... > 2010-10-28 15:33:39,299 INFO XXXXXXXX[-:12345 0] > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:183) - Successfully loaded JDBC driver > org.postgresql.Driver > 2010-10-28 15:33:39,299 INFO XXXXXXXX[-:12345 0] > er.transaction.adaptor.ConnectionAnalyzer > (ERXJDBCConnectionAnalyzer.java:192) - JDBC driver and plugin are loaded, > trying to connect... > 2010-10-28 15:33:41,299 WARN XXXXXXXX[-:12345 0] > er.extensions.jdbc.ERXJDBCConnectionBroker > (ERXJDBCConnectionBroker.java:368) - Connections Exhausted! Will wait and > try again in loop 0 > 2010-10-28 15:33:43,300 WARN XXXXXXXX[-:12345 0] > er.extensions.jdbc.ERXJDBCConnectionBroker > (ERXJDBCConnectionBroker.java:368) - Connections Exhausted! Will wait and > try again in loop 1 > 2010-10-28 15:33:45,301 WARN XXXXXXXX[-:12345 0] > er.extensions.jdbc.ERXJDBCConnectionBroker > (ERXJDBCConnectionBroker.java:368) - Connections Exhausted! Will wait and > try again in loop 2 > How can I enforce ERXJDBCConnectionAnalyser to release connection? > Thanks, > Farrukh > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/simon%40potwells.co.uk > > This email sent to [email protected] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
