clean up get connection methods.