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 18:12:15 -0700 (PDT)
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@hidden <email@hidden> wrote:
> From: email@hidden <email@hidden>
> Subject: Re: creating a second database connection
> To: "Theodore Petrosky" <email@hidden>
> Cc: "Tim Worman" <email@hidden>, "WebObjects Development" <email@hidden>
> 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@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