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
