Skip Menu |

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 128425
Status: new
Priority: 0/
Queue: DBIx-Class
People
Owner: Nobody in particular
Requestors: DUFFEE [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Unimportant
Broken in: 0.082841
Fixed in: (no value)

History Show all quoted text
  Tue Feb 05 11:41:05 2019 DUFFEE [...] cpan.org - Ticket created
Subject: Oracle failed connection and sql_limit_dialect error message
(Filing RT ticket as requested) Received this message when actual error from dbic_trace was "DBI Connection failed" DBIx::Class::Storage::DBI::sql_maker(): Your storage class (DBIx::Class::Storage::DBI::Oracle) does not set sql_limit_dialect and you have not supplied an explicit limit_dialect in your connection_info. DBIC will attempt to use the GenericSubQ dialect, which works on most databases but can be (and often is) painfully slow. Please file an RT ticket against 'DBIx::Class::Storage::DBI::Oracle' Programmer error (forgot to set ORACLE_HOME before running the code, so install_driver(Oracle) failed), but error feels misleading. DBIx::Class 0.082841, DBD::Oracle 1.76, Oracle 12c release 2, perl 5.16.3 on CentOS7
  Tue Feb 05 12:01:14 2019 DUFFEE [...] cpan.org - Correspondence added
On Tue Feb 05 11:41:05 2019, DUFFEE wrote: Show quoted text
> DBIx::Class::Storage::DBI::sql_maker(): Your storage class > (DBIx::Class::Storage::DBI::Oracle) does not set sql_limit_dialect
Solution: programmer should have called $schema->storage->ensure_connected in code <doh>