[Zope] Checking the state of a database connection

Daniel G. Rusch drusch@globalcrossing.com
Thu, 27 Jan 2000 09:39:30 -0600


I have run into this problem also so this is what we do (sorry for not
elaborating in my first post, wanted to keep it simple):

<dtml-if "Database.connected()">
	<dtml-try>
		<dtml-call DbTestMethod>
			OK
		<dtml-except>
			Database Connection or Oracle is down
	</dtml-try>
<dtml-else>
	Database Connection or Oracle is down
</dtml-if>





sql in DbTestMethod:


select SYSDATE
from DUAL