The SQL factory component should encapsulate the SQL service from users. The factory must return
PreparedStatement and CallableStatement to the user, based on a query name identifier.
- Exceptions
- The factory would throw a GeneralSqlException, when unable to create the statement.
- Logging
- The entire process of creating the message is logged, with a TRACE severity.
- Extensibility
- Poor. The interface currently restricts us to create only PreparedStatement and CallableStatement.
We are consciously taking this decision, because we dont for see any possibility of
of logging or notification. Or perhaps, logging could be added to
existing exceptions through this mechanism.
- Messaging
- We currently hard-code exception messages in the calls to exceptions and
once in a while place the messages directly into the exception class. Is
there a way to make them localizable, perhaps through extensible
exceptions.
|