Hello.

Im having a problem with hibernate right now. We are using it in a web app with nothing really special. Just forms being used a lot and we have hibernate to handle the database end. It is saving information into the database, but whenever I save a string value into the database, it adds up to 61 white spaces at the end.

Now when I say 'up to', it adds on 61-(length of string) total white spaces. that number always stays the same. But if its an integer being saved, it doesnt do anything wrong at all. No white spaces added. Ive tried setting the maxlength in teh xml config for that class type and it doesnt help. Ive also tried doing a .trim() value for the object before saving into the database, and it still does it.

Ive even set it up to where i put a .trim() on the string right before it is saved, then i save it. after that , i retrieve it and it has the white spaces in it.

Ive tried poking around online to see if I could find any related issues, but I have not. If you have any thoughts, please let me know. Thank you.

Marcel

is your database padding it, like say in the char field type?

not that i know of. Im not really 100% sure how to check to see if it is set to actually pad them. but that would make sense because its constantly padding up to 61 characters. Do you know where to actually check for that though?

well I'll tell you this

Hibernate does not pad String data types by itself, either on the way in or out. It uses the getters of objects to get the values for the sql queries it runs, so if you have trim statements in the getters, you can guarantee your data is getting to the database w/o any padding.

If you use custom user types, you can define padding in there, but I'd think you'd know if you were.

Basically, if you are saving trimmed Strings, and getting them back padded, then your database is padding them. A typical field type in a db that pads values is CHAR type.

change the coulmn datatype from

char
to
varchar

change the datatype from char to varchar

Thank you for both of your responses, but here is the problem I'm in. While doing a .trim() when i get the data would work for this program I'm working on now, but I need other programs to work off the same database with the same data. Unfortunately, I cant go back into those programs and add .trim()'s to everything :(. Also, the datatypes in the database were already varchars and I'm still getting the padding. Any thoughts? Thank you again for your help.