Bugs item #9663, was opened at 2007-03-29 09:36
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=9663&group_id=2014
Category: AR-JDBC
Group: 0.2.3
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: unable to choose type from: ,,, for date
Initial Comment:
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, "lite
ral_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"=>"varb
inary", "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_suffi
x"=>"'"}], ["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, "creat
e_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_da
tetime_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_pro
vince_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_incre
ment"=>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, "unsi
gned_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, "cr
eate_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"=>"'"}], ["p
c_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_pr
ec_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, "searchab
le"=>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_record/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_record/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/connection_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/connection_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/query_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/connection_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/connection_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/base.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/base.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/locking/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/base.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/callbacks.rb:225:in
`initialize_with_callbacks'
from C:\FreightSystem\app\shipment_export.rb:164:in `new'
from C:\FreightSystem\app\shipment_export.rb:164
----------------------------------------------------------------------
>Comment By: Ola Bini (olabini)
Date: 2007-08-11 15:28
Message:
Is this still an issue, using AR-JDBC trunk?
----------------------------------------------------------------------
Comment By: morgan hankins (morganhankins)
Date: 2007-04-25 16:25
Message:
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
----------------------------------------------------------------------
Comment By: Gabriel Falkenberg (gabrielf)
Date: 2007-04-24 12:00
Message:
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
----------------------------------------------------------------------
Comment By: morgan hankins (morganhankins)
Date: 2007-04-09 16:00
Message:
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},
----------------------------------------------------------------------
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=9663&group_id=2014
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
