Hi,
Using jTDS MsSql 2000 driver I get an unable to choos type error - similar to the ones for decimal but for date. I should
note that there are some user defined data types  in the database for example:
    pc_datetime dbo smalldatetime 4 0
=========== Here is the dump ==========
C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/ActiveRecord-JDBC-0.2.3/lib/active_record/connection
_adapters/jdbc_adapter.rb:196:in `initialize': The driver encounter an error: unable to choose type from: [["bit",
{"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>0,
"precision"=>1, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"bit", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"bit", "data_type"=>-7, "sql_data_type"=>-7,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["tinyint", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>10,
"precision"=>3, "unsigned_attribute"=>1, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"tinyint", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"tinyint", "data_type"=>-6, "sql_data_type"=>-6,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["tiny_seq_key", {"sql_datetime_sub"=>0, "nullable"=>0,
"num_prec_radix"=>10, "precision"=>3, "unsigned_attribute"=>1,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"tiny_seq_key",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"tiny_seq_key", "data_type"=>-6,
"sql_data_type"=>-6, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["tinyint identity", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>10, "precision"=>3,
"unsigned_attribute"=>1, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"tinyint identity", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"tinyint identity", "data_type"=>-6, "sql_data_type"=>-6,
"auto_increment"=>1, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["bigint", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>10,
"precision"=>19, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"bigint", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"bigint", "data_type"=>-5, "sql_data_type"=>-5,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["bigint
identity", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>10,
"precision"=>19, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"bigint identity",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"bigint identity", "data_type"=>-5,
"sql_data_type"=>-5, "auto_increment"=>1, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["varbinary", {"sql_datetime_sub"=>0,
"nullable"=>1, "num_prec_radix"=>0, "precision"=>8000,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"varbinary", "literal_prefix"=>"0x",
"minimum_scale"=>0, "create_params"=>"max length", "searchable"=>2,
"type_name"=>"varbinary", "data_type"=>-3, "sql_data_type"=>-3,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["binary", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>0,
"precision"=>8000, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"binary",
"literal_prefix"=>"0x", "minimum_scale"=>0,
"create_params"=>"length", "searchable"=>2, "type_name"=>"binary",
"data_type"=>-2, "sql_data_type"=>-2, "auto_increment"=>0,
"fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["timestamp",
{"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>8, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"timestamp",
"literal_prefix"=>"0x", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"timestamp", "data_type"=>-2,
"sql_data_type"=>-2, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["char", {"sql_datetime_sub"=>0, "nullable"=>1,
"num_prec_radix"=>0, "precision"=>8000, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>1, "local_type_name"=>"char",
"literal_prefix"=>"'", "minimum_scale"=>0,
"create_params"=>"length", "searchable"=>3, "type_name"=>"char",
"data_type"=>1, "sql_data_type"=>1, "auto_increment"=>0,
"fixed_prec_scale"=>0, "literal_suffix"=>"'"}], ["n_flag",
{"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>1, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"n_flag",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"n_flag", "data_type"=>1,
"sql_data_type"=>1, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["pc_byte_ind", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>1,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"pc_byte_ind", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"pc_byte_ind", "data_type"=>1, "sql_data_type"=>1,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["pc_category", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>3, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"pc_category",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"pc_category", "data_type"=>1,
"sql_data_type"=>1, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["pc_division", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>3,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"pc_division", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"pc_division", "data_type"=>1, "sql_data_type"=>1,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["pc_facility_cd", {"sql_datetime_sub"=>0, "nullable"=>0,
"num_prec_radix"=>0, "precision"=>3, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"pc_facility_cd", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"pc_facility_cd", "data_type"=>1, "sql_data_type"=>1,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["pc_type_code", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>2, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"pc_type_code",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"pc_type_code", "data_type"=>1,
"sql_data_type"=>1, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["pc_uom", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>2,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"pc_uom", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"pc_uom", "data_type"=>1, "sql_data_type"=>1,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["recipient_type", {"sql_datetime_sub"=>0, "nullable"=>0,
"num_prec_radix"=>0, "precision"=>2, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"recipient_type", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"recipient_type", "data_type"=>1, "sql_data_type"=>1,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["rsc_dt", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>20, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"rsc_dt",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"rsc_dt", "data_type"=>1,
"sql_data_type"=>1, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["send_ind_type", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>1,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"send_ind_type", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"send_ind_type", "data_type"=>1, "sql_data_type"=>1,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["y_flag", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>1, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"y_flag",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"y_flag", "data_type"=>1,
"sql_data_type"=>1, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["nchar", {"sql_datetime_sub"=>0,
"nullable"=>1, "num_prec_radix"=>0, "precision"=>4000,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"nchar", "literal_prefix"=>"N'",
"minimum_scale"=>0, "create_params"=>"length", "searchable"=>3,
"type_name"=>"nchar", "data_type"=>1, "sql_data_type"=>-8,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["uniqueidentifier", {"sql_datetime_sub"=>0, "nullable"=>1,
"num_prec_radix"=>0, "precision"=>36, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"uniqueidentifier", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"uniqueidentifier", "data_type"=>1, "sql_data_type"=>-11,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["numeric", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>10,
"precision"=>38, "unsigned_attribute"=>0, "maximum_scale"=>38,
"case_sensitive"=>0, "local_type_name"=>"numeric", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>"precision,scale", "searchable"=>2,
"type_name"=>"numeric", "data_type"=>2, "sql_data_type"=>2,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["numeric()
identity", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>10,
"precision"=>38, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"numeric() identity",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>"precision",
"searchable"=>2, "type_name"=>"numeric() identity", "data_type"=>2,
"sql_data_type"=>2, "auto_increment"=>1, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["decimal", {"sql_datetime_sub"=>0, "nullable"=>1,
"num_prec_radix"=>10, "precision"=>38, "unsigned_attribute"=>0,
"maximum_scale"=>38, "case_sensitive"=>0, "local_type_name"=>"decimal",
"literal_prefix"=>nil, "minimum_scale"=>0,
"create_params"=>"precision,scale", "searchable"=>2,
"type_name"=>"decimal", "data_type"=>3, "sql_data_type"=>3,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["money", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>10,
"precision"=>19, "unsigned_attribute"=>0, "maximum_scale"=>4,
"case_sensitive"=>0, "local_type_name"=>"money",
"literal_prefix"=>"$", "minimum_scale"=>4, "create_params"=>nil,
"searchable"=>2, "type_name"=>"money", "data_type"=>3,
"sql_data_type"=>3, "auto_increment"=>0, "fixed_prec_scale"=>1,
"literal_suffix"=>nil}], ["smallmoney", {"sql_datetime_sub"=>0,
"nullable"=>1, "num_prec_radix"=>10, "precision"=>10,
"unsigned_attribute"=>0, "maximum_scale"=>4, "case_sensitive"=>0,
"local_type_name"=>"smallmoney", "literal_prefix"=>"$",
"minimum_scale"=>4, "create_params"=>nil, "searchable"=>2,
"type_name"=>"smallmoney", "data_type"=>3, "sql_data_type"=>3,
"auto_increment"=>0, "fixed_prec_scale"=>1, "literal_suffix"=>nil}], ["decimal()
identity", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>10,
"precision"=>38, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"decimal() identity",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>"precision",
"searchable"=>2, "type_name"=>"decimal() identity", "data_type"=>3,
"sql_data_type"=>3, "auto_increment"=>1, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["int", {"sql_datetime_sub"=>0, "nullable"=>1,
"num_prec_radix"=>10, "precision"=>10, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"int",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"int", "data_type"=>4,
"sql_data_type"=>4, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["seq_key", {"sql_datetime_sub"=>0, "nullable"=>0,
"num_prec_radix"=>10, "precision"=>10, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"seq_key",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"seq_key", "data_type"=>4,
"sql_data_type"=>4, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["sequence_type", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>10, "precision"=>10,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"sequence_type", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"sequence_type", "data_type"=>4, "sql_data_type"=>4,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["skey_type", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>10,
"precision"=>10, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"skey_type", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"skey_type", "data_type"=>4, "sql_data_type"=>4,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["state_province_skey", {"sql_datetime_sub"=>0, "nullable"=>0,
"num_prec_radix"=>10, "precision"=>10, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"state_province_skey", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"state_province_skey", "data_type"=>4, "sql_data_type"=>4,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["int
identity", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>10,
"precision"=>10, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"int identity",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"int identity", "data_type"=>4,
"sql_data_type"=>4, "auto_increment"=>1, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["smallint", {"sql_datetime_sub"=>0, "nullable"=>1,
"num_prec_radix"=>10, "precision"=>5, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"smallint",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"smallint", "data_type"=>5,
"sql_data_type"=>5, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["small_seq_key", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>10, "precision"=>5,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"small_seq_key", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"small_seq_key", "data_type"=>5, "sql_data_type"=>5,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["smallint
identity", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>10,
"precision"=>5, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"smallint identity",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"smallint identity", "data_type"=>5,
"sql_data_type"=>5, "auto_increment"=>1, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["real", {"sql_datetime_sub"=>0, "nullable"=>1,
"num_prec_radix"=>2, "precision"=>24, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"real",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"real", "data_type"=>7,
"sql_data_type"=>7, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["float", {"sql_datetime_sub"=>0, "nullable"=>1,
"num_prec_radix"=>2, "precision"=>53, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"float",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"float", "data_type"=>8,
"sql_data_type"=>6, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["pc_amount", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>2, "precision"=>53,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"pc_amount", "literal_prefix"=>nil, "minimum_scale"=>0,
"create_params"=>nil, "searchable"=>2, "type_name"=>"pc_amount",
"data_type"=>8, "sql_data_type"=>6, "auto_increment"=>0,
"fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["pc_linear",
{"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>2,
"precision"=>53, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"pc_linear", "literal_prefix"=>nil,
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>2,
"type_name"=>"pc_linear", "data_type"=>8, "sql_data_type"=>6,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["pc_multiplier", {"sql_datetime_sub"=>0, "nullable"=>0,
"num_prec_radix"=>2, "precision"=>53, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"pc_multiplier",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"pc_multiplier", "data_type"=>8,
"sql_data_type"=>6, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["pc_percent", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>2, "precision"=>53,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"pc_percent", "literal_prefix"=>nil, "minimum_scale"=>0,
"create_params"=>nil, "searchable"=>2, "type_name"=>"pc_percent",
"data_type"=>8, "sql_data_type"=>6, "auto_increment"=>0,
"fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["pc_quantity",
{"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>2,
"precision"=>53, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"pc_quantity",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"pc_quantity", "data_type"=>8,
"sql_data_type"=>6, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["pc_rate", {"sql_datetime_sub"=>0, "nullable"=>0,
"num_prec_radix"=>2, "precision"=>53, "unsigned_attribute"=>0,
"maximum_scale"=>0, "case_sensitive"=>0, "local_type_name"=>"pc_rate",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"pc_rate", "data_type"=>8,
"sql_data_type"=>6, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["pc_weight", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>2, "precision"=>53,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"pc_weight", "literal_prefix"=>nil, "minimum_scale"=>0,
"create_params"=>nil, "searchable"=>2, "type_name"=>"pc_weight",
"data_type"=>8, "sql_data_type"=>6, "auto_increment"=>0,
"fixed_prec_scale"=>0, "literal_suffix"=>nil}], ["varchar",
{"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>0,
"precision"=>8000, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"varchar",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>"max
length", "searchable"=>3, "type_name"=>"varchar", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["city", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>25,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"city", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"city", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["comment", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>32, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"comment",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"comment", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["commodity", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>4,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"commodity", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"commodity", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["country", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>5, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"country",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"country", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["cust_part", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>20,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"cust_part", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"cust_part", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["customer", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>10, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"customer",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"customer", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["id_list", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>255,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"id_list", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"id_list", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["name_desc", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>32, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"name_desc",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"name_desc", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["order_no", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>10,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"order_no", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"order_no", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["part", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>20, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"part",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"part", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["pc_account_key", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>10,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"pc_account_key", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"pc_account_key", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["pc_street", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>32, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"pc_street",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"pc_street", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["phone", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>10,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"phone", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"phone", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["purshase_ord", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>26, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"purshase_ord",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"purshase_ord", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["quote", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>10,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"quote", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"quote", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["user_id", {"sql_datetime_sub"=>0, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>10, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"user_id",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"user_id", "data_type"=>12,
"sql_data_type"=>12, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["zip_code", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>6,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"zip_code", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"zip_code", "data_type"=>12, "sql_data_type"=>12,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["nvarchar", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>0,
"precision"=>4000, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"nvarchar",
"literal_prefix"=>"N'", "minimum_scale"=>0, "create_params"=>"max
length", "searchable"=>3, "type_name"=>"nvarchar", "data_type"=>12,
"sql_data_type"=>-9, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["sysname", {"sql_datetime_sub"=>0,
"nullable"=>0, "num_prec_radix"=>0, "precision"=>128,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"sysname", "literal_prefix"=>"N'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"sysname", "data_type"=>12, "sql_data_type"=>-9,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["sql_variant", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>10,
"precision"=>8000, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"sql_variant",
"literal_prefix"=>nil, "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>2, "type_name"=>"sql_variant", "data_type"=>12,
"sql_data_type"=>-150, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>nil}], ["datetime", {"sql_datetime_sub"=>3, "nullable"=>1,
"num_prec_radix"=>0, "precision"=>23, "unsigned_attribute"=>0,
"maximum_scale"=>3, "case_sensitive"=>0, "local_type_name"=>"datetime",
"literal_prefix"=>"'", "minimum_scale"=>3, "create_params"=>nil,
"searchable"=>3, "type_name"=>"datetime", "data_type"=>93,
"sql_data_type"=>9, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["smalldatetime", {"sql_datetime_sub"=>3,
"nullable"=>1, "num_prec_radix"=>0, "precision"=>16,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"smalldatetime", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>3,
"type_name"=>"smalldatetime", "data_type"=>93, "sql_data_type"=>9,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}],
["pc_datetime", {"sql_datetime_sub"=>3, "nullable"=>0, "num_prec_radix"=>0,
"precision"=>16, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>0, "local_type_name"=>"pc_datetime",
"literal_prefix"=>"'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>3, "type_name"=>"pc_datetime", "data_type"=>93,
"sql_data_type"=>9, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["image", {"sql_datetime_sub"=>0,
"nullable"=>1, "num_prec_radix"=>0, "precision"=>2147483647,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>0,
"local_type_name"=>"image", "literal_prefix"=>"0x",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>0,
"type_name"=>"image", "data_type"=>2004, "sql_data_type"=>-4,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>nil}],
["ntext", {"sql_datetime_sub"=>0, "nullable"=>1, "num_prec_radix"=>0,
"precision"=>1073741823, "unsigned_attribute"=>0, "maximum_scale"=>0,
"case_sensitive"=>1, "local_type_name"=>"ntext",
"literal_prefix"=>"N'", "minimum_scale"=>0, "create_params"=>nil,
"searchable"=>1, "type_name"=>"ntext", "data_type"=>2005,
"sql_data_type"=>-10, "auto_increment"=>0, "fixed_prec_scale"=>0,
"literal_suffix"=>"'"}], ["text", {"sql_datetime_sub"=>0,
"nullable"=>1, "num_prec_radix"=>0, "precision"=>2147483647,
"unsigned_attribute"=>0, "maximum_scale"=>0, "case_sensitive"=>1,
"local_type_name"=>"text", "literal_prefix"=>"'",
"minimum_scale"=>0, "create_params"=>nil, "searchable"=>1,
"type_name"=>"text", "data_type"=>2005, "sql_data_type"=>-1,
"auto_increment"=>0, "fixed_prec_scale"=>0, "literal_suffix"=>"'"}]]
for date (RuntimeError)
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/ActiveRecord-JDBC-0.2.3/lib/active_reco
rd/connection_adapters/jdbc_adapter.rb:8:in `new'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/ActiveRecord-JDBC-0.2.3/lib/active_reco
rd/connection_adapters/jdbc_adapter.rb:8:in `jdbc_connection'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/c
onnection_adapters/abstract/connection_specification.rb:262:in `send'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/c
onnection_adapters/abstract/connection_specification.rb:262:in `connection='
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/q
uery_cache.rb:54:in `connection='
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/c
onnection_adapters/abstract/connection_specification.rb:230:in `retrieve_connection'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/c
onnection_adapters/abstract/connection_specification.rb:78:in `connection'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/b
ase.rb:763:in `columns'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/b
ase.rb:2063:in `attributes_from_column_definition'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/l
ocking/optimistic.rb:45:in `attributes_from_column_definition_with_lock'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/b
ase.rb:1502:in `initialize'
        from C:/Program Files/nbrubyide/ruby1/jruby-0.9.8/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/c
allbacks.rb:225:in `initialize_with_callbacks'
        from C:\FreightSystem\app\shipment_export.rb:164:in `new'
        from C:\FreightSystem\app\shipment_export.rb:164

Date: 2007-08-11 13:28
Sender: Ola Bini

Is this still an issue, using AR-JDBC trunk?

Date: 2007-04-25 14:25
Sender: morgan hankins

Note that the fix I mentioned only partially works.
The date is correct but the time is mangled.

Also this 'fix' stopped working with jruby 0.9.9

Date: 2007-04-24 10:00
Sender: Gabriel Falkenberg

There are no separate time and date data types for storing only
times or only dates in MS SQL (at least not in version 2000).
I think the datetime type is appropriate to use instead. This
can be done by adding:

    lambda {|r| r['type_name'] =~ /^datetime$/i}], # For MS SQL

just after the line:

    lambda {|r| r['type_name'] =~ /^date$/i}, #Line ~97

Date: 2007-04-09 14:00
Sender: morgan hankins

I had this issue using oracle 9i and I seemed to have
fixed it by changing jdbc_adapter.rb

After the line:
:time  => [ lambda {|r| Jdbc::Types::TIME == ['data_type']},

I added:
      lambda {|r| r['type_name'] =~ /^DATE$/i},