Example usage for org.springframework.jdbc.support.lob LobCreator setClobAsString

Introduction

In this page you can find the example usage for org.springframework.jdbc.support.lob LobCreator setClobAsString.

Prototype

void setClobAsString(PreparedStatement ps, int paramIndex, @Nullable String content) throws SQLException;

Source Link

Document

Set the given content as String on the given statement, using the given parameter index.

Usage

From source file:egovframework.com.cmm.AltibaseClobStringTypeHandler.java

protected void setParameterInternal(PreparedStatement ps, int index, Object value, String jdbcType,
        LobCreator lobCreator) throws SQLException {
    lobCreator.setClobAsString(ps, index, (String) value);
}

---

From source file:org.fireflow.engine.persistence.springjdbc.PersistenceServiceSpringJdbcImpl.java

public void saveOrUpdateWorkflowDefinition(final WorkflowDefinition workflowDef) {

    if (workflowDef.getId() == null || workflowDef.getId().equals("")) {
        Integer latestVersion = findTheLatestVersionNumberIgnoreState(workflowDef.getProcessId());
        if (latestVersion != null) {
            workflowDef.setVersion(new Integer(latestVersion.intValue() + 1));
        } else {//from   w w w  . j av a2 s . c o  m
            workflowDef.setVersion(new Integer(1));
        }
    }

    // this.getHibernateTemplate().saveOrUpdate(workflowDef);

    if (workflowDef.getId() == null) {
        StringBuffer sql = new StringBuffer();
        sql.append(" INSERT INTO t_ff_df_workflowdef(");
        sql.append("id,definition_type,process_id,name,display_name,");
        sql.append("description,version,state,upload_user,upload_time,");
        sql.append("publish_user,publish_time,process_content )");
        sql.append(" VALUES(?,?,?,?,?, ?,?,?,?,?, ?,?,?)");

        if (show_sql) {
            System.out.println("FIREWORKFLOW_JDCB:" + sql.toString());
        }

        super.getJdbcTemplate().execute(sql.toString(),
                new AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {
                    protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                        ps.setString(1, java.util.UUID.randomUUID().toString().replace("-", ""));
                        ps.setString(2, workflowDef.getDefinitionType());
                        ps.setString(3, workflowDef.getProcessId());
                        ps.setString(4, workflowDef.getName());
                        ps.setString(5, workflowDef.getDisplayName());

                        ps.setString(6, workflowDef.getDescription());
                        ps.setInt(7, workflowDef.getVersion());
                        ps.setInt(8, workflowDef.getState() == true ? 1 : 0);
                        ps.setString(9, workflowDef.getUploadUser());
                        ps.setTimestamp(10, getSqlDateTime(workflowDef.getUploadTime()));

                        ps.setString(11, workflowDef.getPublishUser());
                        ps.setTimestamp(12, getSqlDateTime(workflowDef.getPublishTime()));
                        lobCreator.setClobAsString(ps, 13, workflowDef.getProcessContent());
                    }
                });

    } else {
        StringBuffer sql = new StringBuffer();
        sql.append(" update t_ff_df_workflowdef ");
        sql.append("set definition_type=?,process_id=?,name=?,display_name=?,");
        sql.append("description=?,version=?,state=?,upload_user=?,upload_time=?,");
        sql.append("publish_user=?,publish_time=?,process_content=? ");
        sql.append(" where id=? ");

        if (show_sql) {
            System.out.println("FIREWORKFLOW_JDCB:" + sql.toString());
        }

        super.getJdbcTemplate().execute(sql.toString(),
                new AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {
                    protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {

                        ps.setString(1, workflowDef.getDefinitionType());
                        ps.setString(2, workflowDef.getProcessId());
                        ps.setString(3, workflowDef.getName());
                        ps.setString(4, workflowDef.getDisplayName());

                        ps.setString(5, workflowDef.getDescription());
                        ps.setInt(6, workflowDef.getVersion());
                        ps.setInt(7, workflowDef.getState() == true ? 1 : 0);
                        ps.setString(8, workflowDef.getUploadUser());
                        ps.setTimestamp(9, getSqlDateTime(workflowDef.getUploadTime()));

                        ps.setString(10, workflowDef.getPublishUser());
                        ps.setTimestamp(11, getSqlDateTime(workflowDef.getPublishTime()));
                        lobCreator.setClobAsString(ps, 12, workflowDef.getProcessContent());

                        ps.setString(13, workflowDef.getId());
                    }
                });
    }

}

---