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

[Jason Crummack]

Hi,

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.

Anyone seen anything similar?

Thanks

Jason


SELECT "me"."SESSION_ID", "me"."SESSION_DATA", "me"."EXPIRES" FROM 
"SESSIONS" "me" WHERE ( ( "me"."SESSION_ID" = ? ) ): 
'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4'
INSERT INTO "SESSIONS" ("SESSION_ID") VALUES (?): 
'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4'
UPDATE "SESSIONS" SET "EXPIRES" = ?, "SESSION_DATA" = ? WHERE ( 
"SESSION_ID" = ? ): '1161001443', 
'BQcDAAAAAwoNMTkyLjE2OC4wLjEwMQAAAAlfX2FkZHJlc3MJRTNdwwAAAAlfX2NyZWF0ZWQJRTNd
wwAAAAlfX3VwZGF0ZWQ=
', 'session:229bb8dfca4194b7039378ab177df64aa1f3ddc4'
[debug] Body Parameters are:
.-------------------------------------+--------------------------------------.
| Parameter                           | 
Value                                |
+-------------------------------------+--------------------------------------+
| pwd                                 | 
Password                             |
| uid                                 | 
Username                             |
'-------------------------------------+--------------------------------------'

[debug] "POST" request for "users/login" from "192.168.0.101"
[debug] Path is "users/login"
[debug] Created session "229bb8dfca4194b7039378ab177df64aa1f3ddc4"
[debug] session cookie $VAR1 = {
          '__address' => '192.168.0.101',
          '__created' => 1160994243,
          '__updated' => 1160994243
        };

[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"