how to delete VPC when it has error with Network interface , Gateway decencies in AWS
1. Check if it is running on EC2 instance then Stop / Terminate that first
2. Deassociate Elastic IP
3. Detach and delete NAT gateway
4. Detach and Delete Internet gateway
5. Delete security group (optional)
Back to delete VPC again
Some notes and tips:
1. 1. Typical current code
getCurrentSession().createCriteria(BT.class)
.add(Restrictions.eq("replacedBT",
replaced))
.addOD(OD.desc("id")).list();
Will be replaced by
CriteriaQuery<BT> criteriaQuery =
getCurrentSession().getCriteriaBuilder().createQuery(BT.class);
Root<BT> root = criteriaQuery.from(BT.class);
CriteriaBuilder cb =
getCurrentSession().getCriteriaBuilder();
criteriaQuery.select(root).where(getCurrentSession().getCriteriaBuilder().equal(root.get("replacedBT"),
replaced));
criteriaQuery.ODBy(cb.desc(root.get("id")));
2.
Mapping
|
|
Hibernate |
JPA |
|
1 |
setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY) |
criteriaQuery.select(root).distinct(true) |
|
2 |
setProjection(Property.forName("id") |
criteriaQuery.multiselect(root.get("id")) |
|
|
|
|
|
3 |
Disjunction |
CriteriaBuilder disjunction(); Ex: Predicate predicate =
cb.disjunction(); predicate.getExpressions().add(cb.isNull(root.get("effectiveEndDate"))); predicate.getExpressions().add(cb.greaterThanOrEqualTo(root.get("effectiveEndDate"),
DateUtil.getLienDateForTestY(testY.intValue()))); |
|
4 |
Criterion |
predicate.getExpressions().add( |
|
5 |
Restrictions.in ("testY",
Ys) |
root.get("testY").in(Ys) |
|
|
|
|
|
6 |
Restrictions.le |
lessThanOrEqualTo |
|
7 |
Restrictions.ilike - case insensitive |
cb.like(cb.lower(root.get("assesseeName")),
"%"+name.trim().toLowerCase() + "%" |
|
8 |
Build list of conditions
many if else |
List<Predicate>
predicates = new ArrayList<>(); predicates.add(join.get("testId").in(oidSub)); predicates.add(cbSub.notEqual(rootBT.get("pmStatus"),
BTPmStatus.paidStatus)); predicates.add(cbSub.notEqual(rootBT.get("status"),
TestBTStatus.canceled)); predicates.add(cbSub.notEqual(rootBT.get("status"),
TestBTStatus.purged)); predicates.add(cbSub.notEqual(rootBT.get("status"),
TestBTStatus.rolledToUnsecured )); |
|
9 |
Join BTCrit.createCriteria("testCharges","chg"); BTCrit.add
(Restrictions.in("chg.testId", oidSub) ); |
Join<BT,
Charge> join = rootBT.join("testCharges", JoinType.INNER); criteriaQueryBT.select(rootBT).where(join.get("testId").in(oids),
cbBT.equal(rootBT.get("testY"), testY), rootBT.get("BTType").in(types) ); |
|
10 |
Multiple Join List<JTestOD> chains =
getCurrentSession()
.createCriteria(JTestOD.class) .add(Restrictions.not(Restrictions.eq("state",
JTestODState.open))) .createCriteria("traTranss") .createCriteria("JTransProperties")
.add(Restrictions.eq("id.apn",prop.getPropertyId()))
.add(Restrictions.eq("propertyAvTestY",prop.getTestY())) // .add(Restrictions.eq("chainedToTestOD",
co)) // .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY) // .list(); |
CriteriaQuery<JTestOD>
criteriaQuery = getCurrentSession().getCriteriaBuilder().createQuery(JTestOD.class); CriteriaBuilder cb =
getCurrentSession().getCriteriaBuilder(); Root<JTestOD> root = criteriaQuery.from(JTestOD.class); Join<JTestOD, JTraTrans> join =
root.join("traTranss", JoinType.INNER); Join<JTraTrans, JTransProperty>
join2 = join.join("JTransProperties", JoinType.INNER);
criteriaQuery.select(root).distinct(true) .where( cb.notEqual(root.get("state"),
JTestODState.open), cb
.equal(join2.get("id").get("apn"), prop.getPropertyId()), cb.equal(join2.get("propertyAvTestY"),
prop.getTestY()), cb
.equal(join2.get("chainedToTestOD"), co)); List<JTestOD> chains =
getCurrentSession().createQuery(criteriaQuery).getResultList(); |
how to delete VPC when it has error with Network interface , Gateway decencies in AWS 1. Check if it is running on EC2 instance then Sto...
