ch.qos.logback.core.db.dialect.DBUtil java code examples

Common ways to obtain DBUtil

private void myMethod () {
 DBUtil d =new DBUtil()
Smart code suggestions by Codota
}

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnectionProperties() {
 Connection connection = null;
 try {
  connection = getConnection();
  if (connection == null) {
   addWarn("Could not get a connection");
   return;
  }
  DatabaseMetaData meta = connection.getMetaData();
  DBUtil util = new DBUtil();
  util.setContext(getContext());
  supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
  supportsBatchUpdates = util.supportsBatchUpdates(meta);
  dialectCode = DBUtil.discoverSQLDialect(meta);
  addInfo("Driver name="+meta.getDriverName());
  addInfo("Driver version="+meta.getDriverVersion());
  addInfo("supportsGetGeneratedKeys="+supportsGetGeneratedKeys);
  
 } catch (SQLException se) {
  addWarn("Could not discover the dialect to use.", se);
 } finally {
  DBHelper.closeConnection(connection);
 }
}

/**
 * This method handles cases where the
 * {@link DatabaseMetaData#supportsGetGeneratedKeys} method is missing in the
 * JDBC driver implementation.
 */
public boolean supportsGetGeneratedKeys(DatabaseMetaData meta) {
 try {
  //
  // invoking JDBC 1.4 method by reflection
  //
  return ((Boolean) DatabaseMetaData.class.getMethod(
    "supportsGetGeneratedKeys", (Class[]) null).invoke(meta,
    (Object[]) null)).booleanValue();
 } catch (Throwable e) {
  addInfo("Could not call supportsGetGeneratedKeys method. This may be recoverable");
  return false;
 }
}

@Override
public void start() {
 if (connectionSource == null) {
  throw new IllegalStateException(
    "DBAppender cannot function without a connection source");
 }
 sqlDialect = DBUtil
   .getDialectFromCode(connectionSource.getSQLDialectCode());
 if (getGeneratedKeysMethod() != null) {
  cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
 } else {
  cnxSupportsGetGeneratedKeys = false;
 }
 cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
 if (!cnxSupportsGetGeneratedKeys && (sqlDialect == null)) {
  throw new IllegalStateException(
    "DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect");
 }
 // all nice and dandy on the eastern front
 super.start();
}

DBUtil dbutilObject= new DBUtil ();
 //YOUR CONNECTION VARIABLE
 Connection con1 = dbutilObject.getDBConnection();

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnnectionProperties() {
 try {
  Connection connection = getConnection();
  if (connection == null) {
   addWarn("Could not get a connection");
   return;
  }
  DatabaseMetaData meta = connection.getMetaData();
  DBUtil util = new DBUtil();
  util.setContext(getContext());
  supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
  supportsBatchUpdates = util.supportsBatchUpdates(meta);
  dialectCode = DBUtil.discoverSQLDialect(meta);
  System.out.println("Driver name="+meta.getDriverName());
  System.out.println("Driver version="+meta.getDriverVersion());
  System.out.println("supportsGetGeneratedKeys="+supportsGetGeneratedKeys);
  
 } catch (SQLException se) {
  addWarn("Could not discover the dialect to use.", se);
 }
}

 /**
  * This method handles cases where the
  * {@link DatabaseMetaData#supportsBatchUpdates} method is missing in the JDBC
  * driver implementation.
  */
 public boolean supportsBatchUpdates(DatabaseMetaData meta) {
  try {
   return meta.supportsBatchUpdates();
  } catch (Throwable e) {
   addInfo("Missing DatabaseMetaData.supportsBatchUpdates method.");
   return false;
  }
 }
}

@Override
public void start() {
 if (connectionSource == null) {
  throw new IllegalStateException(
    "DBAppender cannot function without a connection source");
 }
 sqlDialect = DBUtil
   .getDialectFromCode(connectionSource.getSQLDialectCode());
 if (getGeneratedKeysMethod() != null) {
  cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
 } else {
  cnxSupportsGetGeneratedKeys = false;
 }
 cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
 if (!cnxSupportsGetGeneratedKeys && (sqlDialect == null)) {
  throw new IllegalStateException(
    "DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect");
 }
 // all nice and dandy on the eastern front
 super.start();
}

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnectionProperties() {
 try {
  Connection connection = getConnection();
  if (connection == null) {
   addWarn("Could not get a connection");
   return;
  }
  DatabaseMetaData meta = connection.getMetaData();
  DBUtil util = new DBUtil();
  util.setContext(getContext());
  supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
  supportsBatchUpdates = util.supportsBatchUpdates(meta);
  dialectCode = DBUtil.discoverSQLDialect(meta);
  addInfo("Driver name="+meta.getDriverName());
  addInfo("Driver version="+meta.getDriverVersion());
  addInfo("supportsGetGeneratedKeys="+supportsGetGeneratedKeys);
  
 } catch (SQLException se) {
  addWarn("Could not discover the dialect to use.", se);
 }
}

/**
 * This method handles cases where the
 * {@link DatabaseMetaData#supportsGetGeneratedKeys} method is missing in the
 * JDBC driver implementation.
 */
public boolean supportsGetGeneratedKeys(DatabaseMetaData meta) {
  try {
    //
    // invoking JDBC 1.4 method by reflection
    //
    return ((Boolean) DatabaseMetaData.class.getMethod("supportsGetGeneratedKeys", (Class[]) null).invoke(meta, (Object[]) null)).booleanValue();
  } catch (Throwable e) {
    addInfo("Could not call supportsGetGeneratedKeys method. This may be recoverable");
    return false;
  }
}

@Override
public void start() {
  if (connectionSource == null) {
    throw new IllegalStateException("DBAppender cannot function without a connection source");
  }
  sqlDialect = DBUtil.getDialectFromCode(connectionSource.getSQLDialectCode());
  if (getGeneratedKeysMethod() != null) {
    cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
  } else {
    cnxSupportsGetGeneratedKeys = false;
  }
  cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
  if (!cnxSupportsGetGeneratedKeys && (sqlDialect == null)) {
    throw new IllegalStateException(
            "DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect");
  }
  // all nice and dandy on the eastern front
  super.start();
}

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnectionProperties() {
 try {
  Connection connection = getConnection();
  if (connection == null) {
   addWarn("Could not get a connection");
   return;
  }
  DatabaseMetaData meta = connection.getMetaData();
  DBUtil util = new DBUtil();
  util.setContext(getContext());
  supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
  supportsBatchUpdates = util.supportsBatchUpdates(meta);
  dialectCode = DBUtil.discoverSQLDialect(meta);
  addInfo("Driver name="+meta.getDriverName());
  addInfo("Driver version="+meta.getDriverVersion());
  addInfo("supportsGetGeneratedKeys="+supportsGetGeneratedKeys);
  
 } catch (SQLException se) {
  addWarn("Could not discover the dialect to use.", se);
 }
}

/**
 * This method handles cases where the
 * {@link DatabaseMetaData#supportsGetGeneratedKeys} method is missing in the
 * JDBC driver implementation.
 */
public boolean supportsGetGeneratedKeys(DatabaseMetaData meta) {
  try {
    //
    // invoking JDBC 1.4 method by reflection
    //
    return ((Boolean) DatabaseMetaData.class.getMethod("supportsGetGeneratedKeys", (Class[]) null).invoke(meta, (Object[]) null)).booleanValue();
  } catch (Throwable e) {
    addInfo("Could not call supportsGetGeneratedKeys method. This may be recoverable");
    return false;
  }
}

@Override
public void start() {
  if (connectionSource == null) {
    throw new IllegalStateException("DBAppender cannot function without a connection source");
  }
  sqlDialect = DBUtil.getDialectFromCode(connectionSource.getSQLDialectCode());
  if (getGeneratedKeysMethod() != null) {
    cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
  } else {
    cnxSupportsGetGeneratedKeys = false;
  }
  cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
  if (!cnxSupportsGetGeneratedKeys && (sqlDialect == null)) {
    throw new IllegalStateException(
            "DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect");
  }
  // all nice and dandy on the eastern front
  super.start();
}

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnectionProperties() {
  Connection connection = null;
  try {
    connection = getConnection();
    if (connection == null) {
      addWarn("Could not get a connection");
      return;
    }
    DatabaseMetaData meta = connection.getMetaData();
    DBUtil util = new DBUtil();
    util.setContext(getContext());
    supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
    supportsBatchUpdates = util.supportsBatchUpdates(meta);
    dialectCode = DBUtil.discoverSQLDialect(meta);
    addInfo("Driver name=" + meta.getDriverName());
    addInfo("Driver version=" + meta.getDriverVersion());
    addInfo("supportsGetGeneratedKeys=" + supportsGetGeneratedKeys);
  } catch (SQLException se) {
    addWarn("Could not discover the dialect to use.", se);
  } finally {
    DBHelper.closeConnection(connection);
  }
}

/**
 * This method handles cases where the
 * {@link DatabaseMetaData#supportsGetGeneratedKeys} method is missing in the
 * JDBC driver implementation.
 */
public boolean supportsGetGeneratedKeys(DatabaseMetaData meta) {
  try {
    //
    // invoking JDBC 1.4 method by reflection
    //
    return ((Boolean) DatabaseMetaData.class.getMethod("supportsGetGeneratedKeys", (Class[]) null).invoke(meta, (Object[]) null)).booleanValue();
  } catch (Throwable e) {
    addInfo("Could not call supportsGetGeneratedKeys method. This may be recoverable");
    return false;
  }
}

@Override
public void start() {
  if (connectionSource == null) {
    throw new IllegalStateException("DBAppender cannot function without a connection source");
  }
  sqlDialect = DBUtil.getDialectFromCode(connectionSource.getSQLDialectCode());
  if (getGeneratedKeysMethod() != null) {
    cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
  } else {
    cnxSupportsGetGeneratedKeys = false;
  }
  cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
  if (!cnxSupportsGetGeneratedKeys && (sqlDialect == null)) {
    throw new IllegalStateException(
            "DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect");
  }
  // all nice and dandy on the eastern front
  super.start();
}

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnectionProperties() {
 Connection connection = null;
 try {
  connection = getConnection();
  if (connection == null) {
   addWarn("Could not get a connection");
   return;
  }
  DatabaseMetaData meta = connection.getMetaData();
  DBUtil util = new DBUtil();
  util.setContext(getContext());
  supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
  supportsBatchUpdates = util.supportsBatchUpdates(meta);
  dialectCode = DBUtil.discoverSQLDialect(meta);
  addInfo("Driver name="+meta.getDriverName());
  addInfo("Driver version="+meta.getDriverVersion());
  addInfo("supportsGetGeneratedKeys="+supportsGetGeneratedKeys);
  
 } catch (SQLException se) {
  addWarn("Could not discover the dialect to use.", se);
 } finally {
  DBHelper.closeConnection(connection);
 }
}

/**
 * This method handles cases where the
 * {@link DatabaseMetaData#supportsGetGeneratedKeys} method is missing in the
 * JDBC driver implementation.
 */
public boolean supportsGetGeneratedKeys(DatabaseMetaData meta) {
 try {
  //
  // invoking JDBC 1.4 method by reflection
  //
  return ((Boolean) DatabaseMetaData.class.getMethod(
    "supportsGetGeneratedKeys", (Class[]) null).invoke(meta,
    (Object[]) null)).booleanValue();
 } catch (Throwable e) {
  addInfo("Could not call supportsGetGeneratedKeys method. This may be recoverable");
  return false;
 }
}

@Override
public void start() {
 if (connectionSource == null) {
  throw new IllegalStateException(
    "DBAppender cannot function without a connection source");
 }
 sqlDialect = DBUtil
   .getDialectFromCode(connectionSource.getSQLDialectCode());
 if (getGeneratedKeysMethod() != null) {
  cnxSupportsGetGeneratedKeys = connectionSource.supportsGetGeneratedKeys();
 } else {
  cnxSupportsGetGeneratedKeys = false;
 }
 cnxSupportsBatchUpdates = connectionSource.supportsBatchUpdates();
 if (!cnxSupportsGetGeneratedKeys && (sqlDialect == null)) {
  throw new IllegalStateException(
    "DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect");
 }
 // all nice and dandy on the eastern front
 super.start();
}

/**
 * Learn relevant information about this connection source.
 *
 */
public void discoverConnectionProperties() {
  Connection connection = null;
  try {
    connection = getConnection();
    if (connection == null) {
      addWarn("Could not get a connection");
      return;
    }
    DatabaseMetaData meta = connection.getMetaData();
    DBUtil util = new DBUtil();
    util.setContext(getContext());
    supportsGetGeneratedKeys = util.supportsGetGeneratedKeys(meta);
    supportsBatchUpdates = util.supportsBatchUpdates(meta);
    dialectCode = DBUtil.discoverSQLDialect(meta);
    addInfo("Driver name=" + meta.getDriverName());
    addInfo("Driver version=" + meta.getDriverVersion());
    addInfo("supportsGetGeneratedKeys=" + supportsGetGeneratedKeys);
  } catch (SQLException se) {
    addWarn("Could not discover the dialect to use.", se);
  } finally {
    DBHelper.closeConnection(connection);
  }
}

Most used methods

<init>
addInfo
discoverSQLDialect
getDialectFromCode
setContext
supportsBatchUpdates
This method handles cases where the DatabaseMetaData#supportsBatchUpdates method is missing in the J
supportsGetGeneratedKeys
This method handles cases where the DatabaseMetaData#supportsGetGeneratedKeys method is missing in t
getDBConnection

Popular in Java

Reading from database using SQL prepared statement
scheduleAtFixedRate (ScheduledExecutorService)
getExternalFilesDir (Context)
startActivity (Activity)
ObjectMapper (com.fasterxml.jackson.databind)
This mapper (or, data binder, or codec) provides functionality for converting between Java objects (
Kernel (java.awt.image)
ResultSet (java.sql)
An interface for an object which represents a database table entry, returned as the result of the qu
Timestamp (java.sql)
A Java representation of the SQL TIMESTAMP type. It provides the capability of representing the SQL
TreeMap (java.util)
A Red-Black tree based NavigableMap implementation. The map is sorted according to the Comparable of
Loader (org.hibernate.loader)
Abstract superclass of object loading (and querying) strategies. This class implements useful common

How to useDBUtil in ch.qos.logback.core.db.dialect

Best Java code snippets using ch.qos.logback.core.db.dialect.DBUtil (Showing top 20 results out of 315)

How to use
DBUtil
in
ch.qos.logback.core.db.dialect