fix to close dbas once queries to avoid connection starvation
switched to LocalLookUp
call disconnect directly on dbconnection
fixed bugs in building dbadaptor for comparas