java.sql.SQLException: Invalid value for getInt() - 'foo'

Question

I have this error "Invalid value for getInt() - 'sirocodir'" , i have search in many forum but no response for my case. In my database the "Auteur_Id" type is a varchar(20). My Facture Entity: ``` @Entity @Table(name = "Factures") public class Factures implements java.io.Serializable { private Collaborateurs collaborateurs; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "Auteur_Id", nullable = false) public Collaborateurs getCollaborateurs() { return this.collaborateurs; } public void setCollaborateurs(Collaborateurs collaborateurs) { this.collaborateurs = collaborateurs; } ``` My Collaborateurs entity: ``` @OneToMany(fetch = FetchType.LAZY, mappedBy = "collaborateurs") public Set getfactures() { return this.factures; } public void setfactures(Set factures) { this.factures = factures; } ``` My service: ``` @Transactional(readOnly=true) public List AllFacturesContratsClient() { return sessionFactory.getCurrentSession() .createQuery("from Factures").…

Accepted Answer

Do you have any enum type in the class `Collaborateurs` ? If it has, make sure use `@Enumerated(EnumType.STRING)`

java.sql.SQLException: Invalid value for getInt() - 'foo'

Solution

Problem