I hate it when spelling counts.
On 2012-08-23, at 8:03 PM, John Huss wrote: > Not .DBURL, just .URL > > On Thu, Aug 23, 2012 at 8:12 PM, Theodore Petrosky <[email protected]> wrote: > ojdbc14.jar is in /Library/Java/Extensions > > it is also in the framework itself. > > interesting after experimenting I find I can use the properties file for: > > # SPAccessModel.DBURL=jdbc:oracle:thin:@10.1.3.250:1521/XE > # SPAccessModel.DBPlugin=com.webobjects.jdbcadaptor.OraclePlugIn > # SPAccessModel.DBDriver=oracle.jdbc.OracleDriver > SPAccessModel.DBUser=user > SPAccessModel.DBPassword=pw > > I have tried: > > SPAccessModel.DBURL > SPAccessModel.URL > SPAccessModel.DBUrl > > but until I comment it out and copy the connection string into the eomodel > file, it does not connect. > > from the docs: > > To do this for Oracle you can either specify on a per model basis or on a > global basis. > > Global: > dbConnectServerGLOBAL = myDatabaseServer > dbConnectUserGLOBAL = me > dbConnectPasswordGLOBAL = secret > dbConnectPluginGLOBAL = Oracle > Per Model for say model ER: > ER.DBServer = myDatabaseServer > ER.DBUser = me > ER.DBPassword = secret > ER.DBPlugin = Oracle > > Openbase: same, with DBDatabase and DBHostname > > JDBC: same with dbConnectURLGLOBAL, or ER.DBURL > > i am going home for the night. maybe tomorrow i will see the error. > > Ted > > --- On Thu, 8/23/12, [email protected] <[email protected]> wrote: > > > From: [email protected] <[email protected]> > > Subject: Re: creating a second database connection > > To: "Theodore Petrosky" <[email protected]> > > Cc: "Tim Worman" <[email protected]>, "WebObjects Development" > > <[email protected]> > > Date: Thursday, August 23, 2012, 8:56 PM > > 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 protected]> > > 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 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/probert%40macti.ca > > > > > > This email sent to [email protected] > > > > _______________________________________________ > 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/johnthuss%40gmail.com > > This email sent to [email protected] > > _______________________________________________ > 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/chill%40global-village.net > > This email sent to [email protected] -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/gvc/practical_webobjects _______________________________________________ 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]
