Hi Marc, This worked like a charm. Perfect . A skype style - (bow)
Thanks a lot, Hey Jorge, don't mention it.. At least you looked into it and showed helping hand... Thanks for that... Regards, Rohan On Mon, May 30, 2011 at 3:49 PM, Marc Logghe <[email protected]> wrote: > Does this help ? > > > <http://search.cpan.org/~frew/DBIx-Class-0.08192/lib/DBIx/Class/Storage/DBI/Oracle.pm> > > To force usage of this version no matter the database version, add > > __PACKAGE__->storage_type('::DBI::Oracle::WhereJoins'); > > to your Schema class. > > http://search.cpan.org/~frew/DBIx-Class-0.08192/lib/DBIx/Class/Storage/DBI/Oracle.pm > > Regards, > Marc > > > On Mon, May 30, 2011 at 11:54 AM, Rohan M <[email protected]> wrote: > >> Hey Jorge, >> >> Yes. The join parameter is the name of DBIx::Class relation to the >> foreign table and I'm using the relation name not the foreign key name. So >> that's not a problem. >> >> Yes I'm using DBIC_TRACE and I see following output in my Catalyst app >> console. >> >> DBI Exception: DBD::Oracle::db prepare_cached failed: ORA-00933: SQL >> command not properly ended (DBD ERROR: error possibly near <*> indicator at >> char .... >> >> SELECT me.logid, me.status, me.timedetails, employee.id, employee.name, >> employee.phone, employee.email FROM PGx_LOG me <*>JOIN employee employee ON >> employee.userid = me.id WHERE ( someotherid = ? ) >> >> If I try to use the same query directly on sql prompt there also I get the >> same error. >> >> I checked for the Oracle 8i sql statements - >> http://oreilly.com/catalog/orsqlpluspr2/chapter/ch01.html >> >> http://www.dba-oracle.com/art_sql_iso_99.htm >> >> This tells you that Oracle 8i does not support such syntax. >> >> " >> http://search.cpan.org/~frew/DBIx-Class-0.08115/lib/DBIx/Class/Storage/DBI/Oracle/WhereJoins.pm"; >> >> >> Also, the above link tells that the joins are differently handled by for >> Oracle 8i. >> >> Please let me know if I'm doing something wrong. >> >> Regards, >> Rohan >> <http://oreilly.com/catalog/orsqlpluspr2/chapter/ch01.html> >> On Mon, May 30, 2011 at 1:00 PM, Jorge Gonzalez <[email protected] >> > wrote: >> >>> The argument to 'join' parameter must be the name of the DBIx::Class >>> relation to the foreign table, not the foreign key name. In some cases >>> (autogenerated schema with DBix::Class::Schema::Loader) they will be the >>> same, but in other cases (i.e. when you build the schema by hand), this >>> might not necessarily be the case. >>> >>> Have you checked this? >>> >>> Have you executed your script with DBIC_TRACE=1 to see the exact SQL >>> which is being generated? >>> >>> Can you post the exact error message that Oracle gives you? It's quite >>> clear that Oracle _does_ understand the JOIN syntax since..... well, >>> forever. >>> >>> Cheers >>> J. >>> >>> >>> *Jorge González Villalonga* >>> Director Técnico >>> >>> *DAIKON Integración y Desarrollo S.L.* >>> Telf: (+34) 91 188 08 28 >>> Fax: (+34) 91 632 65 42 >>> *www.daikon.es* >>> >>> El 29/05/11 19:45, Rohan M escribió: >>> >>> 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? >>> >>> >>> Thanks and regards, >>> Rohan >>> >>> >>> >>> >>> >>> _______________________________________________ >>> List: [email protected] >>> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst >>> Searchable archive: http://www.mail-archive.com/[email protected]/ >>> Dev site: http://dev.catalyst.perl.org/ >>> >>> >>> _______________________________________________ >>> List: [email protected] >>> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst >>> Searchable archive: >>> http://www.mail-archive.com/[email protected]/ >>> Dev site: http://dev.catalyst.perl.org/ >>> >>> >> >> >> >> _______________________________________________ >> List: [email protected] >> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst >> Searchable archive: >> http://www.mail-archive.com/[email protected]/ >> Dev site: http://dev.catalyst.perl.org/ >> >> > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > >
<<logo-daikon-email.png>>
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
