var dbConn = $g('pgDbConn');
if ('undefined' === typeof dbConn || null === dbConn || !isDbConnValid(dbConn)) {
	logger.debug('Creating new database connection...');
	dbConn = java.sql.DriverManager.getConnection('jdbc:postgresql://localhost:5432/mirthdb','postgres','postgres');
	$g('pgDbConn',dbConn);
}

function isDbConnValid(dbConn) {
	var valid = !dbConn.isClosed();
	try {valid = valid && dbConn.isValid(100);} catch(e) {}

	if (valid) {
		try {
			dbConn.prepareStatement('select 0').executeQuery();
		} catch (e) {valid = false;}
	}

	if (!valid)
		try {dbConn.close();} catch(e) {}

	return valid;
}