Support Requests: Browse | Submit New | Admin

[#9330] Error connecting to a MSSqlServer database in a rails app.

Date:
2007-03-17 00:03
Priority:
3
Submitted By:
Nobody
Assigned To:
Nobody (None)
Category:
None
State:
Open
Summary:
Error connecting to a MSSqlServer database in a rails app.

Detailed description
I just tried jruby with an app we have going against a MSSQLServer database. Got this error -

The driver encounter an error: unable to choose type from: [[“bit”, {“nullable”=>1, “numprecradix”=>nil,
“localtypename”=>”bit”, ...] for date

Looks like it is choking on a date field.

I worked around this by making changes to jdbc_adapter.rb in the methods choose_best_types and choose_type.

But now I am getting the following error - 

undefined method `select_all' for #<ActiveRecord::ConnectionAdapters::JdbcConnection:0x1e481c1 ....

Any help appreciated.
Thanks.

Add A Comment: Notepad

Please login


Followup

Message
Date: 2007-03-19 05:03
Sender: Ryan Bell

Could you report this as a bug. It looks like we are not mapping
date fields in MySQL correctly.

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

No Changes Have Been Made to This Item