// dropDatabaseUser(rssInstance, user.getUsername(), tenantId);
// }
// }
String sql = "DELETE FROM RM_SERVER_INSTANCE WHERE NAME = ? AND TENANT_ID = ? AND ENVIRONMENT_ID = (SELECT ID FROM RM_ENVIRONMENT WHERE NAME = ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, name);
stmt.setInt(2, tenantId);
stmt.setString(3, environmentName);
stmt.executeUpdate();
} catch (SQLException e) {
throw new RSSDAOException(
"Error occurred while dropping the RSS instance '"
+ name + "' : " + e.getMessage(), e);
} finally {
RSSDAOUtil.cleanupResources(null, stmt, conn);
}
}
public void updateRSSInstance(String environmentName, RSSInstance rssInstance,
Other popular examples for PreparedStatement
150: stmt.setLong(1,rId);
151: stmt.setLong(2,scn);
152: stmt.setString(3, srcKey);
153: stmt.setBlob(4, new ByteArrayInputStream(data.getBytes()));
154: stmt.executeUpdate();
-
159: DBHelper.close(stmt);
Full Snippet Info120: stmt.setLong(1, _minwindowscn);
121: stmt.setLong(2, _maxwindowscn);
122: stmt.setInt(3, _maxRowId);
123: stmt.setInt(4, _srcid);
-
134: DBHelper.close(stmt);
Full Snippet Info85: stmt.setFetchDirection(ResultSet.FETCH_FORWARD);
86: stmt.setFetchSize(1);
87: stmt.setLong(1, longID);
88: rs = stmt.executeQuery();
-
97: IOUtils.quietClose(rs, stmt, conn);
Full Snippet Info