I'm pretty sure that some JDBC drivers (at least Oracle) can correctly convert values like "Y/N" or "1/0" to Boolean if read with ResultSet.getBoolean().
In order to deploy artifacts using SSH you must first specify the use of an SSH server in the distributionManagement element of your POM as well as specifying an extension in your build element which will pull in the SSH artifacts required to deploy with SSH: