Bichromate Supports Proxy DB Server Access

sTestMySQLConnector is a new Bichromate factory that enables tests to use a proxy server to connect to a mySQL DB. Most organizations only allow DB access thru a proxy server. Bichromate solves this problem by wrapping sTestMySQLConnector around “jcraft” http://www.jcraft.com/

You simply fill out the properties file to gain access.

#
# SSH when DB is behind a firewall
# Here you connect to a remote machine and complete port forwarding
# You must store the id_rsa in the security directory. It must be named id_rsa
#
sTestMySQLConnector.sshuser=
sTestMySQLConnector.sshHost=
sTestMySQLConnector.remoteDBHost=
sTestMySQLConnector.remotePort=3306
sTestMySQLConnector.localPort=3307
sTestMySQLConnector.sshDBServerName=
sTestMySQLConnector.SSHDBLogin=
sTestMySQLConnector.SSHDBPassword=
sTestMySQLConnector.SampleSSHConnectionQuery=

Once the connection is made, the test simply calls:

/**
* This method demonstrates executeQuery(). Use this method to execute SQL querries on the DB
* @author davidwramer
* @version 1.0
*/
public ResultSet executeQuery(String query) throws SQLException{