• 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 13:53:49 -0700 (PDT)

Is there an issue with the number of characters? because this is not working:

# Connection Dictionary
 dbConnectURLModel=ASFreelanceUsageModel
 dbConnectURLASFreelanceUsageModel=jdbc:postgresql://localhost/asfreelancedb?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull
 dbConnectUserASFreelanceUsageModel=admin
 dbConnectPasswordASFreelanceUsageModel=4004
 dbConnectPluginASFreelanceUsageModel=PostgresqlPlugIn
 dbConnectDriverASFreelanceUsageModel=org.postgresql.Driver

I have tried this value (ASFreelanceUsageModel) to be the name of the model or the name of the framework.

do the name of the model and the name of the framework have to agree?


Aug 23 16:47:24 ASFreelanceWorkD2W[50829] INFO  er.transaction.adaptor.ConnectionAnalyzer  - Either
(a) the plugin is missing from your classpath or
(b) the connection dictionary has a misspelled 'plugin' key or
(c) the plug-in name specified under the 'plugin' key is incorrect or
(d) the class name for the JDBC driver under the key 'driver' is missing from the connection dictionary or
(e)the connection dictionary has a misspelled 'driver' key



but this worked fine:

# Connection Dictionary
 dbConnectURLModel=SPAccessModel;
 dbConnectURLSPAccessModel=jdbc:oracle:thin:@10.1.3.250:1521/XE?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull
 dbConnectUserSPAccessModel=spartner
 dbConnectPasswordSPAccessModel=as4004
 dbConnectPluginSPAccessModel=OraclePlugIn


Or I am misunderstanding how to use this.

Ted








--- On Thu, 8/23/12, Henrique Gomes <email@hidden> wrote:

> From: Henrique Gomes <email@hidden>
> Subject: Re: creating a second database connection
> To: "Theodore Petrosky" <email@hidden>
> Cc: "WebObjects Development" <email@hidden>
> Date: Thursday, August 23, 2012, 3:44 PM
>
> On 23/08/2012, at 20:37, Theodore Petrosky wrote:
>
> > so i am having a problem.
> >
> > db1 is a postgresql db on machine1
> > db2 is an oracle    db on machine2
> >
> > I have a framework for each model and I am importing
> the frameworks into a newly created D2W wonder app.
> >
> > If I start the app with either framework, I get a
> 'good' app that can query the database in question.
> >
> > However, if I have both frameworks the app starts but
> if I try to access the oracle data it blows up.
> >
> > it look like (from the logs) that with both frameworks
> in the path, postgresqlplugin is being used. Hence oracle
> bites the dust.
> >
> > what should the property file look like for these
> frameworks?
> >
> > connection dict from the property file of db1
> (postgresql)
> > # Connection Dictionary
> >
> dbConnectURLGLOBAL=jdbc:postgresql://localhost/asfreelancedb?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull
> > dbConnectUserGLOBAL=admin
> > dbConnectPasswordGLOBAL=4004
> > dbConnectPluginGLOBAL=PostgresqlPlugIn
> > # dbConnectDriverGLOBAL=org.postgresql.Driver
> > dbEOPrototypesEntityGLOBAL=EOJDBCPostgresqlPrototypes
> >
> > connection dict from the property file of db2 (oracle)
> > # Connection Dictionary
> >
> dbConnectURLGLOBAL=jdbc:oracle:thin:@10.1.3.250:1521/XE
> > dbConnectUserGLOBAL=user
> > dbConnectPasswordGLOBAL=as4004
> >
> > Interesting on the home tab search all I see all the
> correct columns in the search all popups. But if I click the
> "find" button on a table that lives in the oracle db it
> blows up with:
> >
> > NFO  er.transaction.adaptor.Exceptions  -
> Database Exception occured: ERROR: relation "job" does not
> exist
> >  Position: 1240at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
> >
> > postgresql???
> >
> > I am sure I am missing something simple.
> >
> > Ted
> >
>
>
> Yes you are :-)
> The GLOBAL properties are just that: GLOBAL. Like for ALL
> models. The last one loaded wins. You must replace the
> 'GLOBAL' by the model name in each.
>
> dbConnectURLModel =
>
> HG
>
>

 _______________________________________________
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: Chuck Hill <email@hidden>
References: 
 >Re: creating a second database connection (From: Henrique Gomes <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