Examples of org.springframework.jdbc.support.lob.DefaultLobHandler

Package org.springframework.jdbc.support.lob

Examples of org.springframework.jdbc.support.lob.DefaultLobHandler

org.springframework.jdbc.support.lob.DefaultLobHandler
Default implementation of the {@link LobHandler} interface. Invokesthe direct accessor methods that java.sql.ResultSet and java.sql.PreparedStatement offer.
This LobHandler should work for any JDBC driver that is JDBC compliant in terms of the spec's suggestions regarding simple BLOB and CLOB handling. This does not apply to Oracle 9i, and only to a limited degree to Oracle 10g! As a consequence, use {@link OracleLobHandler} for accessing Oracle BLOBs/CLOBs. @author Juergen Hoeller @since 04.12.2003 @see #setStreamAsLob @see java.sql.ResultSet#getBytes @see java.sql.ResultSet#getBinaryStream @see java.sql.ResultSet#getString @see java.sql.ResultSet#getAsciiStream @see java.sql.ResultSet#getCharacterStream @see java.sql.PreparedStatement#setBytes @see java.sql.PreparedStatement#setBinaryStream @see java.sql.PreparedStatement#setString @see java.sql.PreparedStatement#setAsciiStream @see java.sql.PreparedStatement#setCharacterStream

    lobCreator.setBlobAsBytes(ps, 1, content);
    psControl.verify();
  }


  public void testSetBlobAsBinaryStream() throws SQLException, IOException {
    LobCreator lobCreator = (new DefaultLobHandler()).getLobCreator();
    InputStream bis = new ByteArrayInputStream("testContent".getBytes());


    MockControl psControl = MockControl.createControl(PreparedStatement.class);
    PreparedStatement ps = (PreparedStatement) psControl.getMock();
    ps.setBinaryStream(1, bis, 11);

View Full Code Here

    lobCreator.setBlobAsBinaryStream(ps, 1, bis, 11);
    psControl.verify();
  }


  public void testSetClobAsString() throws SQLException, IOException {
    LobCreator lobCreator = (new DefaultLobHandler()).getLobCreator();
    String content = "testContent";


    MockControl psControl = MockControl.createControl(PreparedStatement.class);
    PreparedStatement ps = (PreparedStatement) psControl.getMock();
    ps.setString(1, content);

View Full Code Here

    lobCreator.setClobAsString(ps, 1, content);
    psControl.verify();
  }


  public void testSetClobAsAsciiStream() throws SQLException, IOException {
    LobCreator lobCreator = (new DefaultLobHandler()).getLobCreator();
    InputStream bis = new ByteArrayInputStream("testContent".getBytes());


    MockControl psControl = MockControl.createControl(PreparedStatement.class);
    PreparedStatement ps = (PreparedStatement) psControl.getMock();
    ps.setAsciiStream(1, bis, 11);

View Full Code Here

    lobCreator.setClobAsAsciiStream(ps, 1, bis, 11);
    psControl.verify();
  }


  public void testSetClobAsCharacterStream() throws SQLException, IOException {
    LobCreator lobCreator = (new DefaultLobHandler()).getLobCreator();
    Reader str = new StringReader("testContent");


    MockControl psControl = MockControl.createControl(PreparedStatement.class);
    PreparedStatement ps = (PreparedStatement) psControl.getMock();
    ps.setCharacterStream(1, str, 11);

View Full Code Here


              @Override
              public void processRow(ResultSet rs)
                  throws SQLException {
                if (!bFirstRowRead) {
                  LobHandler lobHandler = new DefaultLobHandler();
                  String clobText = lobHandler
                      .getClobAsString(rs, 1);
                  aCAS.setDocumentText(clobText);
                  bFirstRowRead = true;
                } else {
                  log.error("Multiple documents for document key: "

View Full Code Here

    props.load(in);


    datasource = new DriverManagerDataSource(props.getProperty("db.url"), props.getProperty("db.username"), props.getProperty("db.password"));


    DataObjectFactory dataObjectFactory = new TgacDataObjectFactory();
    LobHandler lh = new DefaultLobHandler();
    JdbcTemplate template = new JdbcTemplate(datasource);


    //securityDAO = new SQLSecurityDAO();
    securityDAO = new MockSQLSecurityDAO();
    securityDAO.setLobHandler(lh);

View Full Code Here

      databaseType = DatabaseType.fromMetaData(dataSource).name();
      logger.info("No database type set, using meta data indicating: " + databaseType);
    }


    if (lobHandler == null) {
      lobHandler = new DefaultLobHandler();
    }


    if (serializer == null) {
      XStreamExecutionContextStringSerializer defaultSerializer = new XStreamExecutionContextStringSerializer();
      defaultSerializer.afterPropertiesSet();

View Full Code Here

    when(incrementerFactory.getIncrementer("ORACLE", tablePrefix + "JOB_SEQ")).thenReturn(new StubIncrementer());
    when(incrementerFactory.getIncrementer("ORACLE", tablePrefix + "JOB_EXECUTION_SEQ")).thenReturn(new StubIncrementer());
    when(incrementerFactory.getIncrementer("ORACLE", tablePrefix + "STEP_EXECUTION_SEQ")).thenReturn(new StubIncrementer());
    factory.setIncrementerFactory(incrementerFactory);


    LobHandler lobHandler = new DefaultLobHandler();
    factory.setLobHandler(lobHandler);


    factory.afterPropertiesSet();
    assertEquals(lobHandler, ReflectionTestUtils.getField(factory, "lobHandler"));

View Full Code Here

    _version1Instant = now.minusSeconds(100);
    _version2Instant = now.minusSeconds(50);
    s_logger.debug("test data now:   {}", _version1Instant);
    s_logger.debug("test data later: {}", _version2Instant);
    FudgeContext fudgeContext = OpenGammaFudgeContext.getInstance();
    LobHandler lobHandler = new DefaultLobHandler();
    final JdbcOperations template = _exgMaster.getDbConnector().getJdbcOperations();
    ManageableExchange exchange = new ManageableExchange();
    exchange.setUniqueId(UniqueId.of("DbExg", "101", "0"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("A", "B"), ExternalId.of("C", "D"), ExternalId.of("E", "F")));
    exchange.setName("TestExchange101");

View Full Code Here


  private void addExternalIds() {
    FudgeMsgEnvelope env = s_fudgeContext.toFudgeMsg(ExternalId.of("A", "B"));
    byte[] bytes = s_fudgeContext.toByteArray(env.getMessage());
    String cls = ExternalId.class.getName();
    LobHandler lobHandler = new DefaultLobHandler();
    final JdbcOperations template = _cfgMaster.getDbConnector().getJdbcOperations();
    template.update("INSERT INTO cfg_config VALUES (?,?,?,?,?, ?,?,?,?)",
        101, 101, toSqlTimestamp(_version1aInstant), MAX_SQL_TIMESTAMP, toSqlTimestamp(_version1aInstant), MAX_SQL_TIMESTAMP, "TestConfig101", cls,
        new SqlParameterValue(Types.BLOB, new SqlLobValue(bytes, lobHandler)));
    template.update("INSERT INTO cfg_config VALUES (?,?,?,?,?, ?,?,?,?)",

View Full Code Here

0 1 2

TOP

Related Classes of org.springframework.jdbc.support.lob.DefaultLobHandler

com.opengamma.masterdb.config.AbstractDbConfigMasterWorkerTest

com.opengamma.masterdb.exchange.AbstractDbExchangeMasterWorkerTest

com.opengamma.util.db.DbDialect

com.opengamma.util.db.HSQLDbDialect

org.apache.ctakes.ytex.uima.DBCollectionReader

org.geoserver.jdbcconfig.internal.InfoRowMapper

org.springframework.batch.admin.service.SimpleJobServiceFactoryBean

org.springframework.batch.core.repository.support.JobRepositoryFactoryBeanTests

org.springframework.jdbc.core.support.SqlLobValue

org.springframework.jdbc.support.DefaultLobHandlerTests

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.