All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect Maven / Gradle / Ivy
/**
* Licensed to JumpMind Inc under one or more contributor
* license agreements. See the NOTICE file distributed
* with this work for additional information regarding
* copyright ownership. JumpMind Inc licenses this file
* to you under the GNU General Public License, version 3.0 (GPLv3)
* (the "License"); you may not use this file except in compliance
* with the License.
*
* You should have received a copy of the GNU General Public License,
* version 3.0 (GPLv3) along with this library; if not, see
* () {
public Boolean execute(Connection con) throws SQLException {
String previousCatalog = con.getCatalog();
Statement stmt = null;
try {
if (catalogName != null) {
con.setCatalog(catalogName);
}
stmt = con.createStatement();
stmt.execute(sql);
} catch (Exception e) {
log.warn("Error removing {}: {}", triggerName, e.getMessage());
} finally {
if (catalogName != null) {
con.setCatalog(previousCatalog);
}
try {
stmt.close();
} catch (Exception e) {
}
}
return Boolean.FALSE;
}
});
}
}
@Override
protected String switchCatalogForTriggerInstall(String catalog, ISqlTransaction transaction) {
if (catalog != null) {
Connection c = ((JdbcSqlTransaction) transaction).getConnection();
String previousCatalog;
try {
previousCatalog = c.getCatalog();
c.setCatalog(catalog);
return previousCatalog;
} catch (SQLException e) {
throw new SqlException(e);
}
} else {
return null;
}
}
@Override
public BinaryEncoding getBinaryEncoding() {
return BinaryEncoding.BASE64;
}
@Override
protected boolean doesTriggerExistOnPlatform(final String catalogName, String schema,
String tableName, final String triggerName) {
return ((JdbcSqlTemplate) platform.getSqlTemplate())
.execute(new IConnectionCallback() {
public Boolean execute(Connection con) throws SQLException {
String previousCatalog = con.getCatalog();
PreparedStatement stmt = con
.prepareStatement("select count(*) from sysobjects where type = 'TR' AND name = ?");
try {
if (catalogName != null) {
con.setCatalog(catalogName);
}
stmt.setString(1, triggerName);
ResultSet rs = stmt.executeQuery();
if (rs.next()) {
int count = rs.getInt(1);
return count > 0;
}
} finally {
if (catalogName != null) {
con.setCatalog(previousCatalog);
}
stmt.close();
}
return Boolean.FALSE;
}
});
}
public void disableSyncTriggers(ISqlTransaction transaction, String nodeId) {
if (supportsDisableTriggers()) {
if (nodeId == null) {
nodeId = "";
}
transaction.prepareAndExecute("DECLARE @CI VarBinary(128);" + "SET @CI=cast ('1"
+ nodeId + "' as varbinary(128));" + "SET context_info @CI;");
}
}
public void enableSyncTriggers(ISqlTransaction transaction) {
if (supportsDisableTriggers()) {
transaction.prepareAndExecute("set context_info 0x0");
}
}
public String getSyncTriggersExpression() {
return "$(defaultCatalog)dbo." + parameterService.getTablePrefix()
+ "_triggers_disabled() = 0";
}
@Override
public String getTransactionTriggerExpression(String defaultCatalog, String defaultSchema,
Trigger trigger) {
return "@TransactionId";
}
@Override
public boolean supportsTransactionId() {
return true;
}
@Override
public boolean isTransactionIdOverrideSupported() {
return false;
}
/*
* Nothing to do for SQL Server
*/
public void purgeRecycleBin() {
}
@Override
public boolean needsToSelectLobData() {
return true;
}
}
