How to use

setSQLLog

method

in

org.skife.jdbi.v2.DBI

@SuppressWarnings({"unchecked", "rawtypes"})
@Override
public void configure(final Env env, final Config config, final Binder binder) {
 Key<DataSource> dskey = Key.get(DataSource.class, Names.named(name));
 DataSource ds = env.get(dskey)
   .orElseThrow(() -> new NoSuchElementException("DataSource missing: " + dskey));
 DBI dbi = new DBI2(ds);
 dbi.setSQLLog(new SLF4JLog());
 dbi.registerArgumentFactory(new OptionalArgumentFactory());
 dbi.registerArgumentFactory(new IterableArgumentFactory());
 dbi.registerContainerFactory(new OptionalContainerFactory());
 dbi.setStatementRewriter(new ExpandedStmtRewriter());
 ServiceKey serviceKey = env.serviceKey();
 serviceKey.generate(DBI.class, name, k -> binder.bind(k).toInstance(dbi));
 serviceKey.generate(Handle.class, name, k -> binder.bind(k).toProvider(() -> dbi.open()));
 sqlObjects.forEach(sqlObject -> binder.bind(sqlObject)
   .toProvider((Provider) () -> dbi.open(sqlObject)));
 if (callback != null) {
  callback.accept(dbi, config);
 }
}

dbi.setSQLLog(new LogbackLog(LOGGER, Level.TRACE));

@SuppressWarnings("SpringJavaAutowiringInspection")
@Bean
public DBI jdbiFactory(DataSource dataSource) {
  // note that for JDBI we have to wrap datasource with TransactionAwareDataSourceProxy otherwise JDBI won't respect
  // transactions created by spring
  TransactionAwareDataSourceProxy transactionAwareDataSourceProxy = new TransactionAwareDataSourceProxy(dataSource);
  DBI dbi = new DBI(transactionAwareDataSourceProxy);
  dbi.setSQLLog(new SLF4JLog());  // to enable SLF4J logging
  return dbi;
}

SqlObjectRepository() {
  _dbiInstance = new DBI(_connectionHelper.getDataSource());
  _dbiInstance.setSQLLog(new Log4JLog());

@SuppressWarnings({"unchecked", "rawtypes"})
@Override
public void configure(final Env env, final Config config, final Binder binder) {
 Key<DataSource> dskey = Key.get(DataSource.class, Names.named(name));
 DataSource ds = env.get(dskey)
   .orElseThrow(() -> new NoSuchElementException("DataSource missing: " + dskey));
 DBI dbi = new DBI2(ds);
 dbi.setSQLLog(new SLF4JLog());
 dbi.registerArgumentFactory(new OptionalArgumentFactory());
 dbi.registerArgumentFactory(new IterableArgumentFactory());
 dbi.registerContainerFactory(new OptionalContainerFactory());
 dbi.setStatementRewriter(new ExpandedStmtRewriter());
 ServiceKey serviceKey = env.serviceKey();
 serviceKey.generate(DBI.class, name, k -> binder.bind(k).toInstance(dbi));
 serviceKey.generate(Handle.class, name, k -> binder.bind(k).toProvider(() -> dbi.open()));
 sqlObjects.forEach(sqlObject -> binder.bind(sqlObject)
   .toProvider((Provider) () -> dbi.open(sqlObject)));
 if (callback != null) {
  callback.accept(dbi, config);
 }
}

@Override
public IDBI get() {
  final DBI dbi = new DBI(ds);
  for (final ArgumentFactory argumentFactory : argumentFactorySet) {
    dbi.registerArgumentFactory(argumentFactory);
  }
  for (final ResultSetMapperFactory resultSetMapperFactory : resultSetMapperFactorySet) {
    dbi.registerMapper(resultSetMapperFactory);
  }
  for (final ResultSetMapper resultSetMapper : resultSetMapperSet) {
    dbi.registerMapper(resultSetMapper);
  }
  if (transactionHandler != null) {
    dbi.setTransactionHandler(transactionHandler);
  }
  if (sqlLog != null) {
    dbi.setSQLLog(sqlLog);
  } else if (config != null) {
    final Slf4jLogging sqlLog = new Slf4jLogging(logger, config.getLogLevel());
    dbi.setSQLLog(sqlLog);
  }
  if (timingCollector != null) {
    dbi.setTimingCollector(timingCollector);
  }
  return dbi;
}

@Before
public void setUp() throws Exception
{
  dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID());
  dbi.setSQLLog(new PrintStreamLog(System.out));
  handle = dbi.open();
  handle.execute("create table something( id integer primary key, name varchar(100) )");
}

@Before
public void setUp() throws Exception
{
  dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID());
  dbi.setSQLLog(new PrintStreamLog(System.out));
  handle = dbi.open();
  handle.execute("create table something( id integer primary key, name varchar(100) )");
}

@Before
public void setUp() throws Exception
{
  dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID());
  dbi.setSQLLog(new PrintStreamLog(System.out));
  handle = dbi.open();
  handle.execute("create table something( id integer primary key, name varchar(100) )");
}

@Before
public void setUp() throws Exception
{
  dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID());
  dbi.setSQLLog(new PrintStreamLog(System.out));
  handle = dbi.open();
  handle.execute("create table something( id integer primary key, name varchar(100) )");
}

@Before
public void setUp() throws Exception
{
  dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID());
  dbi.setSQLLog(new PrintStreamLog(System.out));
  handle = dbi.open();
  handle.execute("create table something( id integer primary key, name varchar(100) )");
  handle.execute("CREATE ALIAS stored_insert FOR \"org.skife.jdbi.v2.sqlobject.TestSqlCall.insertSomething\";");
}

@Before
public void setUp() throws Exception
{
  dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID());
  dbi.registerMapper(new SomethingMapper());
  dbi.setSQLLog(new PrintStreamLog(System.out));
  handle = dbi.open();
  handle.execute("create table something( id integer primary key, name varchar(100) )");
  handle.execute("CREATE ALIAS stored_insert FOR \"org.skife.jdbi.v2.sqlobject.TestSqlCall.insertSomething\";");
}

@Override
public DBI get() {
 final DBI dbi = new DBI(transactionalDataSource);
 dbi.setSQLLog(new LogbackLog());
 if (environment.isPresent()) {
  environment.get().lifecycle().manage(managedDataSource);
  environment.get().healthChecks().register("db", new DBIHealthCheck(dbi, dataSourceFactory.getValidationQuery()));
  dbi.setTimingCollector(new InstrumentedTimingCollector(environment.get().metrics(), new SanerNamingStrategy()));
 }
 dbi.registerArgumentFactory(new OptionalArgumentFactory(dataSourceFactory.getDriverClass()));
 dbi.registerContainerFactory(new ImmutableListContainerFactory());
 dbi.registerContainerFactory(new ImmutableSetContainerFactory());
 dbi.registerContainerFactory(new OptionalContainerFactory());
 dbi.registerArgumentFactory(new JodaDateTimeArgumentFactory());
 dbi.registerMapper(new JodaDateTimeMapper());
 dbi.registerMapper(new RosettaMapperFactory());
 new RosettaObjectMapperOverride(objectMapper).override(dbi);
 return dbi;
}

@Before
public void setUp() throws Exception {
  JdbcDataSource ds = new JdbcDataSource();
  ds.setURL("jdbc:h2:mem:" + UUID.randomUUID());
  DBI dbi = new DBI(ds);
  dbi.setSQLLog(new PrintStreamLog());
  handle = dbi.open();
  somethingDao = handle.attach(SomethingDao.class);
  handle.execute("create table something (something_id int primary key, name varchar(100), code int)");
  handle.execute("insert into something(something_id, name, code) values (1, 'Brian', 12)");
  handle.execute("insert into something(something_id, name, code) values (2, 'Keith', 27)");
  handle.execute("insert into something(something_id, name, code) values (3, 'Coda', 14)");
}

@Override
public DataSource get() {
  final DataSource ds = getDataSource();
  final DBI dbi = new DBI(ds);
  dbi.registerArgumentFactory(new UUIDArgumentFactory());
  dbi.registerArgumentFactory(new DateTimeZoneArgumentFactory());
  dbi.registerArgumentFactory(new DateTimeArgumentFactory());
  dbi.registerArgumentFactory(new LocalDateArgumentFactory());
  dbi.registerArgumentFactory(new EnumArgumentFactory());
  dbi.registerMapper(new UuidMapper());
  if (sqlLog != null) {
    dbi.setSQLLog(sqlLog);
  }
  return ds;
}

@Before
public void setUp() throws Exception {
  JdbcDataSource ds = new JdbcDataSource();
  ds.setURL("jdbc:h2:mem:" + UUID.randomUUID());
  DBI dbi = new DBI(ds);
  dbi.setSQLLog(new PrintStreamLog());
  handle = dbi.open();
  somethingDao = handle.attach(SomethingDao.class);
  handle.execute("create table something (something_id int primary key, name varchar(100), code int)");
  handle.execute("insert into something(something_id, name, code) values (1, 'Brian', 12)");
  handle.execute("insert into something(something_id, name, code) values (2, 'Keith', 27)");
  handle.execute("insert into something(something_id, name, code) values (3, 'Coda', 14)");
}

private void registerDBIFactoryComponent(Environment environment, MayocatShopSettings configuration)
    throws ClassNotFoundException, ComponentRepositoryException
{
  final DBIFactory factory = new DBIFactory();
  final DBI jdbi = factory.build(environment, configuration.getDataSourceFactory(), "jdbi");
  jdbi.registerArgumentFactory(new PostgresUUIDArgumentFactory());
  jdbi.registerArgumentFactory(new PostgresUUIDArrayArgumentFactory());
  if (configuration.getDevelopmentEnvironment().isEnabled() &&
      configuration.getDevelopmentEnvironment().isLogDatabaseRequests())
  {
    jdbi.setSQLLog(new PrintStreamLog());
  }
  final DBIProvider dbi = new DBIProvider()
  {
    @Override
    public DBI get()
    {
      return jdbi;
    }
  };
  DefaultComponentDescriptor<DBIProvider> cd = new DefaultComponentDescriptor<DBIProvider>();
  cd.setRoleType(DBIProvider.class);
  getComponentManager().registerComponent(cd, dbi);
}

final DBI dbi = new DBI(ds);
if (sqlLog != null) {
  dbi.setSQLLog(sqlLog);

dbi.setSQLLog(new LogbackLog(LOGGER, Level.TRACE));