On 2006-10-16 16:00:42 +0100, Jason Crummack wrote: > As you say the update isn't firing as the expires field and data > fields don't have values in them? > > I've tried various table definitions but the current one is (thought > id could be dbi's handling of blob's / clobs's initially) > > create table sessions ( > session_id char(72) primary key, > session_data varchar2(4000), > expires int > ); > > I've mapped the field names accordingly in the config, but i'm > assuming they are working ok due to the fact that the records are > being inserted initially, although as previously mentioned only the > session_id has been set.
Perhaps the suggestion in the docs to use a CHAR(72) field for the session ID is causing subsequent statements to fail. Oracle is likely blank-padding the session IDs and Session::Store::DBIC wouldn't know to do that. If you're content with the default hashing algorithm try changing the length to match the actual length of the session IDs (48 characters IIRC), or change it to a VARCHAR(72). Let me know and I'll update the docs to reflect this, if this turns out to be the case. Thanks, -- Daniel Westermann-Clark _______________________________________________ List: [email protected] Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
