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

[Jason Crummack]

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