posted 12 years ago
At our company we have a table it database where messages are stored that applications use to communicate with users. The table was designed poorly: it has indexes as numbers. The problem with this is if I have three messages let's say "Welcome" entered in table by programmers and they have message id as 1,2,3 and if I need to change a message for a particular application, I need to view the source code for this application find which message id it uses (1,2 or 3), go back to database and change appropriate label. I suggested we use String as message id, that way there is no confusion which message belongs to which program: WELCOME_APP1, WELCOME_APP2, WELCOME_APP3. Better yet I thought why not use ResourceBundle for messges and store them in properties file. Is it better to change the database design or utilize ResourceBundle for messages retrieval?