OK this is weird.
I started over and created a new D2W app.(and I downloaded ojdc6.jar) I added
an Entity Modeler in the app (not a framework) I used the url:
jdbc:oracle:thin:@//10.1.3.250:1521/XE
same user
same pw
I reversed two tables and ran the app. It worked fine.
So I went back to the original app that was using a framework for the oracle
connection and I commented out the property file entries for the global
database. then I went to the framework and added the connection information to
the Entity Modeler instance, and now that works.
What does that mean? I should not use the properties file for my connection
dictionary?
Let’s think. I had the connection dictionary in the Entity Modeler instance to
reverse engineer the database. Then I deleted the entries in EM, and added the
GLOBAL lines to the properties file in my app.
Somehow, even though I deleted the lines in the EM instance, the framework was
remembering and Chuck was asking, “Is it finding a different model somewhere?”
But I selected but my app, and the framework in Eclipse, cleaned them and even
right clicked and refreshed.
Should I just call this voodoo and move on?
Ted
> On Oct 28, 2016, at 10:21 PM, Chuck Hill <ch...@gevityinc.com> wrote:
>
> Is it finding a different model somewhere? And ojdbc14.jar is kind of old
> (Java 1.4). There are newer ones.
>
> Chuck
>
>
> From: <webobjects-dev-bounces+chill=gevityinc....@lists.apple.com> on behalf
> of Theodore Petrosky <tedp...@yahoo.com>
> Date: Friday, October 28, 2016 at 6:21 PM
> To: WebObjects-Dev <webobjects-dev@lists.apple.com>
> Subject: first time with oracle
>
> 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
