[Catalyst] Is anyone using Catalyst::Plugin::Session::Store::DBIC successfully with Oracle?

[Daniel Westermann-Clark]

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