private void execute(String sqlCommand) throws PublisherException { if ( sqlCommand!=null ) { Statement statement = null;
private void execute(String sqlCommandTemplate, Preparer preparer) throws PublisherException { if ( sqlCommandTemplate!=null ) { Connection connection = null; ResultSet result = null; PreparedStatement ps = null;
    private void execute(String sqlCommand) throws PublisherException {        if ( sqlCommand!=null ) {            Statement statement = null;            try {                statement = connection.createStatement();                statement.execute(sqlCommand);            } catch (SQLException e) {                StringWriter sw = new StringWriter();                PrintWriter pw = new PrintWriter(sw);                pw.println("Exception during execution of:");                pw.println("  "+sqlCommand);                pw.println("See cause of exception.");                pw.flush();                PublisherException pe = new PublisherException(sw.toString());                pe.initCause(e);                log.debug("execute error cause:", e);                throw pe;            } finally {                try {                    if ( statement!=null )                        statement.close();                } catch (SQLException e) {                    log.debug("error when closing", e);                }            }        }    }