Database: Check isValid instead of just isClosed

Updated SQLService to check to see if the connection is valid and not just closed
Updated PathController to not return possible/enabled endpoints on the all paths call.  Must request data for individual paths now (UI performance fix).