[Dbix-class] ROLLBACK seems to be skipped on 0.08

[Peter Edwards]

>I also intentionally close the db-connection pre-request from Catalyst,
>that may be the reason why I never stumbled upon that problem.

OK. There's better performance with a persistent database connection (DBIC
handles this transparently I believe under Apache mod_perl). Depends what
web server platform you use.

>In this application the "web-authenticated-user" is also the
>"database-user", so a "connection per request" is required.

Most apps I've worked on we used a single db user (whatever the web
authenticated user) that has update permissions but not admin permissions.
It limits the damage that can be done if your app has a security hole.

Regards, Peter
www.dragonstaff.com