org.skife.jdbi.v2.DBI.setSQLLog java code examples

Common ways to obtain DBI

private void myMethod () {
 DBI d =DataSource dataSource;new DBI(dataSource)
ConnectionFactory connectionFactory;new DBI(connectionFactory)
String url;String username;String password;new DBI(url, username, password)
Smart code suggestions by Tabnine
}

@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));

Javadoc

Specify the class used to log sql statements. Will be passed to all handles created from this instance

Popular methods of DBI

<init>
Constructor used to allow for obtaining a Connection in a customized manner. The org.skife.jdbi.v2.t
open
onDemand
Create a new sql object which will obtain and release connections from this dbi instance, as it need
registerMapper
Register a result set mapper which will have its parameterized type inspected to determine what it m
withHandle
A convenience function which manages the lifecycle of a handle and yields it to a callback for use b
registerArgumentFactory
inTransaction
registerContainerFactory
setStatementLocator
Use a non-standard StatementLocator to look up named statements for all handles created from this DB
setStatementRewriter
Use a non-standard StatementRewriter to transform SQL for all Handle instances created by this DBI.
setTransactionHandler
Specify the TransactionHandler instance to use. This allows overriding transaction semantics, or map
setTimingCollector
Add a callback to accumulate timing information about the queries running from this data source.

Popular in Java

Running tasks concurrently on multiple threads
getSharedPreferences (Context)
setRequestProperty (URLConnection)
putExtra (Intent)
Table (com.google.common.collect)
A collection that associates an ordered pair of keys, called a row key and a column key, with a sing
FlowLayout (java.awt)
A flow layout arranges components in a left-to-right flow, much like lines of text in a paragraph. F
Font (java.awt)
The Font class represents fonts, which are used to render text in a visible way. A font provides the
FileWriter (java.io)
A specialized Writer that writes to a file in the file system. All write requests made by calling me
JButton (javax.swing)
Base64 (org.apache.commons.codec.binary)
Provides Base64 encoding and decoding as defined by RFC 2045.This class implements section 6.8. Base
21 Best IntelliJ Plugins

How to use setSQLLogmethodin org.skife.jdbi.v2.DBI

Best Java code snippets using org.skife.jdbi.v2.DBI.setSQLLog (Showing top 19 results out of 315)

How to use
setSQLLog
method
in
org.skife.jdbi.v2.DBI