Debugging Database connection

package example.sql.connection;
 
import java.io.FileOutputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class TestDebug_MySQL {
    public static Connection getConnection() throws Exception {
	String driver = "org.gjt.mm.mysql.Driver";
	String url = "jdbc:mysql://localhost/octopus";
	String username = "root";
	String password = "root";
	Class.forName(driver);
	return DriverManager.getConnection(url, username, password);
    }
 
    public static int countRows(Connection conn, String tableName) throws SQLException {
	Statement stmt = null;
	ResultSet rs = null;
	int rowCount = -1;
	try {
	    stmt = conn.createStatement();
	    rs = stmt.executeQuery("SELECT COUNT(*) FROM " + tableName);
	    // get the number of rows from the result set
	    rs.next();
	    rowCount = rs.getInt(1);
	} finally {
	    rs.close();
	    stmt.close();
	}
 
	return rowCount;
    }
 
    public static void main(String[] args) {
	Connection conn = null;
	try {
	    PrintWriter pw = new PrintWriter(new FileOutputStream("mysql_debug.txt"));
	    DriverManager.setLogWriter(pw);
	    conn = getConnection();
	    String tableName = "myTable";
	    System.out.println("tableName=" + tableName);
	    System.out.println("conn=" + conn);
	    System.out.println("rowCount=" + countRows(conn, tableName));
	} catch (Exception e) {
	    e.printStackTrace();
	    System.exit(1);
	} finally {
	    try {
		conn.close();
	    } catch (SQLException e) {
		e.printStackTrace();
	    }
	}
    }
}