Bug on the Oracle dialect : empty String is authorized whereas the field is declared as not-null. ------------------------------------------------------------------------------------------------- Key: HV-13 URL: http://opensource.atlassian.com/projects/hibernate/browse/HV-13 Project: Hibernate Validator Issue Type: Bug Environment: Hibernate version :3.1.2 Hibernate dialect : org.hibernate.dialect.OracleDialect Database : Oracle 10g Reporter: Fabien PERIE Priority: Minor Hello, The purpose of this example is to show a bug with the Oracle dialect. I use Hibernate 3.1.2 ! I define a POJO in a mapping file : <?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="fr.modele"> <class name="Person" table="PERS"> <!-- Identifiant de la personne --> <id name="idPerson" type="string" unsaved-value="null"> <column name="PERS_IDEN" sql-type="char(12)" not-null="true"/> <generator class="sequence"> <param name="sequence">pers.pers_seq_iden</param> </generator> </id> <property name="name" column="PERS_NAME" not-null="true" /> <property name="firstName" column="PERS_FIRSTNAME"/> </class> </hibernate-mapping> Detail Person Java object : import fr.modele; import java.io.Serializable; public class Person implements Serializable { private String idPerson; private String name; private String firstName; /** * Constructeur par défaut. */ public Person() { } public Serializable getId() { return idPerson; } public void setId(Serializable id) { this.idPerson = (String)id; } public String getIdPerson() { return idPerson; } public void setIdPerson(String idPerson) { this.idPerson = idPerson; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } } If I try to save an objet which contains the following informations : * idPerson : 1 * name : null * nickName : Jim Hibernate 3 logically returns the error : « fr.org.springframework.orm.hibernate3.HibernateSystemException: not-null property references a null or transient value: fr.modele.Person.name; nested exception is org.hibernate.PropertyValueException: not-null property references a null or transient value: fr.modele.Person.name ». But, if I persist an object which has an empty String instead of null value in the name attribute, Hibernate 3 does not return an error. (!!!) I think that the problem comes of the Oracle dialect object because Oracle does not make the difference between an empty String and a null value. Thanks, Fabien PERIE. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira