• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext

  • Subject: Re: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
  • From: Chuck Hill <email@hidden>
  • Date: Fri, 08 Jan 2016 03:29:07 +0000
  • Thread-topic: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
Hi Kwasi,

I am not certain of what you are seeing.  All of the EOF stack is created on demand, so some of the objects you mention might not exist if the database connection can’t be made.  What exactly did you see with your debug logging?

Your original log still looks like a Postgres problem to me.  It is puzzling that disabling Wonder startup makes the problem go away.  Did you keep the class path the same?  

Chuck


From: Kwasi O-Ahoofe <email@hidden>
Date: Thursday, January 7, 2016 at 11:46 AM
To: Chuck Hill <email@hidden>, "email@hidden" <email@hidden>
Cc: Kwasi O-Ahoofe <email@hidden>
Subject: Re: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext

Folks, an interesting revelation: The referenced problem/exception goes away when I made the following changes:

    Replaced: public class Application extends ERXApplication WITH:  public class Application extends WOApplication 
       public class Session extends ERXSession  WITH: public class Session extends WOSession 
            public class DirectAction extends ERXDirectAction    WITH: public class DirectAction extends WODirectAction

Guess where I’m going with this, < ERXApplication, et. al> is/are NOT appropriately marshaling and/or managing the EOObjectStore, EOObjectStoreCoordinator, EOCooperatingObjectStore, etc required by the Runtime Environment and entire depended Framework!!! 
I had to force some ‘low level’ debug [.. used to do that a 100yrs ago] to recognize that the adaptor/channel layers seem broken or unmanaged.. I think, I need to elevate this to actual ‘code maintainers’ for their thought.
Thanks to all who have responded and offered suggestions..that’s what makes our profession exciting to participate in.

Still will entertain more insight into this problem…

Kwasi
On Jan 5, 2016, at 4:44 PM, Chuck Hill <email@hidden> wrote:

That looks like a Postgres configuration problem.  EOF is able to load the adaptor, plugin, and driver:

INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create JDBCAdaptor...
INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully created adaptor er.extensions.jdbc.ERXJDBCAdaptor

INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create plugin...
INFO er.transaction.adaptor.ConnectionAnalyzer - Created plugin com.webobjects.jdbcadaptor.PostgresqlPlugIn

INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to load JDBC driver org.postgresql.Driver...
INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully loaded JDBC driver org.postgresql.Driver
INFO er.transaction.adaptor.ConnectionAnalyzer - JDBC driver and plugin are loaded, 

That and a valid user and password are all that EOF should need.

So it is going to be something like the user name and password are not setup, or connections are not allowed from that host, or the database is not running, or maybe a networking problem.  Some of those seem unlikely if your database is really on the same localhost machine.

Chuck




From: <webobjects-dev-bounces+chill=email@hidden> on behalf of Kwasi O-Ahoofe <email@hidden>
Date: Tuesday, January 5, 2016 at 1:17 PM
To: "email@hidden" <email@hidden>
Subject: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext

I am 'stomped' and 'dead in the water' for this... I have run out of ideas on how to resolve the exception below. PS: I can't seem to generate SQL from Entity Modeler either..!! [Sorry for lengthy output..]

Running Mac OS X 10.11.2 & WOLips v44 & v 3.7:



Jan 05 10:31:00 ProjectComplianceWonder[65215] WARN NSLog - An exception occurred while trying to open a channel: N/A
Jan 05 10:31:00 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@2421cc4: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured.
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.extensions.eof.ERXDatabaseContextDelegate - KOA_ContractCompliance_Prod10g: {plugin = "Postgresql"; username = "contractmonitor"; driver = "org.postgresql.Driver"; password = "<password deleted for log>"; URL = "" }
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Checking JDBC connection with information {plugin = "Postgresql"; username = "contractmonitor"; driver = "org.postgresql.Driver"; password = "<password deleted for log>"; URL = "" }
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create JDBCAdaptor...
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully created adaptor er.extensions.jdbc.ERXJDBCAdaptor
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create plugin...
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Created plugin com.webobjects.jdbcadaptor.PostgresqlPlugIn
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to load JDBC driver org.postgresql.Driver...
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully loaded JDBC driver org.postgresql.Driver
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - JDBC driver and plugin are loaded, trying to connect...
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.transaction.adaptor.ConnectionAnalyzer - Error: Exception thrown while connecting.
Check exception message carefully.
Jan 05 10:31:01 ProjectComplianceWonder[65215] ERROR er.transaction.adaptor.ConnectionAnalyzer - No connection.
Jan 05 10:31:01 ProjectComplianceWonder[65215] INFO er.extensions.appserver.ERXApplication -


 
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
References: 
 >Re: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Ajax jQuery
  • Next by Date: Re: Ajax jQuery
  • Previous by thread: Re: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
  • Next by thread: Wonder 7: NoClassDefFoundError: com/webobjects/jdbcadaptor/FrontbasePlugIn
  • Index(es):
    • Date
    • Thread