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

Package org.springframework.jdbc.core.support

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

org.springframework.jdbc.core.support.SqlLobValue
able object LobHandler lobHandler = new DefaultLobHandler(); // reusable object jdbcTemplate.update( "INSERT INTO imagedb (image_name, content, description) VALUES (?, ?, ?)", new Object[] { name, new SqlLobValue(contentStream, contentLength, lobHandler), new SqlLobValue(description, lobHandler) }, new int[] {Types.VARCHAR, Types.BLOB, Types.CLOB}); @author Thomas Risberg @author Juergen Hoeller @since 1.1 @see org.springframework.jdbc.support.lob.LobHandler @see org.springframework.jdbc.support.lob.LobCreator @see org.springframework.jdbc.core.JdbcTemplate#update(String,Object[],int[]) @see org.springframework.jdbc.object.SqlUpdate#update(Object[]) @see org.springframework.jdbc.object.StoredProcedure#execute(java.util.Map)

  }


  private void storeRawSecurityDetail(RawSecurity security) {
    final DbMapSqlParameterSource rawArgs = new DbMapSqlParameterSource()
      .addValue("security_id", extractRowId(security.getUniqueId()))
      .addValue("raw_data", new SqlLobValue(security.getRawData(), getDialect().getLobHandler()), Types.BLOB);
    final String sqlRaw = getElSqlBundle().getSql("InsertRaw", rawArgs);
    getJdbcTemplate().update(sqlRaw, rawArgs);
  }

View Full Code Here

          .addTimestampNullFuture("ver_to_instant", document.getVersionToInstant())
          .addTimestamp("corr_from_instant", document.getCorrectionFromInstant())
          .addTimestampNullFuture("corr_to_instant", document.getCorrectionToInstant())
          .addValue("name", document.getName())
          .addValue("config_type", document.getType().getName())
          .addValue("config", new SqlLobValue(bytes, getDialect().getLobHandler()), Types.BLOB);
      final String sqlDoc = getElSqlBundle().getSql("Insert", docArgs);
      getJdbcTemplate().update(sqlDoc, docArgs);
      return document;
    } finally {
      context.stop();

View Full Code Here

      .addTimestampNullFuture("ver_to_instant", document.getVersionToInstant())
      .addTimestamp("corr_from_instant", document.getCorrectionFromInstant())
      .addTimestampNullFuture("corr_to_instant", document.getCorrectionToInstant())
      .addValue("name", document.getName())
      .addValue("time_zone", exchange.getTimeZone() != null ? exchange.getTimeZone().getId() : null, Types.VARCHAR)
      .addValue("detail", new SqlLobValue(bytes, getDialect().getLobHandler()), Types.BLOB);
    // the arguments for inserting into the idkey tables
    final List<DbMapSqlParameterSource> assocList = new ArrayList<DbMapSqlParameterSource>();
    final List<DbMapSqlParameterSource> idKeyList = new ArrayList<DbMapSqlParameterSource>();
    final String sqlSelectIdKey = getElSqlBundle().getSql("SelectIdKey");
    for (ExternalId id : exchange.getExternalIdBundle()) {

View Full Code Here

0 1

TOP

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

com.opengamma.masterdb.config.AbstractDbConfigMasterWorkerTest

com.opengamma.masterdb.config.DbConfigWorker

com.opengamma.masterdb.exchange.AbstractDbExchangeMasterWorkerTest

com.opengamma.masterdb.exchange.DbExchangeMaster

com.opengamma.masterdb.marketdatasnapshot.DbMarketDataSnapshotMaster

com.opengamma.masterdb.security.DbSecurityMaster

com.taobao.tddl.common.jdbc.ArgPreparedStatementSetter

com.taobao.tddl.common.jdbc.ArgTypePreparedStatementSetter

org.springframework.jdbc.support.lob.DefaultLobHandler

org.springframework.security.oauth2.client.token.JdbcClientTokenServices

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.