Couldn't try with that particular session id (removed and recreated table several times since) but i've tried with another and record was successfully returned.
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. I'll have a poke around in DBD::Oracle (one of my colleagues is a maintainer) and i'll return any findings. Thanks for the prompt reply :-) Jason Daniel Westermann-Clark wrote: > On 2006-10-16 12:23:28 +0100, Jason Crummack wrote: > >> I'm trying to get the Session::Store::DBIC plugin working with >> oracle but with no success, i believe i've got everything configured >> correctly and new session rows are being written to the database but >> I'm getting an exception in the Delegate.pm module. >> >> [error] Caught exception in engine >> "DBIx::Class::InflateColumn::update(): Can't update >> MyApp::Model::MyDB::Sessions=HASH(0x9104174): row not found at >> /usr/local/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm >> >> line 85" >> > > There's something fishy going on with the database interaction. > Either the rows aren't landing the in the sessions table correctly or > DBI isn't returning the correct number of rows from $sth->execute on > UPDATE. > > First check that you get a result back in the Oracle shell: > > SELECT * FROM "SESSIONS" WHERE "SESSION_ID" = > 'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4' > > Could you also provide the CREATE TABLE statement you used for your > sessions table? > > Thanks, > > _______________________________________________ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/