Re: [PhillyOnRails] Ruby/Rails and Oracle

[trisberg@tridb.com]

It's not so much a driver issue as an issue of the SQL your OR mapper
generates.  They could have created an Oracle 8i dialect for Active
Record, if that is possible.  The issue is that 8i does not support the
ANSI join syntax as in this example:

9i syntax (ANSI):

SELECT pub_name, title
FROM publishers
INNER JOIN titles ON publishers.pub_id = titles.pub_id

You would have to rewrite it like this:

8i syntax:

SELECT pub_name, title
FROM publishers, titles
where publishers.pub_id = titles.pub_id


Thomas


> One of Obie's colleagues stated that since the db they were using
> didn't support joins the way active record did them (I think that is
> what he was saying), that they had to write the sql for all of their
> queries. I was wondering if there was a reason why they didn't make
> their own db "driver" and open source it?
>
> --
> Randy Schmidt
> x@altorg.com
> 267.334.6833
> _______________________________________________
> talk mailing list
> talk@phillyonrails.org
> http://lists.phillyonrails.org/mailman/listinfo/talk
>

_______________________________________________
talk mailing list
talk@phillyonrails.org
http://lists.phillyonrails.org/mailman/listinfo/talk