HomePage RecentChanges Shared DB

Apache::DBI has done all the hard work for sharing a database handle, but for reasons I won't go into here, I could not use it.

So I did my own sharing, until I kept getting a:

Took a bit of effort between me and a colleague to work it out. A user was entering a duplicate record, and our code correctly threw an exception, which was correctly displayed to the user as a popup in their browser of the failed AJAX request.

However, then we exit, leaving the DB handle to be used by the next client.

The same user goes in again, hitting a different apache instance, and different DB handle and try to modify the same rows.

The old handle had not had a rollback, so still had record locks.

The bugs:

The last one is done by Apache::DBI by doing a rollback on child clean up if Auto Commit is off.

GOTCHA !

Software error:

Can't locate object method "endform" via package "CGI" at /data/scott.dd.com.au/wiki/modules/search.pl line 15.

For help, please send mail to the webmaster (webmaster@dd.com.au), giving this error message and the time and date of the error.