Rails - Jun 2006 - Rails and Oracle

I have a potential client who is interested in employing
my services to Web 2.0 their Web 1.0 perl+oracle app.
I''ve only used rails with MySql so far.
Are their any gotchas I should be aware of?
Guy

> I have a potential client who is interested in employing
> my services to Web 2.0 their Web 1.0 perl+oracle app.
> I''ve only used rails with MySql so far.
> Are their any gotchas I should be aware of?
http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/OracleAdapter.html

There''s also some minors issues in edge, watch them to
dev.rubyonrails.com

Ciao''

On Thu, 2006-06-22 at 18:21 -0700, Guy Argo wrote:
> I have a potential client who is interested in employing
> my services to Web 2.0 their Web 1.0 perl+oracle app.
> I''ve only used rails with MySql so far.
> Are their any gotchas I should be aware of?
> Guy
I''ve been using Rails with a legacy oracle db. Some date columns in
there have ''sysdate'' (=current date/time) as default value.

When these columns get dumped (using rake db:schema:dump or any of the
other functions that depend on this) the output looks as follows:

t.column "cleared", :datetime, :default => #<Date:
4903089/2,0,2299161>, :null => false

which is an invalid format to any task that tries to load this schema
back (in eg a test db). Since I bumped into this issue when first
experimenting with testing and wasn''t able to find a decent solution
and
under a lot of time-pressure, I neglected writing any tests so far
(which I''ll regret some day, I know).

Any suggestions on how to resolve this would be greatly appreciated!

Piet.