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

Report information
The Basics
Id:
128425
Status:
new
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
DUFFEE [...] cpan.org
Cc:
AdminCc:

BugTracker
Severity:
Unimportant
Broken in:
0.082841
Fixed in:
(no value)



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
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 runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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