0 Replies Latest reply on Mar 28, 2002 3:39 PM by krypton

    BMP / SLSB SQL Queries : Advice on design

    krypton Novice

      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.