[Dbix-class] Catalyst Application : DBIx::Class : Oracle 8 : JOIN problem

Peter Rabbitson rabbit+dbic at rabbit.us
Thu Nov 24 11:16:43 GMT 2011

Rohan M wrote:
> Dear All,
>  I'm using Oracle 8i as a back-end database server for my Catalyst 
> application. When I try to use join parameter using DBIx::Class model, 
> it gives me syntax error.
> It doesn't understand 'JOIN' keyword in the SQL generated by DBIx::Class.
> for example - >
> my $Info = $c->model('App::Log')->search({
> id => $someid,
> },{
> join => 'foreignkey_id',
> });
> I did checked 
> "http://search.cpan.org/~frew/DBIx-Class-0.08115/lib/DBIx/Class/Storage/DBI/Oracle/WhereJoins.pm" 
>  where it is mentioned that DBIx::Class automatically detects the 
> version and calls the above class to generate the JOIN in oracle 8i 
> fashion but somehow its not working.
> Also I checked for join_type parameter which allows you to go for 
> 'outer' or 'inner' join but it didn't work.
> Could some body tell me how can I use join for oracle 8i using 
> DBIx::Class model in the Catalyst application?

Sorry for the untimely reply - I am looking over old unanswered
messages on the ML. Was your problem eventually resolved, or is
it still present?

More information about the DBIx-Class mailing list