Re: 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: on behalf of
Theodore Petrosky
Date: Friday, October 28, 2016 at 6:21 PM
To: WebObjects-Dev
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 = ""; 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.(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.(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(
Apache 2.4 adaptor performance
Has anyone noticed any performance differences with Apache 2.4 vs 2.2? It seems the load on our server is much higher running 2.4 and quite a bit of time is spend in system calls. Could the adapter be responsible for it? Michael Kondratov Aspire Auctions, Inc. 216-231-5515 ___ 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
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 = ""; 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.(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.(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.appserve
Re: direct action URL without a session
final WOContext context = ERXWOContext.newContext(); context.generateCompleteURLs(); context.directActionURL... On Oct 28, 2016, at 6:29 AM, o...@ocs.cz wrote: > Hello there, > > the subject says it all — is there a decent way to construct a direct action > URL from a code which has no session (and thus no context)? Note I need a > full URL, not a relative one (it is to be used in diverse ways like “sent to > client by an e-mail” etc.) > > At the moment, I use > > Application app=Application.application() > String > url=app.cgiAdaptorURL+'/'+app.name+'/'+app.directActionRequestHandlerKey+'/'+directActionName+'?'+directActionAttributeName+'='+directActionAttributeValue > > which sort of works, but is not too flexible (e.g., it stops working with > direct access, where it lacks the port), it is very slightly incorrect (does > not contain ".woa"; seems harmless, but still weird), and besides, is pretty > ugly code (and would become far uglier with more attributes than one). Is > there a better way? > > Thanks, > OC > > > ___ > 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/rgurley%40smarthealth.com > > This email sent to rgur...@smarthealth.com ___ 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
Re: direct action URL without a session
Hi,
you may consider storing the session (and instanceId) in cookies.
in my application I use something like
@Override
public WOSession createSessionForRequest(WORequest worequest) {
WOSession session = super.createSessionForRequest(worequest);
if(!isDevelopmentMode() && (
ERXProperties.booleanForKeyWithDefault("storesIDsInCookies", false))) {
session.setStoresIDsInCookies(true);
session.setStoresIDsInURLs(false);
}
return session;
}
> Am 28.10.2016 um 15:29 schrieb o...@ocs.cz:
>
> Hello there,
>
> the subject says it all — is there a decent way to construct a direct action
> URL from a code which has no session (and thus no context)? Note I need a
> full URL, not a relative one (it is to be used in diverse ways like “sent to
> client by an e-mail” etc.)
>
> At the moment, I use
>
> Application app=Application.application()
> String
> url=app.cgiAdaptorURL+'/'+app.name+'/'+app.directActionRequestHandlerKey+'/'+directActionName+'?'+directActionAttributeName+'='+directActionAttributeValue
>
> which sort of works, but is not too flexible (e.g., it stops working with
> direct access, where it lacks the port), it is very slightly incorrect (does
> not contain ".woa"; seems harmless, but still weird), and besides, is pretty
> ugly code (and would become far uglier with more attributes than one). Is
> there a better way?
>
> Thanks,
> OC
>
regards
René
___
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
direct action URL without a session
Hello there, the subject says it all — is there a decent way to construct a direct action URL from a code which has no session (and thus no context)? Note I need a full URL, not a relative one (it is to be used in diverse ways like “sent to client by an e-mail” etc.) At the moment, I use Application app=Application.application() String url=app.cgiAdaptorURL+'/'+app.name+'/'+app.directActionRequestHandlerKey+'/'+directActionName+'?'+directActionAttributeName+'='+directActionAttributeValue which sort of works, but is not too flexible (e.g., it stops working with direct access, where it lacks the port), it is very slightly incorrect (does not contain ".woa"; seems harmless, but still weird), and besides, is pretty ugly code (and would become far uglier with more attributes than one). Is there a better way? Thanks, OC ___ 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
Using WOInject with an intermediate WOApplication subclass
Hi Henrique (and any other WOInject fans), I am taking WOInject for a test drive. I have what couldn’t be an uncommon situation: an intermediate, framework-level WOApplication subclass that provides numerous convenience features to the application. The inheritance hierarchy looks like this: Application → LSApplication → ERXApplication Since InjectableApplication extends ERXApplication, I figured this would be the way to go: Application → LSApplication → InjectableApplication → ERXApplication In Application.main() I call WOInject.init() with the Application class as the String argument, but this fails: > Cannot initialize the injector. The Application class doesn't extend > InjectableApplication. So I tried LSApplication as the String argument (because it’s the class that does extend InjectableApplication), but this fails with the same Exception. Is this kind of inheritance hierarchy just not supported by WOInject? That is, does Application itself have to extend InjectableApplication directly? -- Paul Hoadley http://logicsquad.net/ ___ 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
Re: excel export D2W
Hi Ted, That's handled via the rules. I don't have an example for dates, but for numeric values it looks like: 10 : (propertyKey like '*NetTurnover' or propertyKey like '*GrossProfit') => excelCellFormatForProperty = "#,##0€;#,##0€" [com.webobjects.directtoweb.Assignment] 10 : (propertyKey like '*NetTurnover' or propertyKey like '*GrossProfit') => excelCellTypeForProperty = "CELL_TYPE_NUMERIC" [com.webobjects.directtoweb.Assignment] Fabian > Am 28.10.2016 um 05:29 schrieb Theodore Petrosky : > > I am looking at ERExcelLook and the minimal video from David. Is there a way > to specify the cell type for an attribute? I have added a formatter for my > date column, but I really want to specify that it is a date column. I am > trying to get the data into excel with as much of the cell types set up as I > can. > ___ > 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/lists.fabian%40e-lumo.com > > This email sent to lists.fab...@e-lumo.com ___ 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
