RE: DBIx::Recordset and Oracle

On Tue, 2005-07-26 at 10:45 -0600, Reidy, Ron wrote:
> What takes so long for you? What query is being executed and what are the DB waits generated? Are you getting SYS owned objects as described in that old posting?
>

Yes indeed I am getting SYS owned objects as described in the old
posting. The problem seems to be that the user which runs the script
does not have any permissions on the SYS tables.

It takes more than 120 seconds seconds before the script returns with
values, BUT, if I use DBD::JDBC in stead of DBD::Oracle, the script
throws an immediate error:

[Tue Jul 26 17:04:31 2005] unimported.cgi:
DBIx::Database::Base::savecroak('DBIx::Recordset=HASH(0xcb085c)','Cannot
list tables for hostname=xxx;port=xxx;url=jdbc:or...') called at xxx
line xxx




> -----Original Message-----
> From: Tielman de Villiers [mailto:tvilliers@xxxxxxxxx]
> Sent: Tuesday, July 26, 2005 10:40 AM
> To: dbi-users@xxxxxxxx
> Subject: DBIx::Recordset and Oracle
>
>
>
> I have the same problem as described here:
> http://www.nntp.perl.org/group/perl.dbi.users/7343
> (searching from Oracle databases take extremely long because
> DBIx::Recordset tries to get metadata for all tables), even though
> I use modern versions of DBIX::Recordset (0.26), the
> DBI(1.40) and perl (5.8.0).
>
> I have tried to set '!TableFilter' with the same values I feed to
> '!Tables', but without luck. As a temporary measure I have changed #342
> in DBIx/Database.pm to
> "
> my $ListTables = 0; ##DBIx::Compat::GetItem ($drv, 'ListTables') ;
> "
> which is not ideal, but works.
>
> Any other suggestions?
>

.

Relevant Pages

  • Re: Flushing standard input
    ... import sys ... While the script is sleeping I type in the word 'test1', ... Todo lo que querías saber, y lo que ni imaginabas, ...
    (comp.lang.python)
  • Re: Bash numerical base conversion
    ... Works like a flash now. ... Here is the fast version using printf ... sys 0m0.226s ... Another fast method would be to use the slow script once ...
    (comp.unix.shell)
  • Re: Need help correcting this Bash function
    ... > How on earth can you know that, he pasted one function from his script. ... > sys 0m2.366s ... _especially_ as this script is a bash script. ... only modern POSIX shells. ...
    (comp.unix.shell)
  • Re: Use sed to modify a line in a file, *without* duplicating the ?file
    ... script front, or there are too many Ed's out ... an assignment of some value that I choose. ... sys 0m19.050s ... the substitution fails on every addressed line", ...
    (comp.unix.shell)
  • Re: package search
    ... one with the submodule mod1 ... import sys ... while the same script with the two ... append-lines interchanged will not: ...
    (comp.lang.python)