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] DateTime columns

2007-08-09 Thread John Siracusa
On 8/9/07 6:48 AM, Alex Burzyński wrote: > What I'd like to get is when setting value of a date/* columns get it > stored in database server time_zone - so queries in mysql returns what > human reader would expect. You can do this by setting server_time_zone() on the db object: http://www.mail-ar

[RDBO] DateTime columns

2007-08-09 Thread Alex Burzyński
Hi I've got couple of problems with using date/datetime/timestamp/epoch columns. MySQL database is set to use time_zone = SYSTEM, which is BST $ date Thu Aug 9 09:58:59 BST 2007 $ perl -MDateTime -le 'print DateTime->now(time_zone => "local")->time_zone->name' Europe/London What I'd like

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

2007-08-09 Thread John Siracusa
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 possible to persuade Rose::DB that the 'proxy' still is 'oracle' I'll make the

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

2007-08-09 Thread Michael Lackhoff
Hello, I am trying to use Rose::DB for a new project that uses an Oracle database but the connection is done with DBI::Proxy (then I don't have to install DBD::Oracle on every machine that accesses the database) After reading the docs the best I could manage was this: My::DB->register_db( dom