Hi Max,
I did some more investigation and found that there is an alternative
to Oracle's adapter made by Raimonds Simanovskis. He calls it
'enhanced' adapter (http://blog.rayapps.com/2008/05/13/activerecord-
oracle-enhanced-adapter/). Just curious about it I read what it was
about and decided to give it a try.
Check out the differences in the INSERT statements that both adapters
generate for date values out of ruby objects (no code changes). Again,
this is out of development.log:
Oracle's: INSERT…'2011-01-01', …, '2011-01-01', …, '2009-12-30
12:01:26', …, '1995-01-01', …, '2009-12-30 12:01:26', …
enhanced's: INSERT…TO_DATE('2011-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'), …, TO_DATE('2011-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'), …, TO_DATE('2009-12-30 00:00:00','YYYY-MM-DD
HH24:MI:SS'), …, TO_DATE('1995-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'), …, TO_DATE('2009-12-30 00:00:00','YYYY-MM-DD
HH24:MI:SS'), …
Since I changed the adapter I have had no problems.
Thanks for your help, though.
On Dec 30, 10:57 am, Max Williams <[email protected]> wrote:
> Ok, can you post up the rails code in question then?
> --
> Posted viahttp://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
