I was wondering...... i am about to start a new project with my client company, in our last project we used session beans that queried the DB for data. SQL queries were stored in an interface, so to access we were doing
the_prepared_stmt.setQuery ( DBQueries.QUERY1 ); etc
the problem is that once the query changed, there was recompilation needed as the compiler inlines the String.
Anyone have better suggestions when security and ease of change is concerned ?
- use the env-entry in the descriptor ?
- property files read at start up ?
- ??
Thanks for any responses.