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{

 

 

David Ramer

27 years in the software industry. I have worked with some of the biggest internet companies in the industry. Spent 11 years as a software developer working on projects like QuickBooks, Quicken, and Pointcast. 16 years building and leading QA teams all over the world. I've worked with all types of testing software and CI environments. Over the years, I've developed Bichromate, best of breed software testing solution that integrates the industry best frameworks (TestNG) and home designed Factories.

Leave a Reply

Your email address will not be published. Required fields are marked *