Forum: Ruby on Rails Inserting to a View - Auto Incrementing Issue

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Paul H. (Guest)
on 2008-12-01 19:23
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.
Praveen (Guest)
on 2008-12-02 18:58
(Received via mailing list)
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>
This topic is locked and can not be replied to.