Oracle+Java Probleme de mapping
Bonjour, jai un probleme quand je veux afficher tous les Employes. voici la requet
Code:
1 2 3
|
@JdbcControl.SQL(statement="SELECT * FROM EMPLOYER ")
Employer AfficherEmployer() throws SQLException; |
et voici mon bean
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
/**
*
*/
import java.io.Serializable;
/**
* @author Saad
*
*/
public class Employer implements Serializable{
/**
*
*/
private static final long serialVersionUID = 1L;
private int id;
private String adresse;
/**
* @return the adresse
*/
public String getAdresse() {
return adresse;
}
/**
* @param adresse the adresse to set
*/
public void setAdresse(String adresse) {
this.adresse = adresse;
}
/**
* @return the id
*/
public int getId() {
return id;
}
/**
* @param id the id to set
*/
public void setId(int id) {
this.id = id;
}
} |
et voici l'erreuu qui me donne :
Code:
1 2
|
Unable to map the SQL column EMPLOYER_ID to a field on the fr.bean.Employer class. Mapping is done using a case insensitive comparision of SQL ResultSet columns to field names and public setter methods on the return class. |
j'ajoute que EMPLOYER_ID et généré a partir d'une séquence