• 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: Tue, 05 Jan 2016 21:44:30 +0000
  • Thread-topic: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
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
  • Prev by Date: Re: Ajax ?
  • Next by Date: Wonder 7: NoClassDefFoundError: com/webobjects/jdbcadaptor/FrontbasePlugIn
  • Previous by thread: Help with a Wonder_7 change to NSArray
  • Next by thread: Re: er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext
  • Index(es):
    • Date
    • Thread