On 23/08/2012, at 20:37, Theodore Petrosky wrote: > so i am having a problem. > > db1 is a postgresql db on machine1 > db2 is an oracle db on machine2 > > I have a framework for each model and I am importing the frameworks into a > newly created D2W wonder app. > > If I start the app with either framework, I get a 'good' app that can query > the database in question. > > However, if I have both frameworks the app starts but if I try to access the > oracle data it blows up. > > it look like (from the logs) that with both frameworks in the path, > postgresqlplugin is being used. Hence oracle bites the dust. > > what should the property file look like for these frameworks? > > connection dict from the property file of db1 (postgresql) > # Connection Dictionary > dbConnectURLGLOBAL=jdbc:postgresql://localhost/asfreelancedb?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull > dbConnectUserGLOBAL=admin > dbConnectPasswordGLOBAL=4004 > dbConnectPluginGLOBAL=PostgresqlPlugIn > # dbConnectDriverGLOBAL=org.postgresql.Driver > dbEOPrototypesEntityGLOBAL=EOJDBCPostgresqlPrototypes > > connection dict from the property file of db2 (oracle) > # Connection Dictionary > dbConnectURLGLOBAL=jdbc:oracle:thin:@10.1.3.250:1521/XE > dbConnectUserGLOBAL=user > dbConnectPasswordGLOBAL=as4004 > > Interesting on the home tab search all I see all the correct columns in the > search all popups. But if I click the "find" button on a table that lives in > the oracle db it blows up with: > > NFO er.transaction.adaptor.Exceptions - Database Exception occured: ERROR: > relation "job" does not exist > Position: 1240at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) > > postgresql??? > > I am sure I am missing something simple. > > Ted >
Yes you are :-) The GLOBAL properties are just that: GLOBAL. Like for ALL models. The last one loaded wins. You must replace the 'GLOBAL' by the model name in each. dbConnectURLModel = HG _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
