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

Re: first time with oracle

  • Subject: Re: first time with oracle
  • From: Chuck Hill <email@hidden>
  • Date: Sat, 29 Oct 2016 02:21:40 +0000
  • Thread-topic: first time with oracle

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=email@hidden> on behalf of Theodore Petrosky <email@hidden>
Date: Friday, October 28, 2016 at 6:21 PM
To: WebObjects-Dev <email@hidden>
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 = "" }

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: Theodore Petrosky <email@hidden>
References: 
 >first time with oracle (From: Theodore Petrosky <email@hidden>)

  • Prev by Date: Apache 2.4 adaptor performance
  • Next by Date: Re: first time with oracle
  • Previous by thread: first time with oracle
  • Next by thread: Re: first time with oracle
  • Index(es):
    • Date
    • Thread