placing properties in database instead of property file

Question

Java, is placing and loading properties from database instead of property file is better approach ?

Answer 1

Advantages if you place it in DB.

• It can be centrally shared.
• If you want to retrieve particular key you don't need to load whole data you can uniquely obtain value from key.
• DBMS is always reliable then File IO.

Advantages of Properties file :

• if data size is smaller then storing it in properties file would be beneficial.

Answer 2

It really depends. But in generic cases:

Use a PropertiesFile when:

• Those properties are needed to connect to the database.
• When there is no database involved

Use a Database Table when:

• Database states could change the values
• When your application uses a database
• You need the flexibility of different properties depending on the database that is connected to.

In all other cases, the decision is on the fence and it doesn't really matter which way you go.