How to use

setStatementRewriter

method

in

org.skife.jdbi.v2.DBI

@Inject
public SQLServerConnector(Supplier<MetadataStorageConnectorConfig> config, Supplier<MetadataStorageTablesConfig> dbTables)
{
 super(config, dbTables);
 final BasicDataSource datasource = getDatasource();
 datasource.setDriverClassLoader(getClass().getClassLoader());
 datasource.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
 this.dbi = new DBI(datasource);
 this.dbi.setStatementRewriter(new CustomStatementRewriter());
 log.info("Configured Sql Server as metadata storage");
}

@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.setStatementRewriter(new NamePrependingStatementRewriter(new ColonPrefixNamedParamStatementRewriter()));

@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 void doSetUp() throws Exception
{
  this.dbi = new DBI(DERBY_HELPER.getDataSource());
  dbi.setStatementRewriter(new NoOpStatementRewriter());
}

@Override
public void doSetUp() throws Exception
{
  this.dbi = new DBI(DERBY_HELPER.getDataSource());
  dbi.setStatementRewriter(new NoOpStatementRewriter());
}

@Before
public void setUp() throws Exception
{
  JdbcDataSource ds = new JdbcDataSource();
  ds.setURL(String.format("jdbc:h2:mem:%s", UUID.randomUUID()));
  DBI dbi = new DBI(ds);
  // this is the default, but be explicit for sake of clarity in test
  dbi.setStatementRewriter(new ColonPrefixNamedParamStatementRewriter());
  handle = dbi.open();
  handle.execute("create table something (id int primary key, name varchar(100))");
}

@Before
public void setUp() throws Exception
{
  JdbcDataSource ds = new JdbcDataSource();
  ds.setURL(String.format("jdbc:h2:mem:%s", UUID.randomUUID()));
  DBI dbi = new DBI(ds);
  // this is the default, but be explicit for sake of clarity in test
  dbi.setStatementRewriter(new ColonPrefixNamedParamStatementRewriter());
  handle = dbi.open();
  handle.execute("create table something (id int primary key, name varchar(100))");
}

@Before
public void setUp() throws Exception
{
  JdbcDataSource ds = new JdbcDataSource();
  ds.setURL("jdbc:h2:mem:" + UUID.randomUUID());
  DBI dbi = new DBI(ds);
  // this is the default, but be explicit for sake of clarity in test
  dbi.setStatementRewriter(new ColonPrefixNamedParamStatementRewriter());
  handle = dbi.open();
  handle.execute("create table something (id int primary key, name varchar(100))");
}

@Before
public void setUp() throws Exception
{
  JdbcDataSource ds = new JdbcDataSource();
  ds.setURL("jdbc:h2:mem:" + UUID.randomUUID());
  DBI dbi = new DBI(ds);
  dbi.registerMapper(new SomethingMapper());
  // this is the default, but be explicit for sake of clarity in test
  dbi.setStatementRewriter(new ColonPrefixNamedParamStatementRewriter());
  handle = dbi.open();
  handle.execute("create table something (id int primary key, name varchar(100))");
}

dbi.setStatementRewriter(new NamePrependingStatementRewriter(new ColonPrefixNamedParamStatementRewriter()));