Bugs item #9608, was opened at 2007-03-27 09:49
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=9608&group_id=2014
Category: AR-JDBC
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Informix-JDBC-Driver unable to choose type for time-column
Initial Comment:
Hi, I encountered an error with the informix-driver, when trying to
load an object whose table contains a time-column. This seems to be a
datatype-mapping error like the one in Oracle or Postgres...
STACK:===============================
The driver encounter an error: unable to choose type from: [["byte",
{"nullable"=>1, "num_prec_radix"=>0, "local_type_name"=>"byte",
"fixed_prec_scale"=>0, "data_type"=>-4, "maximum_scale"=>32767,
"precision"=>32767, "auto_increment"=>0, "literal_suffix"=>"",
"case_sensitive"=>0, "searchable"=>0, "unsigned_attribute"=>0,
"type_name"=>"byte", "create_params"=>nil, "minimum_scale"=>0,
"literal_prefix"=>"", "sql_datetime_sub"=>0, "sql_data_type"=>0}], ["char",
{"nullable"=>1, "num_prec_radix"=>0, "local_type_name"=>"char",
"fixed_prec_scale"=>0, "data_type"=>1, "maximum_scale"=>32767,
"precision"=>32767, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>1, "searchable"=>3, "unsigned_attribute"=>0,
"type_name"=>"char", "create_params"=>nil, "minimum_scale"=>0,
"literal_prefix"=>"'", "sql_datetime_sub"=>0, "sql_data_type"=>0}], ["character
varying", {"nullable"=>1, "num_prec_radix"=>0, "local_type_name"=>"character
varying", "fixed_prec_scale"=>0, "data_type"=>12, "max
imum_scale"=>0, "precision"=>0, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>1, "searchable"=>3, "unsigned_attribute"=>0,
"type_name"=>"character varying", "create_params"=>nil, "minimum_scale"=>0,
"literal_prefix"=>"'", "sql_datetime_sub"=>0, "sql_data_type"=>0}], ["date",
{"nullable"=>1, "num_prec_radix"=>0, "local_type_name"=>"date",
"fixed_prec_scale"=>0, "data_type"=>91, "maximum_scale"=>0, "precision"=>0,
"auto_increment"=>0, "literal_suffix"=>"'", "case_sensitive"=>0,
"searchable"=>2, "unsigned_attribute"=>0, "type_name"=>"date",
"create_params"=>nil, "minimum_scale"=>0, "literal_prefix"=>"'",
"sql_datetime_sub"=>0, "sql_data_type"=>0}], ["datetime year to fraction(5)",
{"nullable"=>1, "num_prec_radix"=>0, "local_type_name"=>"datetime year to
fraction(5)", "fixed_prec_scale"=>0, "data_type"=>93, "maximum_scale"=>0,
"precision"=>0, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>0, "searchable"=>2, "unsigned_attribute"=>0, "type_name"=>"d
atetime year to fraction(5)", "create_params"=>nil, "minimum_scale"=>0,
"literal_prefix"=>"'", "sql_datetime_sub"=>0, "sql_data_type"=>0}], ["decimal",
{"nullable"=>1, "num_prec_radix"=>10, "local_type_name"=>"decimal",
"fixed_prec_scale"=>1, "data_type"=>3, "maximum_scale"=>32, "precision"=>32,
"auto_increment"=>0, "literal_suffix"=>"'", "case_sensitive"=>0,
"searchable"=>2, "unsigned_attribute"=>0, "type_name"=>"decimal",
"create_params"=>nil, "minimum_scale"=>1, "literal_prefix"=>"'",
"sql_datetime_sub"=>0, "sql_data_type"=>0}], ["double precision",
{"nullable"=>1, "num_prec_radix"=>10, "local_type_name"=>"double precision",
"fixed_prec_scale"=>0, "data_type"=>3, "maximum_scale"=>0, "precision"=>0,
"auto_increment"=>0, "literal_suffix"=>"'", "case_sensitive"=>0,
"searchable"=>2, "unsigned_attribute"=>0, "type_name"=>"double precision",
"create_params"=>nil, "minimum_scale"=>0, "literal_prefix"=>"'",
"sql_datetime_sub"=>0, "sql_data_type"=>0}], ["float", {"nullable"=>1, "n
um_prec_radix"=>10, "local_type_name"=>"float", "fixed_prec_scale"=>0,
"data_type"=>6, "maximum_scale"=>8, "precision"=>8, "auto_increment"=>0,
"literal_suffix"=>"'", "case_sensitive"=>0, "searchable"=>2,
"unsigned_attribute"=>0, "type_name"=>"float", "create_params"=>nil,
"minimum_scale"=>1, "literal_prefix"=>"'", "sql_datetime_sub"=>0,
"sql_data_type"=>0}], ["integer", {"nullable"=>1, "num_prec_radix"=>10,
"local_type_name"=>"integer", "fixed_prec_scale"=>0, "data_type"=>4,
"maximum_scale"=>0, "precision"=>0, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>0, "searchable"=>2, "unsigned_attribute"=>0,
"type_name"=>"integer", "create_params"=>nil, "minimum_scale"=>0,
"literal_prefix"=>"'", "sql_datetime_sub"=>0, "sql_data_type"=>0}],
["interval", {"nullable"=>1, "num_prec_radix"=>0,
"local_type_name"=>"interval", "fixed_prec_scale"=>0, "data_type"=>1111,
"maximum_scale"=>0, "precision"=>0, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>0, "search
able"=>2, "unsigned_attribute"=>0, "type_name"=>"interval",
"create_params"=>nil, "minimum_scale"=>0, "literal_prefix"=>"'",
"sql_datetime_sub"=>0, "sql_data_type"=>0}], ["nchar", {"nullable"=>1,
"num_prec_radix"=>0, "local_type_name"=>"nchar", "fixed_prec_scale"=>0,
"data_type"=>1, "maximum_scale"=>0, "precision"=>0, "auto_increment"=>0,
"literal_suffix"=>"'", "case_sensitive"=>1, "searchable"=>3,
"unsigned_attribute"=>0, "type_name"=>"nchar", "create_params"=>nil,
"minimum_scale"=>0, "literal_prefix"=>"'", "sql_datetime_sub"=>0,
"sql_data_type"=>0}], ["nvarchar", {"nullable"=>1, "num_prec_radix"=>0,
"local_type_name"=>"nvarchar", "fixed_prec_scale"=>0, "data_type"=>12,
"maximum_scale"=>0, "precision"=>0, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>1, "searchable"=>3, "unsigned_attribute"=>0,
"type_name"=>"nvarchar", "create_params"=>nil, "minimum_scale"=>0,
"literal_prefix"=>"'", "sql_datetime_sub"=>0, "sql_data_type"=>0}], ["money",
{"nullable"=>1, "num_
prec_radix"=>10, "local_type_name"=>"money", "fixed_prec_scale"=>1,
"data_type"=>3, "maximum_scale"=>32, "precision"=>32, "auto_increment"=>0,
"literal_suffix"=>"'", "case_sensitive"=>0, "searchable"=>2,
"unsigned_attribute"=>0, "type_name"=>"money", "create_params"=>nil,
"minimum_scale"=>16, "literal_prefix"=>"'", "sql_datetime_sub"=>0,
"sql_data_type"=>0}], ["numeric", {"nullable"=>1, "num_prec_radix"=>10,
"local_type_name"=>"numeric", "fixed_prec_scale"=>1, "data_type"=>2,
"maximum_scale"=>32, "precision"=>32, "auto_increment"=>0,
"literal_suffix"=>"'", "case_sensitive"=>0, "searchable"=>2,
"unsigned_attribute"=>0, "type_name"=>"numeric", "create_params"=>nil,
"minimum_scale"=>1, "literal_prefix"=>"'", "sql_datetime_sub"=>0,
"sql_data_type"=>0}], ["serial", {"nullable"=>0, "num_prec_radix"=>10,
"local_type_name"=>"serial", "fixed_prec_scale"=>0, "data_type"=>4,
"maximum_scale"=>0, "precision"=>0, "auto_increment"=>1, "literal_suffix"=>"'",
"case_sensitive"=>0, "searchable
"=>2, "unsigned_attribute"=>0, "type_name"=>"serial", "create_params"=>nil,
"minimum_scale"=>0, "literal_prefix"=>"'", "sql_datetime_sub"=>0,
"sql_data_type"=>0}], ["smallint", {"nullable"=>1, "num_prec_radix"=>10,
"local_type_name"=>"smallint", "fixed_prec_scale"=>0, "data_type"=>5,
"maximum_scale"=>0, "precision"=>0, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>0, "searchable"=>2, "unsigned_attribute"=>0,
"type_name"=>"smallint", "create_params"=>nil, "minimum_scale"=>0,
"literal_prefix"=>"'", "sql_datetime_sub"=>0, "sql_data_type"=>0}],
["smallfloat", {"nullable"=>1, "num_prec_radix"=>10,
"local_type_name"=>"smallfloat", "fixed_prec_scale"=>0, "data_type"=>7,
"maximum_scale"=>6, "precision"=>6, "auto_increment"=>0, "literal_suffix"=>"'",
"case_sensitive"=>0, "searchable"=>2, "unsigned_attribute"=>0,
"type_name"=>"smallfloat", "create_params"=>nil, "minimum_scale"=>1,
"literal_prefix"=>"'", "sql_datetime_sub"=>0, "sql_data_type"=>0}], ["text",
{"nullable"=
>1, "num_prec_radix"=>0, "local_type_name"=>"text", "fixed_prec_scale"=>0,
>"data_type"=>-1, "maximum_scale"=>0, "precision"=>0, "auto_increment"=>0,
>"literal_suffix"=>"", "case_sensitive"=>0, "searchable"=>0,
>"unsigned_attribute"=>0, "type_name"=>"text", "create_params"=>nil,
>"minimum_scale"=>0, "literal_prefix"=>"", "sql_datetime_sub"=>0,
>"sql_data_type"=>0}], ["varchar", {"nullable"=>1, "num_prec_radix"=>0,
>"local_type_name"=>"varchar", "fixed_prec_scale"=>0, "data_type"=>12,
>"maximum_scale"=>255, "precision"=>255, "auto_increment"=>0,
>"literal_suffix"=>"'", "case_sensitive"=>1, "searchable"=>3,
>"unsigned_attribute"=>0, "type_name"=>"varchar", "create_params"=>nil,
>"minimum_scale"=>0, "literal_prefix"=>"'", "sql_datetime_sub"=>0,
>"sql_data_type"=>0}]] for time
----------------------------------------------------------------------
>Comment By: Ola Bini (olabini)
Date: 2007-08-11 15:26
Message:
Informix is not yet supported at all. Someone needs to add that support before
anything will work - that is a feature request.
----------------------------------------------------------------------
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=9608&group_id=2014
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
