The Carbon Java Framework  

The Carbon SQL Module

SQL Service Requirements

Author: Greg Hinkle (ghinkle at sapient.com)
Version: $Revision: 1.3 $($Author: araman $ / $Date: 2003/05/05 07:46:27 $)
Created: July 2002

Requirements

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.

Copyright © 2001-2003, Sapient Corporation