Re: ERXJDBCConnectionAnalyser and Connections Exhausted!
Hi Chuck,
I have changed the code and am using ERXJDBCConnectionBroker to test the
database connectivity and it's serving the purpose very well.
Thanks,
Farrukh
Sent from my iPad
On 28-Oct-2010, at 8:01 PM, Chuck Hill wrote:
> I wrote it to debug a failure to connect so this was never a concern - the
> JVM exited right after this. It was NOT intended to be used how you are
> using it. It is intended to debug configuration issues.
>
> Closing this connection is non-trivial.
>
> For what I think this is doing, you would be better off making a simple fetch
> of an entity that you know is there.
>
>
> Chuck
>
>
> On Oct 28, 2010, at 5:38 AM, Farrukh Ijaz 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 dictStatus = new
>> NSMutableDictionary();
>>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 [-:12345 0]
>> er.transaction.adaptor.ConnectionAnalyzer
>> (ERXJDBCConnectionAnalyzer.java:105) - Trying to create JDBCAdaptor...
>> 2010-10-28 15:33:39,297 INFO [-:12345 0]
>> er.transaction.adaptor.ConnectionAnalyzer
>> (ERXJDBCConnectionAnalyzer.java:115) - Successfully created adaptor
>> er.extensions.jdbc.ERXJDBCAdaptor
>> 2010-10-28 15:33:39,298 INFO [-:12345 0]
>> er.transaction.adaptor.ConnectionAnalyzer
>> (ERXJDBCConnectionAnalyzer.java:126) - Trying to create plugin...
>> 2010-10-28 15:33:39,298 INFO [-:12345 0]
>> er.transaction.adaptor.ConnectionAnalyzer
>> (ERXJDBCConnectionAnalyzer.java:131) - Created plugin
>> com.webobjects.jdbcadaptor.PostgresqlPlugIn
>> 2010-10-28 15:33:39,298 INFO [-: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 [-:12345 0]
>> er.transaction.adaptor.ConnectionAnalyzer
>> (ERXJDBCConnectionAnalyzer.java:183) - Successfully loaded JDBC driver
>> org.postgresql.Driver
>> 2010-10-28 15:33:39,299 INFO [-: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 [-: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 [-: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 [-: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 (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>
>> This email sent to ch...@global-village.net
>
> --
> Chuck Hill Senior Consultant / VP Development
>
> Practical WebObjects - for developers who want to increase their overall
> knowledge of WebObjects or who are trying to solve specific problems.
> http://www.global-village.net/products/practical_webobjects
>
>
>
>
>
>
>
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
h
Re: ERXJDBCConnectionAnalyser and Connections Exhausted!
I wrote it to debug a failure to connect so this was never a concern - the JVM
exited right after this. It was NOT intended to be used how you are using it.
It is intended to debug configuration issues.
Closing this connection is non-trivial.
For what I think this is doing, you would be better off making a simple fetch
of an entity that you know is there.
Chuck
On Oct 28, 2010, at 5:38 AM, Farrukh Ijaz 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 dictStatus = new
> NSMutableDictionary();
> 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 [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:105) - Trying to create JDBCAdaptor...
> 2010-10-28 15:33:39,297 INFO [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:115) - Successfully created adaptor
> er.extensions.jdbc.ERXJDBCAdaptor
> 2010-10-28 15:33:39,298 INFO [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:126) - Trying to create plugin...
> 2010-10-28 15:33:39,298 INFO [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:131) - Created plugin
> com.webobjects.jdbcadaptor.PostgresqlPlugIn
> 2010-10-28 15:33:39,298 INFO [-: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 [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:183) - Successfully loaded JDBC driver
> org.postgresql.Driver
> 2010-10-28 15:33:39,299 INFO [-: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 [-: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 [-: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 [-: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 (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>
> This email sent to ch...@global-village.net
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall
knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
smime.p7s
Description: S/MIME cryptographic signature
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
Re: ERXJDBCConnectionAnalyser and Connections Exhausted!
i don't have the answer, but we see this same issue all the time
simon
On 28 October 2010 13:38, Farrukh Ijaz
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 dictStatus = new
> NSMutableDictionary();
> 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 [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:105) - Trying to create JDBCAdaptor...
> 2010-10-28 15:33:39,297 INFO [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:115) - Successfully created adaptor
> er.extensions.jdbc.ERXJDBCAdaptor
> 2010-10-28 15:33:39,298 INFO [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:126) - Trying to create plugin...
> 2010-10-28 15:33:39,298 INFO [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:131) - Created plugin
> com.webobjects.jdbcadaptor.PostgresqlPlugIn
> 2010-10-28 15:33:39,298 INFO [-: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 [-:12345 0]
> er.transaction.adaptor.ConnectionAnalyzer
> (ERXJDBCConnectionAnalyzer.java:183) - Successfully loaded JDBC driver
> org.postgresql.Driver
> 2010-10-28 15:33:39,299 INFO [-: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 [-: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 [-: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 [-: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 (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/simon%40potwells.co.uk
>
> This email sent to si...@potwells.co.uk
>
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
ERXJDBCConnectionAnalyser and Connections Exhausted!
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 dictStatus = new
NSMutableDictionary();
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 [-:12345 0]
er.transaction.adaptor.ConnectionAnalyzer (ERXJDBCConnectionAnalyzer.java:105)
- Trying to create JDBCAdaptor...
2010-10-28 15:33:39,297 INFO [-:12345 0]
er.transaction.adaptor.ConnectionAnalyzer (ERXJDBCConnectionAnalyzer.java:115)
- Successfully created adaptor er.extensions.jdbc.ERXJDBCAdaptor
2010-10-28 15:33:39,298 INFO [-:12345 0]
er.transaction.adaptor.ConnectionAnalyzer (ERXJDBCConnectionAnalyzer.java:126)
- Trying to create plugin...
2010-10-28 15:33:39,298 INFO [-:12345 0]
er.transaction.adaptor.ConnectionAnalyzer (ERXJDBCConnectionAnalyzer.java:131)
- Created plugin com.webobjects.jdbcadaptor.PostgresqlPlugIn
2010-10-28 15:33:39,298 INFO [-: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 [-:12345 0]
er.transaction.adaptor.ConnectionAnalyzer (ERXJDBCConnectionAnalyzer.java:183)
- Successfully loaded JDBC driver org.postgresql.Driver
2010-10-28 15:33:39,299 INFO [-: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 [-: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 [-: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 [-: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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
