Clean Java Code No SQL
843854Oct 22 2001 — edited Oct 24 2001Has anyone concidered putting all SQL outside the java source code. A properties file seems rather limited so why not xml?
My goal for posting this topic is to have the JDBC community provide input and suggestions for the given scenario.
A java app performs a certain task involving a DB the application is ported to another environment and the DB changes and the SQL for the action changes.
How would you define the SQL outside of the code and how would the java code interpret it, including SQL that is dynamically build using class properties or return values from class methods.
Thanks for reading this,
Phil