Bugs item #10317, was opened at 2007-04-23 19:29
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=10317&group_id=2014

Category: AR-JDBC
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Ashish Sahni (whacko)
Assigned to: Nobody (None)
Summary: java.sql.SQLException: Columns of type 'DECIMAL' cannot hold values of 
type 'CHAR'

Initial Comment:
JRuby 0.9.9-SNAPSHOT svn rev#3495, AR-JDBC 0.2.4 (installed on 4/14/07 as gem 
install AR-JDBC --source http://caldershpere.net/,
Derby DB, rails-integration-1.1-SNAPSHOT, rails 1.2.2


 ActiveRecord::StatementInvalid in AdminController#create

NativeException: java.sql.SQLException: Columns of type 'DECIMAL' cannot hold 
values of type 'CHAR'. : INSERT INTO products (image_url, price, title, 
description) VALUES('asfd.jpg', '100.00', 'afd', 'asdfasfddf')

RAILS_ROOT: 
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/config/..
Application Trace | Framework Trace | Full Trace

/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/ActiveRecord-JDBC-0.2.4/lib/active_record/connection_adapters/jdbc_adapter.rb:459:in
 `log_no_bench'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/ActiveRecord-JDBC-0.2.4/lib/jdbc_adapter/jdbc_derby.rb:68:in
 `execute'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/ActiveRecord-JDBC-0.2.4/lib/active_record/connection_adapters/jdbc_adapter.rb:412:in
 `insert'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/base.rb:1819:in
 `create'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/callbacks.rb:254:in
 `create_with_callbacks'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/timestamp.rb:39:in
 `create_with_timestamps'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/base.rb:1790:in
 `create_or_update'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/callbacks.rb:242:in
 `create_or_update_with_callbacks'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/base.rb:1546:in
 `save'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/validations.rb:752:in
 `save_with_validation'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/transactions.rb:128:in
 `save_with_transactions'
#{RAILS_ROOT}/app/controllers/admin_controller.rb:31:in `transaction'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/transactions.rb:96:in
 `transaction'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/transactions.rb:121:in
 `transaction'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/activerecord-1.15.2/lib/active_record/transactions.rb:129:in
 `save_with_transactions'
#{RAILS_ROOT}/app/controllers/admin_controller.rb:31:in `create'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/base.rb:1095:in
 `send'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/base.rb:1095:in
 `perform_action'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/filters.rb:631:in
 `call_filter'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/filters.rb:619:in
 `perform_action_with_filters'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/benchmarking.rb:65:in
 `perform_action_with_benchmark'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/rescue.rb:83:in
 `measure'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/benchmarking.rb:66:in
 `perform_action_with_benchmark'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/rescue.rb:83:in
 `perform_action_with_rescue'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/base.rb:431:in
 `send'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/base.rb:431:in
 `process'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/filters.rb:624:in
 `process_with_filters'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/session_management.rb:114:in
 `process_with_session_management_support'
/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/actionpack-1.13.2/lib/action_controller/base.rb:330:in
 `process'
:0

/home/ashish/gf91/publish/glassfish/domains/domain1/applications/j2ee-modules/depot_l4/WEB-INF/gems/gems/rails-1.2.2/lib/dispatcher.rb:41:in
 `dispatch'
/gems/gems/ActiveRecord-JDBC-0.2.4/lib/active_record/connection_adapters/jdbc_adapter.rb:459:in
 `log_no_bench'
gems/gems/ActiveRecord-JDBC-0.2.4/lib/jdbc_adapter/jdbc_derby.rb:68:in `execute'
gems/gems/ActiveRecord-JDBC-0.2.4/lib/active_record/connection_adapters/jdbc_adapter.rb:412:in
 `insert'
gems/gems/activerecord-1.15.2/lib/active_record/base.rb:1819:in `create'
......
gems/gems/rails-1.2.2/lib/dispatcher.rb:41:in `dispatch'
:0

Request

Parameters: {"commit"=>"Create", "product"=>{"price"=>"100.00", 
"image_url"=>"asfd.jpg", "title"=>"afd", "description"=>"asdfasfddf"}}

Show session dump

--- 
flash: !map:ActionController::Flash::FlashHash {}

Response
Headers: {"cookie"=>[], "Cache-Control"=>"no-cache"}

----------------------------------------------------------------------

>Comment By: Ola Bini (olabini)
Date: 2007-08-11 15:31

Message:
Derby is rock solid now.

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=10317&group_id=2014
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Reply via email to