Hi, My app has a model defined like this: MyModel < ActiveRecord::Base set_table_name "SOME_LEGACY_VIEW" set_primary_key "LEGACY_ID" end The Database is DB2. The view definition looks like this SELECT LEGACY_ID, NAME FROM LEGACY_TABLE When I create a new model and try to save it by doing this... myModel = MyModel.new myModel.name = "TEST" myModel.save Rails is creating an INSERT statement which includes the primary key - LEGACY_ID - set to an ampty String. This blows up auto-increment on LEGACY_TABLE. Anyone seen this? Suggested solution. Note - if LEGACY_ID is removed from the view it works OK, but I'm working with requirements that say it should be there. Thanks.
on 2008-12-01 19:23
on 2008-12-02 18:58
Hi Paul, Could you provide us the description of the LEGACY_TABLE (what is mainly wanted is the type of the column LEGACY_ID ). Also could you capture the insert statement that is being generated and paste it. Thanks Praveen On Dec 1, 10:23 pm, Paul H. <firstname.lastname@example.org>