jdbc java.sql.date example - Should I use java.util.Date or switch to java.time.LocalDate
Edit: Well, apparently it was too opinion based, so let me try to reword it more precisely -
Are there any clear caveats or drawbacks of using LocalDate, LocalTime etc. in a Java code that does not need any backwards compatibility, and if so - what are they?
I'm looking for things like "Current EE libraries X and Y don't work correctly with LocalDate" or "This very useful pattern is broken with LocalTime" et cetera.
(here is the original question for reference)
With Java 8, a new time API is introduced, namely the java.time.LocalDate etc., but java.util.Date is not marked as deprecated.
I am writing a new project, which does not need to be backwards compatible. Should I only use LocalDate, LocalDateTime etc.? Are there any drawbacks to using this new API as opposed to the good old java.util.Date?
In particular - I am going to be working mainly with JDBC. From what I have seen JDBC handles java.util.Date well. Is it as well suited for LocalDate?
Searching yielded lots of sites telling how to convert from one format to the other, but no definitive answer as to should new code use the old API.