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 protected]> wrote: > From: Tim Worman <[email protected]> > Subject: Re: creating a second database connection > To: "Theodore Petrosky" <[email protected]> > Cc: "Chuck Hill" <[email protected]>, "WebObjects Development" > <[email protected]> > 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 protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
