sqlDialect = new PostgreSQLDialect(); break; sqlDialect = new MySQLDialect(); break; sqlDialect = new OracleDialect(); break; sqlDialect = new MsSQLDialect(); break; sqlDialect = new HSQLDBDialect(); break; sqlDialect = new H2Dialect(); break; sqlDialect = new SybaseSqlAnywhereDialect(); break; sqlDialect = new SQLiteDialect(); break;
/** * 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; } } }
/** * 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); } }
public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) { SQLDialect sqlDialect = null; switch (sqlDialectType) { case POSTGRES_DIALECT: sqlDialect = new PostgreSQLDialect(); break; case MYSQL_DIALECT: sqlDialect = new MySQLDialect(); break; case ORACLE_DIALECT: sqlDialect = new OracleDialect(); break; case MSSQL_DIALECT: sqlDialect = new MsSQLDialect(); break; case HSQL_DIALECT: sqlDialect = new HSQLDBDialect(); break; } return sqlDialect; }
DBUtil dbutilObject= new DBUtil (); //YOUR CONNECTION VARIABLE Connection con1 = dbutilObject.getDBConnection();
@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(); }
idStatement = connection.createStatement(); idStatement.setMaxRows(1); String selectInsertIdStr = sqlDialect.getSelectInsertId(); rs = idStatement.executeQuery(selectInsertIdStr);
public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) { SQLDialect sqlDialect = null; switch (sqlDialectType) { case POSTGRES_DIALECT: sqlDialect = new PostgreSQLDialect(); break; case MYSQL_DIALECT: sqlDialect = new MySQLDialect(); break; case ORACLE_DIALECT: sqlDialect = new OracleDialect(); break; case MSSQL_DIALECT: sqlDialect = new MsSQLDialect(); break; case HSQL_DIALECT: sqlDialect = new HSQLDBDialect(); break; case H2_DIALECT: sqlDialect = new H2Dialect(); break; case SYBASE_SQLANYWHERE_DIALECT: sqlDialect = new SybaseSqlAnywhereDialect(); break; case SQLITE_DIALECT: sqlDialect = new SQLiteDialect(); break; } return sqlDialect; }
/** * 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; } }
sqlDialect = new PostgreSQLDialect(); break; sqlDialect = new MySQLDialect(); break; sqlDialect = new OracleDialect(); break; sqlDialect = new MsSQLDialect(); break; sqlDialect = new HSQLDBDialect(); break; sqlDialect = new H2Dialect(); break; sqlDialect = new SybaseSqlAnywhereDialect(); break; sqlDialect = new SQLiteDialect(); break;
/** * 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; } } }
public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) { SQLDialect sqlDialect = null; switch (sqlDialectType) { case POSTGRES_DIALECT: sqlDialect = new PostgreSQLDialect(); break; case MYSQL_DIALECT: sqlDialect = new MySQLDialect(); break; case ORACLE_DIALECT: sqlDialect = new OracleDialect(); break; case MSSQL_DIALECT: sqlDialect = new MsSQLDialect(); break; case HSQL_DIALECT: sqlDialect = new HSQLDBDialect(); break; case H2_DIALECT: sqlDialect = new H2Dialect(); break; case SYBASE_SQLANYWHERE_DIALECT: sqlDialect = new SybaseSqlAnywhereDialect(); break; case SQLITE_DIALECT: sqlDialect = new SQLiteDialect(); break; } return sqlDialect; }
/** * 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; } } }
sqlDialect = new PostgreSQLDialect(); break; sqlDialect = new MySQLDialect(); break; sqlDialect = new OracleDialect(); break; sqlDialect = new MsSQLDialect(); break; sqlDialect = new HSQLDBDialect(); break; sqlDialect = new H2Dialect(); break; sqlDialect = new SybaseSqlAnywhereDialect(); break; sqlDialect = new SQLiteDialect(); break;
/** * 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; } } }
public static SQLDialect getDialectFromCode(SQLDialectCode sqlDialectType) { SQLDialect sqlDialect = null; switch (sqlDialectType) { case POSTGRES_DIALECT: sqlDialect = new PostgreSQLDialect(); break; case MYSQL_DIALECT: sqlDialect = new MySQLDialect(); break; case ORACLE_DIALECT: sqlDialect = new OracleDialect(); break; case MSSQL_DIALECT: sqlDialect = new MsSQLDialect(); break; case HSQL_DIALECT: sqlDialect = new HSQLDBDialect(); break; case H2_DIALECT: sqlDialect = new H2Dialect(); break; case SYBASE_SQLANYWHERE_DIALECT: sqlDialect = new SybaseSqlAnywhereDialect(); break; case SQLITE_DIALECT: sqlDialect = new SQLiteDialect(); break; } return sqlDialect; }
/** * 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; } } }
sqlDialect = new PostgreSQLDialect(); break; sqlDialect = new MySQLDialect(); break; sqlDialect = new OracleDialect(); break; sqlDialect = new MsSQLDialect(); break; sqlDialect = new HSQLDBDialect(); break; sqlDialect = new H2Dialect(); break; sqlDialect = new SybaseSqlAnywhereDialect(); break; sqlDialect = new SQLiteDialect(); break;
/** * 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; } } }
/** * 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; } } }