[hibernate-issues] [Hibernate-JIRA] Created: (HV-13) Bug on the Oracle dialect : empty String is authorized whereas the field is declared as not-null.
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