RE: Persistent connection

2000-04-10 Thread Gerald Richter
> > I have two concerns though. Can I use the same connection for > _both_ DBI and > DBIx ? Yes, you can retrieve the database handle via the method DBHdl from any Recordset or Database object. > The other question is that my script is short-lived, with only > one transaction > per instance. I w

RE: Persistent connection

2000-04-10 Thread Kaare Rasmussen
> When running under mod_perl use Apache::DBI. Also you can create one > DBIx::Database object at the start of your script and specify the !KeepOpen > flag. Afterwards you give this Database object as !DataSource when you > create a new Recordset object, or retrive the database handle via the meth

RE: Persistent connection

2000-04-09 Thread Gerald Richter
> I'm testing different aspects of embperl and modperl programming > for a project > I have. > > One of these aspects is database programming. I like the DBIx::Recordset > approach to get several items, but for complex updates and single-value > selects, DBI seems better. > > Well, my questions is

Persistent connection

2000-04-09 Thread Kaare Rasmussen
I'm testing different aspects of embperl and modperl programming for a project I have. One of these aspects is database programming. I like the DBIx::Recordset approach to get several items, but for complex updates and single-value selects, DBI seems better. Well, my questions is how I will make