Session handling busted on Oracle

[Berger, Daniel]

> -----Original Message-----
> From: camping-list-bounces at rubyforge.org 
> [mailto:camping-list-bounces at rubyforge.org] On Behalf Of 
> Jonas Pfenniger
> Sent: Monday, October 08, 2007 12:23 PM
> To: camping-list at rubyforge.org
> Subject: Re: Session handling busted on Oracle
> 
> 
> 2007/10/8, Berger, Daniel <Daniel.Berger at qwest.com>:
> > 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.