尝试连接到 sybase 但解析为 mssql 适配器

发布于 2024-12-03 20:11:11 字数 650 浏览 1 评论 0原文

require 'rubygems'
require 'jdbc/jtds'
require 'activerecord-jdbc-adapter'
config = {
  :username => 'me',
  :password => 'mypass',
  :adapter => 'jdbc',
  :driver => 'net.sourceforge.jtds.jdbc.Driver',
  :url => 'jdbc:jtds:sybase://myserver:1234/mydb'
}
ActiveRecord::Base.establish_connection( config )
ActiveRecord::Base.connection.class
#  => ActiveRecord::ConnectionAdapters::MssqlJdbcConnection

我意识到 MSSQL 和 Sybase 具有共享的历史记录，但我在连接到 Sybase 时获得此适配器是否正确？

我的问题是类型没有正确映射到 ruby 类型。例如浮点数和小数被转换为字符串。

宝石：

activerecord-jdbc-adapter 1.1.3
jdbc-jtds 1.2.5

原文

require 'rubygems'
require 'jdbc/jtds'
require 'activerecord-jdbc-adapter'
config = {
  :username => 'me',
  :password => 'mypass',
  :adapter => 'jdbc',
  :driver => 'net.sourceforge.jtds.jdbc.Driver',
  :url => 'jdbc:jtds:sybase://myserver:1234/mydb'
}
ActiveRecord::Base.establish_connection( config )
ActiveRecord::Base.connection.class
#  => ActiveRecord::ConnectionAdapters::MssqlJdbcConnection

I realise that MSSQL and Sybase have a shared history, but is it correct that I get this adapter when connecting to Sybase?

My problem is that types are not being mapped to ruby type correctly. e.g. floats and, decimals are being translated to String.

Gems: