Portfolio


classDiagram
Object <|-- Throwable

Throwable <|-- Exception
Throwable <|-- Error

Exception <|-- SQLException
Exception <|-- IOException
Exception <|-- RuntimeException

Error <|-- OutOfMemoryError

RuntimeException <|-- NullPointerException
RuntimeException <|-- IllegalArgumentException


void save(UUID voucherId) {
            try {
                //Jdbc 사용 코드
            } catch (SQLException e) {
                throw new SomeException(e);
            }
        }


/**
 * @throws ???Exception if 예외 터지는 상황
 */


log.error("예외 발생, 메시지: {}, ", e.getMessage(), e);


classDiagram
RuntimeException <|-- DataAccessException

DataAccessException <|-- NonTransientDataAcessException
DataAccessException <|-- TransientDataAccessException

NonTransientDataAcessException <|-- BadSqlGrammarException
NonTransientDataAcessException <|-- DataIntegrityViolationException

TransientDataAccessException <|-- QueryTimeoutException
TransientDataAccessException <|-- OptimisticLockingFailureException
TransientDataAccessException <|-- PessimisticLookingFailureException

DataIntegrityViolationException <|-- DuplicateKeyException


} catch (SQLException e) {
            var exceptionTranslator = new SQLErrorCodeSQLExceptionTranslator(dataSource);
            DataAccessException resultException = exceptionTranslator.translate("상황을 설명할 수 있는 글", sql, e);
            log.info("resultException = {}", resultException);

//SQL 문법이 잘못되었을 경우에는 BadSqlGrammarException으로 변환된 것을 알 수 있음


<bean id="DB2" name="Db2" class="org.springframework.jdbc.support.SQLErrorCodes">
		<property name="databaseProductName">
			<value>DB2*</value>
		</property>
		<property name="badSqlGrammarCodes">
			<value>-007,-029,-097,-104,-109,-115,-128,-199,-204,-206,-301,-408,-441,-491</value>
		</property>
		<property name="duplicateKeyCodes">
			<value>-803</value>
            ...
      <bean id="H2" class="org.springframework.jdbc.support.SQLErrorCodes">
		<property name="badSqlGrammarCodes">
			<value>42000,42001,42101,42102,42111,42112,42121,42122,42132</value>
		</property>
		<property name="duplicateKeyCodes">
			<value>23001,23505</value>
            ...