Greetings, all.
When I use ActiveRecord within JRuby, and I access an Oracle 10g date field
(which include time in Oracle - it's really a DATETIME), the object
ActiveRecord gives me is a Date object, not a Time. As such, the time is
lost, so all I get is a truncated date w/o time.
When I access these same fields in a normal Ruby/ActiveRecord interpreter
environment, I get a Time object as expected.
I've searched for this issue and have not found a fix (though, this seems
closely related:
http://www.nabble.com/-jira--Created%3A-%28JRUBY-1217%29-Date-columns-ending-in-_at-returning-Jan-01%2C-2000-on-Oracle-to11675146.html#a11675146).
Any help would be greatly appreciated! The code below shows what I'm seeing:
-- Sample code that illustrates my problem
class EtlParm < ActiveRecord::Base
end
parm = EtlParm.find_by_parm_name('abc_parm')
x = parm.value_date
puts "x.class: #{x.class}"
puts "x.inspect: #{x.inspect}"
-- [JRuby] Output
>> x.class: Date
>> x.inspect: Sun, 01 Jan 2006
-- [Ruby] Output
>> x.class: Time
>> x.inspect: Sun, 01 Jan 2006 17:53:54
Here is what my environment looks like:
ruby 1.8.5 (2007-11-01 rev 4810) [x86-jruby1.0.2]
JRuby gem version: 0.9.4
JRuby gems (local):
activerecord (2.0.1)
Implements the ActiveRecord pattern for ORM.
ActiveRecord-JDBC (0.5)
JDBC adapter for ActiveRecord, for use within JRuby on Rails.
activeresource (2.0.1)
Think Active Record for web resources.
activesupport (2.0.1)
Support and utility classes used by the Rails framework.
ar-extensions (0.7.0)
Extends ActiveRecord functionality.
--
View this message in context:
http://www.nabble.com/Oracle-dates-%28w--time%29-interpreted-by-ActiveRecord-as-Date-objects%2C-not-Time-tp16628183p16628183.html
Sent from the JRuby - Dev mailing list archive at Nabble.com.
-
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email