public static LobHandler getAppropriateLobHandler(Factory factory) { LobHandler lobHandler = null; switch( factory.getDialect() ) { case ORACLE: lobHandler = new OracleLobHandler(); break; default: lobHandler = new DefaultLobHandler(); break; } return lobHandler; }
// ... final byte[] bytes= IOUtils.toByteArray(input); final OracleLobHandler lobHandler = new OracleLobHandler(); final lobHandler.setNativeJdbcExtractor(new JBossNativeJdbcExtractor()); // ... new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection con) throws SQLException { String procedure = "call SAVE_DATA(?,?)"; CallableStatement stm=con.prepareCall(procedure); lobHandler.getLobCreator().setLobAsBytes(smt, 1, bytes, bytes.length); stm.setDate(2, date); return stm; } } // ...
getJdbcTemplate().query(getFileContentSql, new RowMapper<Void>() { public void mapRow(ResultSet rs, int rowNum) throws SQLException { OracleLobHandler lobHandler = new OracleLobHandler(); InputStream inputStream = lobHandler.getBlobAsBinaryStream(rs, "file_content"); ExlImporter importer = new ExlBOMImporter(inputStream); importer.process(); } }, fileId);
public void afterPropertiesSet() throws MetaDataAccessException { Assert.notNull(dataSource, "Data source is not set!"); String dbName = (String)JdbcUtils.extractDatabaseMetaData(dataSource, "getDatabaseProductName"); if (SpringLobHandlerDetectorFactoryBean.ORACLE_DB_NAME.equals(dbName)) { final OracleLobHandler oracleLobHandler = new OracleLobHandler(); lobHandler = oracleLobHandler; if (pooledConnection) { oracleLobHandler.setNativeJdbcExtractor(nativeJdbcExtractor); } } else { lobHandler = new DefaultLobHandler(); } } }
public void afterPropertiesSet() throws MetaDataAccessException { Assert.notNull(dataSource, "Data source is not set!"); String dbName = (String)JdbcUtils.extractDatabaseMetaData(dataSource, "getDatabaseProductName"); if (SpringLobHandlerDetectorFactoryBean.ORACLE_DB_NAME.equals(dbName)) { final OracleLobHandler oracleLobHandler = new OracleLobHandler(); lobHandler = oracleLobHandler; if (pooledConnection) { oracleLobHandler.setNativeJdbcExtractor(nativeJdbcExtractor); } } else { lobHandler = new DefaultLobHandler(); } } }
public void afterPropertiesSet() throws Exception { Assert.notNull(dataSource, "DataSource must not be null."); jdbcTemplate = new SimpleJdbcTemplate(dataSource); if (incrementerFactory == null) { incrementerFactory = new DefaultDataFieldMaxValueIncrementerFactory(dataSource); } if (databaseType == null) { databaseType = DatabaseType.fromMetaData(dataSource).name(); logger.info("No database type set, using meta data indicating: " + databaseType); } if (lobHandler == null && databaseType.equalsIgnoreCase(DatabaseType.ORACLE.toString())) { lobHandler = new OracleLobHandler(); } Assert.isTrue(incrementerFactory.isSupportedIncrementerType(databaseType), "'" + databaseType + "' is an unsupported database type. The supported database types are " + StringUtils.arrayToCommaDelimitedString(incrementerFactory.getSupportedIncrementerTypes())); super.afterPropertiesSet(); }
@Override protected OracleJdbcSqlTemplate createSqlTemplate() { OracleLobHandler lobHandler = new OracleLobHandler(); lobHandler.setNativeJdbcExtractor(JdbcUtils.getNativeJdbcExtractory()); SymmetricLobHandler symmetricLobHandler = new SymmetricLobHandler(lobHandler); return new OracleJdbcSqlTemplate(dataSource, settings, symmetricLobHandler, getDatabaseInfo()); } public static void main(String[] args) {
@Override public void afterPropertiesSet() throws Exception { Assert.notNull(dataSource, "DataSource must not be null."); if (jdbcOperations == null) { jdbcOperations = new JdbcTemplate(dataSource); } if (incrementerFactory == null) { incrementerFactory = new DefaultDataFieldMaxValueIncrementerFactory(dataSource); } if (databaseType == null) { databaseType = DatabaseType.fromMetaData(dataSource).name(); logger.info("No database type set, using meta data indicating: " + databaseType); } if (lobHandler == null && databaseType.equalsIgnoreCase(DatabaseType.ORACLE.toString())) { lobHandler = new OracleLobHandler(); } if(serializer == null) { XStreamExecutionContextStringSerializer defaultSerializer = new XStreamExecutionContextStringSerializer(); defaultSerializer.afterPropertiesSet(); serializer = defaultSerializer; } Assert.isTrue(incrementerFactory.isSupportedIncrementerType(databaseType), "'" + databaseType + "' is an unsupported database type. The supported database types are " + StringUtils.arrayToCommaDelimitedString(incrementerFactory.getSupportedIncrementerTypes())); if(lobType != null) { Assert.isTrue(isValidTypes(lobType), "lobType must be a value from the java.sql.Types class"); } super.afterPropertiesSet(); }