Hi serge
I think it's a good idea. I'll move all the queries to a xml file and I'll make them accessible through a PreparedStatementFactory class. I will also add a pluggable mechanism for chosing how to get the connection.
Hi Edgar,
Maybe it would be a good idea to load the SQL requests from a property file, so that tables can be renamed without having to recompile the code ?
This probably requires to only use PreparedStatements, but then again this might be a good idea for performance reasons too no ?
. create connections (current approach)
. create a DataSource
. obtain connections through jndi
. custom approach by implementing an interface
btw, if the prepared statements are not pooled the JDBCPersistenceManager will be slower, but I guess it should only be used with a connection pool.
regards edgar
