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

org.springframework.jdbc.core.support.AbstractLobStreamingResultSetExtractor

able object final LobHandler lobHandler = new DefaultLobHandler(); // reusable object jdbcTemplate.query( "SELECT content FROM imagedb WHERE image_name=?", new Object[] {name}, new AbstractLobStreamingResultSetExtractor() { public void streamData(ResultSet rs) throws SQLException, IOException { FileCopyUtils.copy(lobHandler.getBlobAsBinaryStream(rs, 1), contentStream); } } ); @author Juergen Hoeller @since 1.0.2 @see org.springframework.jdbc.support.lob.LobHandler @see org.springframework.jdbc.LobRetrievalFailureException


  @Transactional(readOnly=true)
  public void streamImage(final String name, final OutputStream contentStream) throws DataAccessException {
    getJdbcTemplate().query(
        "SELECT content FROM imagedb WHERE image_name=?", new Object[] {name},
        new AbstractLobStreamingResultSetExtractor() {
          protected void handleNoRowFound() throws LobRetrievalFailureException {
            throw new EmptyResultDataAccessException(
                "Image with name '" + name + "' not found in database", 1);
          }
          public void streamData(ResultSet rs) throws SQLException, IOException {

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.

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

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