Inserting to a View - Auto Incrementing Issue


#1

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.


#2

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. removed_email_address@domain.invalid