ActiveRecord JDBC: General Discussion: Error with JTDS and Sybase

Downloads
» Downloads
Message Forums
» General Discussion
Issue Tracking
» JIRA
Mailing Lists
Source Code Repositories
» Main
» Mirror (Github)
Wikis
» Wiki

ActiveRecord JDBC is a subproject of JRuby, was started in July 2008, is owned by Nick Sieger, and has 64 members.

» Join This Project

Error with JTDS and Sybase

» Back to forum topics

3 posts

Replies: 2 - Last Post: June 04, 2009 18:37
by: rrouse

« Older Topic » Newer Topic

showing 1 - 3 of 3

rrouse

Posted: June 03, 2009 15:29 by rrouse

» Permalink

Hello, I'm trying to query a Sybase 11 database. When I do so, I get the following error. Is there something that is misconfigured on my side for this to work or does this not really involve activerecord-jdbc-adapter?

RuntimeError: The driver encountered an error: unable to choose type for date from:
["Date_Type", "datetime"]
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:330:in `initialize'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:457:in `initialize'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:53:in `jdbc_connection'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `new_connection'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in `checkout'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'
from /opt/jruby/lib/ruby/1.8/monitor.rb:191:in `mon_synchronize'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in `connection'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:3103:in `quoted_table_name'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1689:in `construct_finder_sql'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1553:in `find_every'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1510:in `find_initial'
from /opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:613:in `find'

Nick Sieger	Posted: June 03, 2009 23:13 by Nick Sieger » Permalink
	Hi, looks like it could be a bug or unexpected data type coming from Sybase. Would you mind filing a bug over at http://kenai.com/jira/browse/ACTIVERECORD_JDBC ? Could use your help in resolving it because none of the team has Sybase experience. Cheers, /Nick

rrouse	Posted: June 04, 2009 18:37 by rrouse » Permalink
	Hello, I have filed a bug report. I'll be happy to assist in any way I can. If you can give me an idea of where the data types are specified in your code, I'll start playing around with my install to see if I can get it to query correctly.

Replies: 2 - Last Post: June 04, 2009 18:37
by: rrouse

« Older Topic » Newer Topic