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.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs