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

[Daniel Westermann-Clark]

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