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, -- 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/
