Prepare a sql statement in java and print it as a string

print_prepared_statement_as_sql.java

List<Object> params = Lists.newArrayList();
if (logger.isDebugEnabled()){
            try {
                PreparedStatement ps = this.getConnection().prepareStatement(q);
                for (int i=0 ; i < params.size(); i++){
                    ps.setObject(i+1, params.get(i));
                }

                logger.debug("Build this {}", ps);

            } catch (Exception e) {
                logger.debug("Problem getting prepared statement{}", e);
            }
        }
// works in a standard dso.