Hi,
>
> I'm testing Recordset under mod_perl. In my startup.pl which I PerlRequire
> in httpd.conf I initialize an Oracle connection using
> Apache::DBI->connect_on_init.
>
> Could you give an example of how I tell Recordset to use the cached and
open
> connection?
>
DBIx::Recordset will automaticly use the connection set up by
connect_on_init, as long as you give the same DSN, username and password
(and attributes if any). There is no difference between normal DBI and
DBIx::Recordset. The !KeepOpen parameter of the DBIx::Database new method,
is intented for situation where you don't use Apache::DBI (i.e. outside
mod_perl).
The other thing are the metainfomations that DBIx::Recordset gathers about
the Database. You can create a DBIx::Database object in your startup.pl,
that will retrive the metadata and store it for later use. You can use the
!SaveAs parameter to store this DBIx::Database object and retrive it later
to use it as !DataSource for setting up new recordset objects.
Gerald
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
