I am a newbie to Hibernate and i am trying to migrate an existing application.

I am (still) using SQL Server 200 for RDBMS.

The problem i had and i want to share is that when i inserted or updated a record to the database all of the columns that were of type VARCHAR were padded with trailing spaces till the column was full (riched its length).

I was using the JDBC/ODBC driver.

That seeemed to be the problem.

I replaced the driver with the jTDS driver (http://jtds.sourceforge.net) and the problem was solved.

I think it's worth posting it.