I try to get all items from table Temperature by a given city id. Something went wrong and I receive the following error:

org.springframework.dao.DataIntegrityViolationException: could not execute query; SQL [select temperatur0_.id as id1_3_, temperatur0_.Id as Id1_3_, temperatur0_.dateTime as dateTime2_3_, temperatur0_.TemperatureValue as Temperat3_3_ from temperature temperatur0_ left outer join city_attributes city1_ on temperatur0_.Id=city1_.Id where city1_.Id=?]; nested exception is org.hibernate.exception.DataException: could not execute query

I am new to java and I don't know if I used in a correct way the mapping for table relationships.

@Entity
@Table(name = "city_attributes")
public class City {
    
    @javax.persistence.Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "Id")
    private Long id;
    
    @Column(name = "City")
    private String name;
    
    @Column(name = "Country")
    private String country;
    
    @Column(name = "Latitude")
    private String latitude;
    
    @Column(name = "Longitude")
    private String longitude;
    
    @OneToMany(mappedBy = "city")
    private Collection<Temperature> temperatures = new LinkedList<Temperature>();
    
    public City() {}
    
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getCountry() {
        return country;
    }
    public void setCountry(String country) {
        this.country = country;
    }
    public String getLatitude() {
        return latitude;
    }
    public void setLatitude(String latitude) {
        this.latitude = latitude;
    }
    public String getLongitude() {
        return longitude;
    }
    public void setLongitude(String longitude) {
        this.longitude = longitude;
    }
    
    @Override
    public String toString() {
        return "City [Id=" + id + ", name=" + name + ", country=" + country + ", latitude=" + latitude + ", longitude="
                + longitude + "]";
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Collection<Temperature> getTemperatures() {
        return temperatures;
    }

    public void setTemperatures(Collection<Temperature> temperatures) {
        this.temperatures = temperatures;
    }
    
    
}

And

@Entity
@Table(name = "temperature")
public class Temperature {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    
    @Temporal(TemporalType.DATE)
    private Date dateTime;
    
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "Id", nullable = false)
    private City city;
    
    @Column(name = "TemperatureValue")
    private double temperatureValue; 
    
    public Temperature() {}

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Date getDateTime() {
        return dateTime;
    }

    public void setDateTime(Date dateTime) {
        this.dateTime = dateTime;
    }

    public City getCity() {
        return city;
    }

    public void setCity(City city) {
        this.city = city;
    }

    public double getTemperatureValue() {
        return temperatureValue;
    }

    public void setTemperatureValue(double temperatureValue) {
        this.temperatureValue = temperatureValue;
    }
}

try {
    city = cityService.findCityByName(name);
    Long cityId = city.getId();

    temperature = temperatureService.findTempByCityId(cityId); 
    map.addObject("temperature", temperature);
} catch (Exception e) {
    System.out.println(e.toString());
}
        

=== Updated

I found this error when I debug the method from controller

java.sql.SQLDataException: Cannot determine value type from string '1/1/2015 0:00'

@Robert Niestroj here is my implementation for TemperatureService and TemperatureRepository

@Override
public List<Temperature> findTempByCityId(Long id) {
    return temperatureRepository.findByCityId(id);
}

public List<Temperature> findByCityId(Long id);