eitan wrote:
> > apparently, somehow Store::Oracle was not setting autocommit to true
> > and not committing its insert's. so each time the store was used, any
> > sql commands would be rolled back while still returning a success
> > response to the caller.
gerald wrote:
> What have you done, to get it working with Embperl? How is the corrected
> configuration, or did you have to change anything else to get it working
> with Embperl ?
Apparently the change included changing this statement in
Session::Store::Oracle.pm:
$self->{dbh} = DBI->connect(
$datasource,
$username,
$password,
{ RaiseError => 1, AutoCommit => 0 }
) || die $DBI::errstr;
to this:
$self->{dbh} = DBI->connect(
$datasource,
$username,
$password,
{ RaiseError => 1, AutoCommit => 1 }
) || die $DBI::errstr;
note that the only difference is the AutoCommit value
what i can't figure out is why the original code worked using
command line scripts that used session.pm (without embperl).
thanks, eitan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
