Re: [SQLObject] reading and writing to different database instances

2006-08-01 Thread Rick Flosi
I'm pretty sure you can pass a connection around and set a connection when you create and instance and that it will use that connection for the life of that instance. I'm not sure if you can change the connection once you have an instance. I haven't had to do this, but it's something I think Ian

Re: [SQLObject] reading and writing to different database instances

2006-08-01 Thread Jorge Vargas
On 8/1/06, Dustin Lee <[EMAIL PROTECTED]> wrote: Is it possible to configure sqlobject so that it can select from one server and do insert/update/deletes on possibly another server (or generally just choose where any one given sql instruction will be executed)?  The background is that we are moving

[SQLObject] reading and writing to different database instances

2006-08-01 Thread Dustin Lee
Is it possible to configure sqlobject so that it can select from one server and do insert/update/deletes on possibly another server (or generally just choose where any one given sql instruction will be executed)?  The background is that we are moving to a multi-coast/continent replication scheme wi