Saving to the database in Uppercase

[paul king]

Hi

I have an application that uses struts, spring and hibernate.
Any suggestions on the best place to set my value object properties to uppercase ready for saving to a database and whats most efficient?
e.g. possibly when the object properties are initially set
or in the service layer
or at dao level
or maybe in the hibernate mapping
or any other ideas???

Thanks in advance

[Jeanne Boyarsky]

Paul,
It's equally efficient wherever you decide to do it. I like the DAO level because uppercase sounds like you are making it uppercase for the database level. If it is more of a business decision, I would do it when the object properties are first set. Whatever you decide, consistency is most important.

[Stan James]

Which of these do you want to print "true" ??

Person p1 = new Person(1, "John");
print(p1.getName().equals("John"));
repository.savePerson(p1);
Person p2 = repository.getPerson(1);
print(p2.getName().equals("JOHN"));
print(p2.getName().equals(p1.getName());

These will be driven by the other ways your system uses these things, I think.