On Wed, Feb 11, 2009 at 1:47 PM, Karl Forner wrote:
I believe I fixed the problem (cf my post "bug found in and tentatively
fixed in DBIx::Class::Schema::Loader::DBI::Oracle::_tables_list" in the dbix
mailing list").

Here's a copy :
We had a problem because DBIx::Class::Schema::Loader did not get the
column_info for our Oracle database : no data_types, is_nullable, default
etc.. attributes were set.
We traced the problem down to DBIx::Class::Schema::Loader::
DBI::Oracle::_tables_list, that changed the table names to lowercase.

So just commenting the line 69 : $table = lc $table;
seems to fix the problem.

The test is either to call the _tables_list and check the table names,
or to create a schema on a n oracle db using
DBIx::Class::Schema::Loader::make_schema_at, and to check that the generated
DBIx::Class objects have
the column attributes such as data_type, default_value , is_nullable ,
size etc...

Here are some details:
DBIx::Class::Schema::Loader $VERSION = '0.04004'
perl, v5.8.8 built for i486-linux-gnu-thread-multi

--- Oracle.pm 2009-02-11 13:35:08.000000000 +0100
+++ Oracle.pm.fixed 2009-02-11 13:35:04.000000000 +0100
@@ -66,7 +66,7 @@
$table =~ s/\w+\.//;

next if $table eq 'PLAN_TABLE';
- $table = lc $table;
+ # $table = lc $table; # removed by kf
Hmm - it was just the first version of that code that I worken on -
but I remember that there some problems when the metadata was saved
under a hash key different from the table name, because it is referred
in other places. Not that I am sure it applies here - but this might
be something you should check.

Search Discussions

Discussion Posts


Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 4 | next ›
Discussion Overview
groupcatalyst @
categoriescatalyst, perl
postedFeb 6, '09 at 5:10p
activeFeb 12, '09 at 9:42a



site design / logo © 2021 Grokbase