Re: [RDBO] Sharing a DBI connection with Class::DBI

2008-01-30 Thread Sam Tregar
On Jan 29, 2008 10:32 PM, John Siracusa [EMAIL PROTECTED] wrote: On 1/29/08, Sam Tregar [EMAIL PROTECTED] wrote: Do you happen to know if RDBO will tolerate a DBIx::ContextualFetch based DBI handle? It should, and if it doesn't, I can probably make it do so with some minor edits. Give of

Re: [RDBO] Sharing a DBI connection with Class::DBI

2008-01-29 Thread Sam Tregar
On Jan 29, 2008 9:55 PM, Peter Karman [EMAIL PROTECTED] wrote: just a naive guess here, but if you were using DBI-connect_cached as the underlying connect method, wouldn't DBI handle the sharing for you? No, I'm pretty sure DBI uses the class as part of the connect_cached key. -sam

[RDBO] Sharing a DBI connection with Class::DBI

2008-01-29 Thread Sam Tregar
Hey all. I'm getting started with Rose::DB::Object. My problem is I need to inter-operate with a large pre-existing Class::DBI code-base. I'd like to setup Rose to be able to share the same DBI connection that Class::DBI uses - otherwise I'll instantly double the number of connections from our

Re: [RDBO] Sharing a DBI connection with Class::DBI

2008-01-29 Thread Sam Tregar
On Jan 29, 2008 10:06 PM, John Siracusa [EMAIL PROTECTED] wrote: The db atribute of an RDBO-derived object isa Rose::DB, but each Rose::DB-derived object has a DBI $dbh. IOW, plain old DBI database handles are used via delegation in RDBO. There's no subclassing of DBI classes at all.

Re: [RDBO] Sharing a DBI connection with Class::DBI

2008-01-29 Thread John Siracusa
On Jan 29, 2008 9:57 PM, Sam Tregar [EMAIL PROTECTED] wrote: On Jan 29, 2008 9:55 PM, Peter Karman [EMAIL PROTECTED] wrote: just a naive guess here, but if you were using DBI-connect_cached as the underlying connect method, wouldn't DBI handle the sharing for you? No, I'm pretty sure DBI

Re: [RDBO] Sharing a DBI connection with Class::DBI

2008-01-29 Thread John Siracusa
On 1/29/08, Sam Tregar [EMAIL PROTECTED] wrote: Do you happen to know if RDBO will tolerate a DBIx::ContextualFetch based DBI handle? It should, and if it doesn't, I can probably make it do so with some minor edits. Give of a try and let me know. -John