Oracle - Error mapping DATE objects when using 11g Driver against a 10g
database.
---------------------------------------------------------------------------------
Key: JRUBY-1634
URL: http://jira.codehaus.org/browse/JRUBY-1634
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Affects Versions: JRuby 1.1b1
Environment: JRuby 1.1b1
Rails 1.2.6
ActiveRecord-JDBC (v0.5 and v0.6)
Oracle 10.2.0.3.0
Oracle JDBC Driver 11.1.0.6.0-Production
Reporter: Daniel Wintschel
Priority: Minor
Attachments: patch.txt
When using Oracle's 11g driver against a 10g database - activerecord-jdbc has
problems mapping "DATE" columns.
I've included a patch as an attachment that was written by Nick Sieger and
tested by myself. The patch did indeed resolve the issue.
Stacktrace as follows:
>> a = Address.find( 6208 )
RuntimeError: The driver encountered an error: unable to choose type for date
from:
["DATE", "DATE"]
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.6/lib/active_record/connection_adapters/jdbc_adapter.rb:286:in
`initialize'
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.6/lib/active_record/connection_adapters/jdbc_adapter.rb:41:in
`new'
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.6/lib/active_record/connection_adapters/jdbc_adapter.rb:41:in
`jdbc_connection'
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in
`connection='
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/query_cache.rb:54:in
`connection='
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in
`retrieve_connection'
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
`connection'
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1023:in
`find_one'
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1014:in
`find_from_ids'
from
/Users/daniel/Bin/jruby-1.1b1/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:419:in
`find'
from (irb):1:in `binding'
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
