Re: [Zope-DB] Multiple databases connection

2006-06-08 Thread Federico Di Gregorio
On mer, 2006-06-07 at 18:49 -0700, Infor Gates wrote:
 Is there anyway where we can have a dynamically database connection to
 each branch database with only one zope application (instead of
 multiples of the same application).
 
 We are using Zope 2.8.6, Postgresql 8.0.4 with Psycopg-1.1.21
 connector.

I don't understand what you mean by dynamically database connection,
but Zope supports connections to multiple databases by simply creating
muiltiple connections objects (Z Psycopg Connection objects in your
case).

federico

-- 
Federico Di Gregorio http://people.initd.org/fog
Debian GNU/Linux Developer[EMAIL PROTECTED]
INIT.D Developer   [EMAIL PROTECTED]
  L'unica cosa che riesco a produrre con una certa precisione nella mia
   vita sono i dubbi.  -- Natale Titotto


signature.asc
Description: This is a digitally signed message part
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


[Fwd: Re: [Zope-DB] Multiple databases connection]

2006-06-08 Thread m.banaouas
May be dynamically database connection means that we use the same Z 
SQL Method with different database connections (in the same Zope 
Instance, of course). So we can change dynamically from one database 
to another (schema-equal).


In other words, is it possible to define database connection property 
of a Z SQL Method like we do for parameters ?

thanks.



On mer, 2006-06-07 at 18:49 -0700, Infor Gates wrote:
 Is there anyway where we can have a dynamically database connection to
 each branch database with only one zope application (instead of
 multiples of the same application).

 We are using Zope 2.8.6, Postgresql 8.0.4 with Psycopg-1.1.21
 connector.

I don't understand what you mean by dynamically database connection,
but Zope supports connections to multiple databases by simply creating
muiltiple connections objects (Z Psycopg Connection objects in your
case).

federico



___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


[Zope-DB] Multiple databases connection

2006-06-07 Thread Infor Gates
Dear listMy organisation received databases uploaded from our branches. These branches databases are then restored into the main system. The Main Office then access to these databases individually.Currently, separate copies of the same zope application is copied in the same Zope server corresponding to each branch database. The main reason is because we are unable to resolve database connection to multiple databases. Is there anyway where we can have a dynamically database connection to each branch database with only one zope application (instead of multiples of the same application).We are using Zope 2.8.6, Postgresql 8.0.4 with Psycopg-1.1.21 connector.Thank you.CY __Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db