If you aren't using Django's ORM, 500 server error pages fail to render. Here's the output from the Apache error log:
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/lib/python2.4/site-packages/mod_python/importer.py", line 1128, in _execute_target\n result = object(arg)
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/local/django/django_src/django/core/handlers/modpython.py", line 177, in handler\n return ModPythonHandler()(req)
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/local/django/django_src/django/core/handlers/modpython.py", line 150, in __call__\n response = self.get_response(request)
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py", line 115, in get_response\n receivers = dispatcher.send(signal=signals.got_request_exception)
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/lib/python2.4/site-packages/django/dispatch/dispatcher.py", line 358, in send\n sender=sender,
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/lib/python2.4/site-packages/django/dispatch/robustapply.py", line 47, in robustApply\n return receiver(*arguments, **named)
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/local/django/django_src/django/db/__init__.py", line 48, in _rollback_on_exception\n transaction.rollback_unless_managed()
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/local/django/django_src/django/db/transaction.py", line 145, in rollback_unless_managed\n connection._rollback()
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] File "/usr/local/django/django_src/django/db/backends/dummy/base.py", line 13, in complain\n raise ImproperlyConfigured, "You haven't set the DATABASE_ENGINE setting yet."
[Wed May 30 12:14:13 2007] [error] [client 192.168.1.3] ImproperlyConfigured: You haven't set the DATABASE_ENGINE setting yet.
Basically, the DB engine is hooked in through signals.got_request_exception and tries to roll back the connection.