• 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
first time with oracle
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

first time with oracle

  • Subject: first time with oracle
  • From: Theodore Petrosky <email@hidden>
  • Date: Fri, 28 Oct 2016 21:21:52 -0400
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 = ""; }
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 = ""; }
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 = ""; }
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 = ""; }
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      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: first time with oracle
      • From: Chuck Hill <email@hidden>
  • Prev by Date: Re: direct action URL without a session
  • Next by Date: Apache 2.4 adaptor performance
  • Previous by thread: Re: direct action URL without a session
  • Next by thread: Re: first time with oracle
  • Index(es):
    • Date
    • Thread