org.skife.jdbi.v2.DBI.useHandle 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("PMD.EmptyCatchBlock")
public void destroy() {
  try {
    dbi.useHandle(h -> h.execute("DROP TABLE filestore"));
  } catch (CallbackFailedException ex) {
    // simply ignore
  }
}

@SuppressWarnings("PMD.EmptyCatchBlock")
public void destroy() {
  try {
    dbi.useHandle(h -> h.execute("DROP TABLE filestore"));
  } catch (CallbackFailedException ex) {
    // simply ignore
  }
}

@SuppressWarnings("PMD.EmptyCatchBlock")
public void destroy() {
  try {
    dbi.useHandle(h -> h.execute("DROP TABLE filestore"));
  } catch (CallbackFailedException ex) {
    // simply ignore
  }
}

@SuppressWarnings("PMD.EmptyCatchBlock")
public void destroy() {
  try {
    dbi.useHandle(h -> h.execute("DROP TABLE icon_filestore"));
  } catch (CallbackFailedException ex) {
    // simply ignore
  }
}

  @Test
  public void testUseHandle() throws Exception
  {
    DBI dbi = new DBI(DERBY_HELPER.getDataSource());
    dbi.useHandle(new HandleConsumer() {
      @Override
      public void useHandle(Handle handle) throws Exception {
        handle.insert("insert into something (id, name) values (1, 'Brian')");
        String value = handle.createQuery("select name from something where id = 1").map(Something.class).first().getName();
        assertEquals("Brian", value);
      }
    });
  }
}

public void init() {
  boolean needsInitialization = !dbi.inTransaction((h, s) -> tableExists(h, "filestore"));
  if (needsInitialization) {
    try {
      dbi.useHandle(h -> {
        if (databaseKind == DatabaseKind.PostgreSQL) {
          h.execute("CREATE TABLE filestore (path VARCHAR COLLATE \"C\" PRIMARY KEY, data OID)");
        } else if (databaseKind == DatabaseKind.H2) {
          h.execute("CREATE TABLE filestore (path VARCHAR PRIMARY KEY, data BLOB)");
        } else if (databaseKind == DatabaseKind.Apache_Derby) {
          h.execute("CREATE TABLE filestore (path VARCHAR(1000), data BLOB, PRIMARY KEY (path))");
        } else {
          throw new DaoException("Unsupported database kind: " + databaseKind);
        }
      });
    } catch (CallbackFailedException ex) {
      throw new DaoException("Unable to initialize the filestore", ex);
    }
  }
}

@Override
public void init() {
  boolean needsInitialization = !dbi.inTransaction((h, s) -> tableExists(h, "icon_filestore"));
  if (needsInitialization) {
    try {
      dbi.useHandle(h -> {
        if (databaseKind == DatabaseKind.PostgreSQL) {
          h.execute("CREATE TABLE icon_filestore (id VARCHAR COLLATE \"C\" PRIMARY KEY, data OID)");
        } else if (databaseKind == DatabaseKind.H2) {
          h.execute("CREATE TABLE icon_filestore (id VARCHAR PRIMARY KEY, data BLOB)");
        } else if (databaseKind == DatabaseKind.Apache_Derby) {
          h.execute("CREATE TABLE icon_filestore (id VARCHAR(1000), data BLOB, PRIMARY KEY (path))");
        } else {
          throw new IconDataAccessException("Unsupported database kind: " + databaseKind);
        }
      });
    } catch (CallbackFailedException ex) {
      throw new IconDataAccessException("Unable to initialize the icon_filestore", ex);
    }
  }
}

public void init() {
  boolean needsInitialization = !dbi.inTransaction((h, s) -> tableExists(h, "filestore"));
  if (needsInitialization) {
    try {
      dbi.useHandle(h -> {
        if (databaseKind == DatabaseKind.PostgreSQL) {
          h.execute("CREATE TABLE filestore (path VARCHAR COLLATE \"C\" PRIMARY KEY, data OID)");
        } else if (databaseKind == DatabaseKind.H2) {
          h.execute("CREATE TABLE filestore (path VARCHAR PRIMARY KEY, data BLOB)");
        } else if (databaseKind == DatabaseKind.Apache_Derby) {
          h.execute("CREATE TABLE filestore (path VARCHAR(1000), data BLOB, PRIMARY KEY (path))");
        } else {
          throw new DaoException("Unsupported database kind: " + databaseKind);
        }
      });
    } catch (CallbackFailedException ex) {
      throw new DaoException("Unable to initialize the filestore", ex);
    }
  }
}

@Override
public void init() {
  boolean needsInitialization = !dbi.inTransaction((h, s) -> tableExists(h, "filestore"));
  if (needsInitialization) {
    try {
      dbi.useHandle(h -> {
        if (databaseKind == DatabaseKind.PostgreSQL) {
          h.execute("CREATE TABLE filestore (path VARCHAR COLLATE \"C\" PRIMARY KEY, data OID)");
        } else if (databaseKind == DatabaseKind.H2) {
          h.execute("CREATE TABLE filestore (path VARCHAR PRIMARY KEY, data BLOB)");
        } else if (databaseKind == DatabaseKind.Apache_Derby) {
          h.execute("CREATE TABLE filestore (path VARCHAR(1000), data BLOB, PRIMARY KEY (path))");
        } else {
          throw new ExtensionDataAccessException("Unsupported database kind: " + databaseKind);
        }
      });
    } catch (CallbackFailedException ex) {
      throw new ExtensionDataAccessException("Unable to initialize the filestore", ex);
    }
  }
}

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
setSQLLog
Specify the class used to log sql statements. Will be passed to all handles created from this instan
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

Popular in Java

Creating JSON documents from java classes using gson
startActivity (Activity)
compareTo (BigDecimal)
getExternalFilesDir (Context)
FileReader (java.io)
A specialized Reader that reads from a file in the file system. All read requests made by calling me
KeyStore (java.security)
KeyStore is responsible for maintaining cryptographic keys and their owners. The type of the syste
SQLException (java.sql)
An exception that indicates a failed JDBC operation. It provides the following information about pro
Date (java.util)
A specific moment in time, with millisecond precision. Values typically come from System#currentTime
JarFile (java.util.jar)
JarFile is used to read jar entries and their associated data from jar files.
Join (org.hibernate.mapping)
Top 12 Jupyter Notebook Extensions

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

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

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