java.sql.Date incompatible with java.sql.Timestamp

Code:

---

  java.sql.Date leaveEffectiveDate = null;
          //java.sql.Timestamp leaveEffDate = null;
          if (rowColl != null) {
                Vector leaveVector = rowColl.getCollection();
                if (null != leaveVector && 0 != leaveVector.size()) {
                        resultRow = (Row) leaveVector.elementAt(0);
                        if(resultRow.getValue("EFF_DATE") != null){
                                leaveEffectiveDate = new java.sql.Date(((java.sql.Timestamp)resultRow.getValue("EFF_DATE")).getTime());
                                log.debug("EFFECTIVE DATE 1 >>"+leaveEffectiveDate.toString());
                        }
                  }
          }
        return leaveEffectiveDate;
  }

---

Any idea why I am getting this casting error?

Because both sql.Date and TimeStamp extend util.Date, but do not extend and are not castable to each other, and the column "EFF_DATE" is, seemingly, being returned as an sql.Date object by "getValue" and you're casting it to a TimeStamp.

Thanks buddy!