• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: creating a second database connection
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: creating a second database connection
      • From: John Huss <email@hidden>
References: 
 >Re: creating a second database connection (From: email@hidden)

  • Prev by Date: Re: creating a second database connection
  • Next by Date: Re: creating a second database connection
  • Previous by thread: Re: creating a second database connection
  • Next by thread: Re: creating a second database connection
  • Index(es):
    • Date
    • Thread