Reading properties from database
Our application has many property files due to extensibility and becomes a nightmare managing them. I would like to know if there is any suggestion about how I could unify all the properties into a database (obviously excluding the database connection properties). This way, managing it can be easy by snapping a UI on top of the database table containing the properties. This is what I would like to know:
1. How can I direct my propertyplaceholderconfiguration class to load the properties from database based on a query?
2. Once it is loaded, obviously, one of the advantages is that we would be able to update the database without shutting down the server. How can I propogate the new changes to my beans already referencing the properties without restart?
3. I would not like to be hitting the database all times for getting the properties, so will it be cached and if so, how can I specify the time to live?
Any help greatly appreciated!