Re: creating a second database connection
Re: creating a second database connection
- Subject: Re: creating a second database connection
- From: email@hidden
- Date: Thu, 23 Aug 2012 20:56:43 -0400
Do you have the JDBC driver for Oracle in the class path?
Envoyé de mon iPhone
Le 2012-08-23 à 20:24, "Theodore Petrosky" <email@hidden> a écrit :
> 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
_______________________________________________
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