MySQL offers standard database driver connectivity for using MySQL with applications and tools that are compatible with industry standards ODBC and JDBC. Any system that works with ODBC or JDBC can use MySQL. Standardized database driver for Windows, Linux, Mac OS X, and Unix platforms. The JDBC driver is a file with the extension.jar (some drivers need more than one file). Once you have downloaded the driver you can store the driver's.jar file. Mysql-connector-java-5.1.36-bin.jar (exact name depends on the driver version).
Exception in thread 'main' java.sql.SQLException: Server tran-vmware has no instance named SQLEXPRESS. Com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: 'Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.' Exception in thread 'main' com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host tran-vmware, port 1433 has failed.
Error: 'Connection refused: connect. Verify the connection properties.
Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.'