package io.aregger.lob_prefetch;

import java.sql.SQLException;
import java.util.Arrays;

import org.springframework.jdbc.core.JdbcTemplate;

import oracle.jdbc.pool.OracleDataSource;

public class InsertBlob {
    private static JdbcTemplate jdbcTemplate;

    private static final String CONNECTION_STRING = "jdbc:oracle:thin:@oracle-database-183:1521:orcl1803";
    private static final String DATABASE_USER = "lobtest";

    public static void main(String[] args) throws SQLException {
        OracleDataSource ds = new OracleDataSource();
        ds.setURL(CONNECTION_STRING);
        ds.setUser(DATABASE_USER);
        ds.setPassword(DATABASE_USER);
        jdbcTemplate = new JdbcTemplate(ds);

        byte b = 1;
        byte[] ba = new byte[10485760];
        Arrays.fill(ba, b);

        jdbcTemplate.update("insert into blobtest values(?, ?)", 1, ba);
    }

}