Examples of org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback

Package org.springframework.jdbc.core.support

Examples of org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback

org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback
able object LobHandler lobHandler = new DefaultLobHandler(); // reusable object jdbcTemplate.execute( "INSERT INTO imagedb (image_name, content, description) VALUES (?, ?, ?)", new AbstractLobCreatingPreparedStatementCallback(lobHandler) { protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException { ps.setString(1, name); lobCreator.setBlobAsBinaryStream(ps, 2, contentStream, contentLength); lobCreator.setClobAsString(ps, 3, description); } } ); @author Juergen Hoeller @since 1.0.2 @see org.springframework.jdbc.support.lob.LobCreator

                    if (isReturnOldExchange() && present) {
                        result = get(key, getRepositoryName(), camelContext);
                    }


                    jdbcTemplate.execute(sql,
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, key);
                                }

View Full Code Here


                    jdbcTemplate.update("DELETE FROM " + getRepositoryName() + " WHERE " + ID + " = ?",
                            new Object[]{key});


                    jdbcTemplate.execute("INSERT INTO " + getRepositoryNameCompleted() + " (" + EXCHANGE + ", " + ID + ") VALUES (?, ?)",
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, confirmKey);
                                }

View Full Code Here

      {
        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());

View Full Code Here

                    if (isReturnOldExchange() && present) {
                        result = get(key, getRepositoryName(), camelContext);
                    }


                    jdbcTemplate.execute(sql,
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, key);
                                }

View Full Code Here


                    jdbcTemplate.update("DELETE FROM " + getRepositoryName() + " WHERE " + ID + " = ?",
                            new Object[]{key});


                    jdbcTemplate.execute("INSERT INTO " + getRepositoryNameCompleted() + " (" + EXCHANGE + ", " + ID + ") VALUES (?, ?)",
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, confirmKey);
                                }

View Full Code Here

      final String name, final InputStream contentStream, final int contentLength, final String description)
      throws DataAccessException {


    getJdbcTemplate().execute(
        "INSERT INTO imagedb (image_name, content, description) VALUES (?, ?, ?)",
        new AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {
          protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            ps.setString(1, name);
            lobCreator.setBlobAsBinaryStream(ps, 2, contentStream, contentLength);
            lobCreator.setClobAsString(ps, 3, description);
          }

View Full Code Here

                    if (isReturnOldExchange() && present) {
                        result = get(key, getRepositoryName(), camelContext);
                    }


                    jdbcTemplate.execute(sql,
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, key);
                                }

View Full Code Here


                    jdbcTemplate.update("DELETE FROM " + getRepositoryName() + " WHERE " + ID + " = ?",
                            new Object[]{key});


                    jdbcTemplate.execute("INSERT INTO " + getRepositoryNameCompleted() + " (" + EXCHANGE + ", " + ID + ") VALUES (?, ?)",
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, confirmKey);
                                }

View Full Code Here

                    if (isReturnOldExchange() && present) {
                        result = get(key, getRepositoryName(), camelContext);
                    }


                    jdbcTemplate.execute(sql,
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, key);
                                }

View Full Code Here


                    jdbcTemplate.update("DELETE FROM " + getRepositoryName() + " WHERE " + ID + " = ?",
                            new Object[]{key});


                    jdbcTemplate.execute("INSERT INTO " + getRepositoryNameCompleted() + " (" + EXCHANGE + ", " + ID + ") VALUES (?, ?)",
                            new AbstractLobCreatingPreparedStatementCallback(getLobHandler()) {
                                @Override
                                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                                    lobCreator.setBlobAsBytes(ps, 1, data);
                                    ps.setString(2, confirmKey);
                                }

View Full Code Here

0 1

TOP

Related Classes of org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback

org.apache.camel.component.jdbc.aggregationrepository.JdbcAggregationRepository

org.apache.camel.processor.aggregate.jdbc.JdbcAggregationRepository

org.fireflow.engine.persistence.springjdbc.PersistenceServiceSpringJdbcImpl

org.springframework.jdbc.support.lob.LobCreator

org.springframework.samples.imagedb.DefaultImageDatabase

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.