I am trying to access an Oracle backend. I think I am almost there. first. I created a Wonder framework and added ojdbc14.jar to the build path. In entity modeler I added for the URL: jdbc:oracle:thin:@//10.1.3.250:1521/XE
and i gave it the user name and password. Entity Modeler connected to the database and I was able to reverse compile the database. so far so good. So I created a Wonder D2W app, added my reverse compiled framework, added EROraclePlugin. I added the ojdbc14.jar to my build path. I added into the propery file: # Oracle Connection Dictionary dbConnectUserGLOBAL=name dbConnectPasswordGLOBAL=pw dbConnectURLGLOBAL=jdbc:oracle:thin:@//10.1.3.250:1521/XE?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull the app compiled and ran then on the home page I see all the tables that I reverse compiled. so far so good until I click any Find button on any table: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@3dc4f166: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. am I missing something in my setup? Oct 28 21:14:22 MySilentPartner[58575] WARN er.extensions.eof.ERXModelGroup (null) - Clearing previous class descriptions Oct 28 21:14:22 MySilentPartner[58575] DEBUG NSLog (null) - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.EROraclePlugIn' for ERXJDBCAdaptor@2112380784 Oct 28 21:14:22 MySilentPartner[58575] INFO er.extensions.appserver.ERXStaticResourceRequestHandler - Unable to get contents of file 'ERROR_NOT_FOUND_framework_app_filename_customizations.css' for uri: ERROR_NOT_FOUND_framework_app_filename_customizations.css Oct 28 21:14:26 MySilentPartner[58575] DEBUG NSLog - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.EROraclePlugIn' for ERXJDBCAdaptor@1670927216 Oct 28 21:14:26 MySilentPartner[58575] DEBUG NSLog - connecting with dictionary: {password = "<password deleted for log>"; username = "spartner"; URL = "jdbc:oracle:thin:@//10.1.3.250:1521/XE?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull"; } Oct 28 21:14:26 MySilentPartner[58575] WARN NSLog - An exception occurred while trying to open a channel: Io exception: NL Exception was generatedat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at com.webobjects.jdbcadaptor.JDBCContext.connect(JDBCContext.java:236) at er.extensions.jdbc.ERXJDBCAdaptor$Context.connect(ERXJDBCAdaptor.java:400) at com.webobjects.jdbcadaptor.JDBCContext._tryConnect(JDBCContext.java:362) at com.webobjects.jdbcadaptor.JDBCContext._channelWillOpen(JDBCContext.java:505) at com.webobjects.jdbcadaptor.JDBCChannel.openChannel(JDBCChannel.java:111) at com.webobjects.eoaccess.EODatabaseContext._openChannelWithLoginPanel(EODatabaseContext.java:1907) at com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1966) at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054) at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195) at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069) at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1307) at com.webobjects.eoaccess.EODatabaseDataSource.fetchObjects(EODatabaseDataSource.java:589) at com.webobjects.appserver.WODisplayGroup.fetch(WODisplayGroup.java:2132) at er.extensions.appserver.ERXDisplayGroup.fetch(ERXDisplayGroup.java:196) at er.directtoweb.pages.ERD2WListPage._fetchDisplayGroup(ERD2WListPage.java:466) at er.directtoweb.pages.ERD2WListPage.setupPhase(ERD2WListPage.java:568) at er.directtoweb.pages.ERD2WListPage.appendToResponse(ERD2WListPage.java:499) at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java:1385) at er.extensions.appserver.ERXSession.appendToResponse(ERXSession.java:565) at com.webobjects.appserver.WOApplication.appendToResponse(WOApplication.java:1794) at er.extensions.appserver.ERXApplication.appendToResponse(ERXApplication.java:1988) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:190) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedSession(ERXComponentRequestHandler.java:235) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedApplication(ERXComponentRequestHandler.java:268) at er.extensions.appserver.ERXComponentRequestHandler._handleRequest(ERXComponentRequestHandler.java:302) at er.extensions.appserver.ERXComponentRequestHandler.handleRequest(ERXComponentRequestHandler.java:378) at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687) at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:2092) at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:2057) at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144) at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226) at java.lang.Thread.run(Thread.java:745) Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@778f948: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. Oct 28 21:14:26 MySilentPartner[58575] INFO er.extensions.eof.ERXDatabaseContextDelegate - SilentPartner: {password = "<password deleted for log>"; username = "spartner"; URL = "jdbc:oracle:thin:@//10.1.3.250:1521/XE?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull"; } Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Checking JDBC connection with information {password = "<password deleted for log>"; username = "spartner"; URL = "jdbc:oracle:thin:@//10.1.3.250:1521/XE?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull"; } Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create JDBCAdaptor... Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully created adaptor class er.extensions.jdbc.ERXJDBCAdaptor Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to create plugin... Oct 28 21:14:26 MySilentPartner[58575] DEBUG NSLog - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.EROraclePlugIn' for ERXJDBCAdaptor@1432431481 Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Created plugin class com.webobjects.jdbcadaptor.EROraclePlugIn Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Trying to load JDBC driver oracle.jdbc.driver.OracleDriver... Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Successfully loaded JDBC driver oracle.jdbc.driver.OracleDriver Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - JDBC driver and plugin are loaded, trying to connect... Oct 28 21:14:26 MySilentPartner[58575] DEBUG NSLog - connecting with dictionary: {password = "<password deleted for log>"; username = "spartner"; URL = "jdbc:oracle:thin:@//10.1.3.250:1521/XE?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull"; } Oct 28 21:14:26 MySilentPartner[58575] INFO er.transaction.adaptor.ConnectionAnalyzer - Error: Exception thrown while connecting. Check exception message carefully. Oct 28 21:14:26 MySilentPartner[58575] ERROR er.transaction.adaptor.ConnectionAnalyzer - Io exception: NL Exception was generated. Oct 28 21:14:26 MySilentPartner[58575] WARN NSLog - <er.extensions.appserver.ERXComponentRequestHandler>: Exception occurred while handling request: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@778f948: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. [2016-10-28 21:14:26 EDT] <WorkerThread7> java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@778f948: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. at com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967) at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054) at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195) at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069) at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1307) at com.webobjects.eoaccess.EODatabaseDataSource.fetchObjects(EODatabaseDataSource.java:589) at com.webobjects.appserver.WODisplayGroup.fetch(WODisplayGroup.java:2132) at er.extensions.appserver.ERXDisplayGroup.fetch(ERXDisplayGroup.java:196) at er.directtoweb.pages.ERD2WListPage._fetchDisplayGroup(ERD2WListPage.java:466) at er.directtoweb.pages.ERD2WListPage.setupPhase(ERD2WListPage.java:568) at er.directtoweb.pages.ERD2WListPage.appendToResponse(ERD2WListPage.java:499) at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java:1385) at er.extensions.appserver.ERXSession.appendToResponse(ERXSession.java:565) at com.webobjects.appserver.WOApplication.appendToResponse(WOApplication.java:1794) at er.extensions.appserver.ERXApplication.appendToResponse(ERXApplication.java:1988) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:190) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedSession(ERXComponentRequestHandler.java:235) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedApplication(ERXComponentRequestHandler.java:268) at er.extensions.appserver.ERXComponentRequestHandler._handleRequest(ERXComponentRequestHandler.java:302) at er.extensions.appserver.ERXComponentRequestHandler.handleRequest(ERXComponentRequestHandler.java:378) at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687) at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:2092) at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:2057) at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144) at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226) at java.lang.Thread.run(Thread.java:745) Oct 28 21:14:26 MySilentPartner[58575] ERROR er.extensions.appserver.ERXApplication - Exception caught: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@778f948: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. Extra info: { "D2W-SubTask" = "null"; "D2W-PageConfiguration" = "ListGl"; "CurrentComponent" = "er.modern.look.pages.ERMODListPage"; "PreviousPageList" = (); "D2W-PropertyKey" = "null"; "D2W-DisplayPropertyKeys" = ( "acctDesc", "acctName",
_______________________________________________ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com