Re: creating a second database connection
Re: creating a second database connection
- Subject: Re: creating a second database connection
- From: Henrique Gomes <email@hidden>
- Date: Thu, 23 Aug 2012 20:44:26 +0100
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden