> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Jonas Pfenniger > Sent: Monday, October 08, 2007 12:23 PM > To: camping-list@rubyforge.org > Subject: Re: Session handling busted on Oracle > > > 2007/10/8, Berger, Daniel <[EMAIL PROTECTED]>: > > Was there something else I should have used? > > Well technically, the id field is not necessary anymore. I > don't know how AR will react if it is set. Also, are you sure > that you are using camping from trunk ? > > Btw, here is the schema I have on sqlite : > > CREATE TABLE sessions ("hashid" varchar(32) NOT NULL, > "created_at" datetime DEFAULT NULL, "ivars" text DEFAULT NULL);
Upon further review that isn't going to work. You can't set the @state variable without an id field. Camping Problem! FastPath::Controllers::Login.POST ActiveRecord::StatementInvalid OCIError: ORA-00904: "ID": invalid identifier: UPDATE sessions SET hashid = 'iNr6UPnc3KjbQBxZwktujSIENXWIhzfd', ivars = '--- !map:HashWithIndifferentAccess FastPath: !map:HashWithIndifferentAccess cuid: true ', created_at = '2007-10-09 11:00:32' WHERE id = NULL: C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/con nection_adapters/abstract_adapter.rb:128:in `log' C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/con nection_adapters/oracle_adapter.rb:222:in `execute' ... Suggestions? Thanks, Dan This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments. _______________________________________________ Camping-list mailing list Camping-list@rubyforge.org http://rubyforge.org/mailman/listinfo/camping-list