File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Beginning Java and the fly likes Saving to the database in Uppercase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Saving to the database in Uppercase" Watch "Saving to the database in Uppercase" New topic

Saving to the database in Uppercase

paul king

Joined: May 23, 2006
Posts: 12

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
author & internet detective

Joined: May 26, 2003
Posts: 32815

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
Which of these do you want to print "true" ??

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

A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
I agree. Here's the link:
subject: Saving to the database in Uppercase
It's not a secret anymore!