On Jun 20, 2007, at 12:16 AM, David Lloyd wrote:
>
> Is it possible to have separate read and write database connections in
> Rose::DB::Object?
>
> For example, I might have read to:
>
> read.db.com
>
> ...and...write to:
>
> write.db.com
>
> ...is it possible to get any updates/deletes and inserts (and other
> things that change the DB) to write.db.com but have Rose::DB::Object
> read from read.db.com?
set read.db as the default db ( or even set it to a null db )
whenever you need to do a write, just do..
my $obj= myobject->new()
$obj->db->dbh( $write_dbh );
$obj->save;
you can then connect / manage the write_dbh elsewhere, handling
transactions and all
you can do the same with a read dbh
there are a few postings about this approach a few months back in the
archives.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
