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)



Subject: Oracle failed connection and sql_limit_dialect error message
Download (untitled) / with headers
text/plain 729b
(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
Download (untitled) / with headers
text/plain 266b
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>


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.