Re: [RDBO] Still fighting with transactions

2007-08-16 Thread Tim Bunce
On Wed, Aug 15, 2007 at 10:17:07PM -0400, John Siracusa wrote: > On 8/15/07 10:08 PM, Graham Barr wrote: > > On Aug 15, 2007, at 7:56 PM, John Siracusa wrote: > >> The only dbh attributes that get set in init_dbh() after the > >> DBI->connect() call are the ones that don't (apparently?) work if > >

Re: [RDBO] Still fighting with transactions

2007-08-15 Thread Tim Bunce
On Wed, Aug 15, 2007 at 01:06:01PM -0500, Graham Barr wrote: > > Rose::DB does not know that the $dbh it get back from connect is not a > newly connected handle. As a result is still goes ahead and calls init_dbh > which will set all the dbh attributes to the defaults. The standard approach I rec

Re: [RDBO] Still fighting with transactions

2007-08-15 Thread Tim Bunce
On Wed, Aug 15, 2007 at 01:06:01PM -0500, Graham Barr wrote: > > in Rose::DB AutoCommit has a default of 1. In my case that is the default > I want. But when Rose::DB->new is called and there is currently an active > transation, the code in init_dbh will reset AutoCommit to 0. Perhaps connect_cac

Re: [RDBO] How to register a db using DBI::Proxy?

2007-08-09 Thread Tim Bunce
On Thu, Aug 09, 2007 at 07:42:36AM -0400, John Siracusa wrote: > On 8/9/07 6:13 AM, Michael Lackhoff wrote: > > I get this error message: > > Attempt to change driver from 'oracle' to 'proxy' detected. The driver > > cannot be changed after object creation. at test02.pl line 8 > > > > Is it possi

Re: [RDBO] dbh caching

2007-04-16 Thread Tim Bunce
On Fri, Apr 13, 2007 at 02:28:59PM -0400, Perrin Harkins wrote: > On 4/13/07, Bill Moseley <[EMAIL PROTECTED]> wrote: > > So, for example, in Catalyst in an end() (or something at the end) you > > would look for errors and then do a rollback, otherwise commit? And > > you look at AutoCommit to see

Re: [RDBO] Read-only objects

2007-04-05 Thread Tim Bunce
On Wed, Apr 04, 2007 at 09:20:30AM -0700, Randal L. Schwartz wrote: > > Here's what I did for my readonly class, based on discussions with jcs > six months ago: > > sub insert { > die "cannot insert" unless our $READWRITE; > goto &{$_[0]->can("SUPER::insert")}; > } Hi Randal.

Re: [RDBO] client out of memory with large table

2007-01-07 Thread Tim Bunce
On Sat, Jan 06, 2007 at 12:04:26AM -0500, Perrin Harkins wrote: > John Siracusa wrote: > > Finally, if you only want to turn this on for particular calls, remember > > that the db is an optional argument to all Manager methods. You can always > > make/get a $db, yank out the $dbh, set the attribut

Re: [RDBO] client out of memory with large table

2007-01-07 Thread Tim Bunce
On Fri, Jan 05, 2007 at 08:26:21PM -0500, Perrin Harkins wrote: > Neal Clark wrote: > > Ideally, I will be making iterators from SQL calls. The SQL will > > limit the number of rows as best as I can, but there will be times I > > need to iterate over every row. I read in one of the CPAN docs th

Re: [RDBO] datetime oddness

2006-12-30 Thread Tim Bunce
On Tue, Dec 26, 2006 at 09:28:50AM -0800, Dan Wierenga wrote: > Whoops, sorry all, that was meant to be a private reply to Tim. My fault. My original was meant for Dan. Sorry. Tim. > Dan Wierenga wrote: > > I'm looking at having the Corporate Systems codebase use it. > &

Re: [RDBO] datetime oddness

2006-12-22 Thread Tim Bunce
Hi Dan. Is VC using RDBO? Tim. On Thu, Dec 21, 2006 at 03:45:25PM -0800, Dan Wierenga wrote: > When I retrieve a datetime field from a mysql database, it gets a "T" > stuck in between the date and time fields of the return value (for > "Time", I assume). Is there a way to suppress this and ha