Re: creating a second database connection
Re: creating a second database connection
- Subject: Re: creating a second database connection
- From: Theodore Petrosky <email@hidden>
- Date: Thu, 23 Aug 2012 17:23:27 -0700 (PDT)
Tim,
This is almost perfect. I used this example and 'fixed' the postgresql framework to work correctly with the properties file.
now the oracle property is giving grief. this is what I have:
# Connection Dictionary
SPAccessModel.URL=jdbc:oracle:thin:@10.1.3.250:1521/XE?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull
SPAccessModel.DBPlugin=OraclePlugIn
SPAccessModel.DBDriver=com.oracle.Driver
SPAccessModel.DBUser=user
SPAccessModel.DBPassword=pw
I must not have the correct name for the plugin and Driver.
--- On Thu, 8/23/12, Tim Worman <email@hidden> wrote:
> From: Tim Worman <email@hidden>
> Subject: Re: creating a second database connection
> To: "Theodore Petrosky" <email@hidden>
> Cc: "Chuck Hill" <email@hidden>, "WebObjects Development" <email@hidden>
> Date: Thursday, August 23, 2012, 7:51 PM
> I have connection settings for all of
> my databases in properties. They all work. When a Wonder app
> starts, it logs out all properties being used by the
> application. You won't even need to try and use the app - if
> they aren't there, they weren't discovered. If your app is a
> Wonder app, ERXConfiguationManager will discover all the
> properties.
>
> At launch, if your props are being improperly overwritten
> then you need to do a file search in your project for where
> they are being overridden. You cannot use any global
> settings if you are using more than one database since
> globals will be applied to every db connection.
>
> your individual database properties will be named as such:
>
> MyModel.URL = jdbc:urlForDatabaseConnection
> MyModel.DBDriver = com.openbase.jdbc.ObDriver (whatever)
> MyModel.DBPlugin = OpenBasePlugIn (whatever)
> MyModel.DBUser = user
> MyModel.DBPassword = password
>
> Where your EOModel is named "MyModel.eomodeld." It will work
> if you're not accidentally overriding the properties
> elsewhere.
>
> T
>
_______________________________________________
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