Skip Menu |

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

Report information
The Basics
Id: 80431
Status: open
Priority: 0/
Queue: DBIx-Class

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

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)



Subject: request for creating a new DBIx::Class:Storage driver for Oracle ODBC
Greetings, I started a new project with DBI Class. Since installing DBD::Oracle in Windows is really painful, I decided to use ODBC to access the database (performance is not a real issue right now). As soon as I finished my manual configuration of DBIx::Class::Schema subclass and the respective ResultSet, I got the error message while running the program: Expected driver 'DBIx::Class::Storage::DBI::ODBC::Oracle' not found, using generic support. Please file an RT. DBIx::Class::ResultSet::find(): Your storage class (DBIx::Class::Storage::DBI::ODBC) 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::ODBC' . at categorizer.pl line 55 So here I am. I'm not sure if I'm supplying all necessary information. I could not find any reference about how to limit the returned rows with ODBC and supply that to the limit_dialect parameter. Please let me know if you need more information.
Sorry for taking a while. Please install DBIC 0.08203_02 [1] and re-run your program. You will get some output you need to add to this ticket. Once this is done, support will most likely show up in 0.08204. Cheers! [1] http://cpan.metacpan.org/authors/id/R/RI/RIBASUSHI/DBIx-Class-0.08203_02.tar.gz
Ping on this? DBIC 0.08204 is now available which prints the same necessary information when throwing an exception. Please provide it so we can implement things properly. Cheers
Stalling, as no reply from original reporter :(
RT-Send-CC: glasswalk3r [...] yahoo.com.br
On Mon Dec 03 09:04:59 2012, RIBASUSHI wrote: Show quoted text
> Stalling, as no reply from original reporter :(
I'm sorry for that. For some reason, RT didn't send me an e-mail for each update in this ticket. I just upgraded to the new version of DBIC and got the information required (please check the attachment). Please let me know if you need more help. Regards, Alceu
Subject: DBIC-0.08204.txt
DBIx::Class::ResultSet::next(): This version of DBIC does not yet seem to supply a driver for your particular RDBMS and/or connection method ('ODBC/Oracle'). While we will attemptto continue anyway, the results are likely to be underwhelming. Please upgrade DBIC, and if this message does not go away, file a bugreport including the following info: { DBIC_DRIVER => "DBIx::Class::Storage::DBI::ODBC", DBIC_DSN => "dbi:ODBC:AIA", DBIC_VER => "0.08204", DBI_VER => "1.622", SQL_CURSOR_COMMIT_BEHAVIOR => "2 (SQL_CB_PRESERVE)", SQL_CURSOR_ROLLBACK_BEHAVIOR => "2 (SQL_CB_PRESERVE)", SQL_CURSOR_SENSITIVITY => "1 (SQL_INSENSITIVE)", SQL_DATA_SOURCE_NAME => "AIA", SQL_DBMS_NAME => "Oracle", SQL_DBMS_VER => "11.02.0020", SQL_DEFAULT_TXN_ISOLATION => "2 (SQL_TXN_READ_COMMITTED)", SQL_DM_VER => "03.80.7601.0000", SQL_DRIVER_NAME => "SQORA32.DLL", SQL_DRIVER_ODBC_VER => "03.52", SQL_DRIVER_VER => "11.02.0003", SQL_EXPRESSIONS_IN_ORDERBY => "Y", SQL_GROUP_BY => "2 (SQL_GB_GROUP_BY_CONTAINS_SELECT)", SQL_IDENTIFIER_CASE => "1 (SQL_IC_UPPER)", SQL_IDENTIFIER_QUOTE_CHAR => "\"", SQL_MAX_CATALOG_NAME_LEN => 0, SQL_MAX_COLUMN_NAME_LEN => 30, SQL_MAX_IDENTIFIER_LEN => 30, SQL_MAX_TABLE_NAME_LEN => 30, SQL_MULTIPLE_ACTIVE_TXN => "Y", SQL_MULT_RESULT_SETS => "Y", SQL_NEED_LONG_DATA_LEN => "N", SQL_NON_NULLABLE_COLUMNS => "1 (SQL_NNC_NON_NULL)", SQL_ODBC_VER => "03.80.0000", SQL_QUALIFIER_NAME_SEPARATOR => "\@", SQL_QUOTED_IDENTIFIER_CASE => "3 (SQL_IC_SENSITIVE)", SQL_TXN_CAPABLE => "3 (SQL_TC_DDL_COMMIT)", SQL_TXN_ISOLATION_OPTION => "0x0000000A (SQL_TXN_READ_COMMITTED SQL_TXN_SERIALIZABLE)" } DBIx::Class::ResultSet::next(): Your storage class (DBIx::Class::Storage::DBI::ODBC) 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::ODBC' . at C:\Users\slh2170\Documents\Simplify-Siebel\revisÒo siebel\arquitetura\erros EAI\categorizer.pl line 75
RT-Send-CC: glasswalk3r [...] yahoo.com.br
On Fri Dec 07 12:52:57 2012, ARFREITAS wrote: Show quoted text
> On Mon Dec 03 09:04:59 2012, RIBASUSHI wrote:
> > Stalling, as no reply from original reporter :(
> > I'm sorry for that. For some reason, RT didn't send me an e-mail for > each update in this ticket.
Sorry for dropping this on the floor, I am about to look into it again this evening.
Gah, time keeps running short for this one (the issue is that the current oracle tests need reorganization, and I can't seem to find time for it). Would you like a short-term, untested workaround for this in patch-form or you are set for the time being? Cheers
Em Sex Jan 25 09:30:46 2013, RIBASUSHI escreveu: Show quoted text
> Gah, time keeps running short for this one (the issue is that the > current oracle tests need reorganization, and I can't seem to find time > for it). Would you like a short-term, untested workaround for this in > patch-form or you are set for the time being? > > Cheers
I'm OK for the time being, so I believe a full solution is preferable. What needs to be done with the Oracle tests? Maybe I could lend a hand.