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 protected]<mailto:[email protected]>> Date: Thursday, January 7, 2016 at 11:46 AM To: Chuck Hill <[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Cc: Kwasi O-Ahoofe <[email protected]<mailto:[email protected]>> 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 protected]<mailto:[email protected]>> 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: <[email protected]<mailto:[email protected]>> on behalf of Kwasi O-Ahoofe <[email protected]<mailto:[email protected]>> Date: Tuesday, January 5, 2016 at 1:17 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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 = "jdbc:postgresql://localhost:5432/contractmonitor"; } 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 = "jdbc:postgresql://localhost:5432/contractmonitor"; } 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 protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
