Hibernate saves nvarchar values with a trailing space

[Justin Howard]

Hi All,

I am using Hibernate. When i save the data it saves nvarchar values with a trailing space.

How can I eliminate this ?

Thanks

[Justin Howard]

Hi All,

If I have posted the question in the wrong forum please let me know.

Thanks

[Paul Sturrock]

Nothing to do with Hibernate I think. What makes you think it is Hiberate that is causing the problem?

[Justin Howard]

Thanks for the reply.

I have written stuff without using Hibernate and that does not add any space. Plus I am using trim (in the setter) on the value being stored to try to eliminate the space.

And I also found that 2 people had the same concern using Hibernate in the Hibernate forum, but that remained unanswered as well.

Thanks

[Paul Sturrock]

Hmm. Can you tell us more? What does your mapping look like? What does your data model look like? What dialect are you using?

[Justin Howard]

Thanks for the reply.

I am using SQL server Dialect. I am setting the value using a setter.
p.setEmpApproverEmail(approverEmail.trim()); When I check the value after the values are stored in the database I find space appended to it.
In the database the feild is set to nvarchar(500).

    
<hibernate-configuration>
        <session-factory>
                <!-- Database connection settings -->
                <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
  				<property name="connection.datasource">java:comp/env/jdbc/dsnFreelancerdb</property>
  				<property name="hibernate.c3p0.min_size">5</property>
                <property name="hibernate.c3p0.max_size">200</property>
                <property name="hibernate.c3p0.timeout">1800</property>
                <property name="hibernate.c3p0.max_statements">50</property>
  				<!-- Echo all sql to sdtout -->
                <property name="show_sql">false</property>
               <!-- List all the Java classes we have mapped here -->
				<mapping resource="com/aexp/freelancerdb/emp/Freelancer.hbm.xml"/>
				
		   </session-factory>
</hibernate-configuration>

    
public class Freelancer {
	private String empApproverEmail; 
	public String getEmpApproverEmail() {
		return empApproverEmail;
	}
	public void setEmpApproverEmail(String empApproverEmail) {
		this.empApproverEmail = empApproverEmail;
	}
        ...other values setter and getters
}

   
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
		"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
		"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="com.aexp.freelancerdb.emp.Freelancer" table="table name">
	<id name="empSerial" type="long" column="empSerial">
		<generator class="native"/>
	</id>
	<property name="empApproverEmail"/>     
	other mappings
	
</class>
</hibernate-mapping>

[Justin Howard]

Hi ,

Is there anything wrong with the way i store it?

Thanks

[Paul Sturrock]

Sorry - slow hadn't noticed you'd updated this.

There is nothing in your code or in Hibernate that will do this. However SQL Server does have a frustrating mechanism to support ANSI padding (i.e. 'foo' == 'foo '), it will include a training space on the data inserted into an nvarchar field if you have ANSI_PADDING set to on. In older versions of SQL Server this defaulted to being on by default. Try updating your database properties to make sure ANSI_PADDING is off and see if it fixes it.

[Justin Howard]

Thanks for the reply Paul.

Will definitely try that !

Thanks