/* * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.jdbi.v3.sqlobject.transaction; import java.lang.annotation.Annotation; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation.Target; import java.lang.reflect.Method; import java.lang.reflect.Parameter; import java.lang.reflect.Type; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import org.jdbi.v3.core.statement.SqlStatement; import org.jdbi.v3.core.statement.StatementContext; import org.jdbi.v3.core.statement.StatementCustomizer; import org.jdbi.v3.core.transaction.TransactionIsolationLevel; import org.jdbi.v3.sqlobject.customizer.SqlStatementCustomizer; import org.jdbi.v3.sqlobject.customizer.SqlStatementCustomizerFactory; import org.jdbi.v3.sqlobject.customizer.SqlStatementCustomizingAnnotation; import org.jdbi.v3.sqlobject.customizer.SqlStatementParameterCustomizer; /** * Used to specify the transaction isolation level for an object or method (via annotating the method * or passing it in as an annotated param). If used on a parameter, the parameter type must be a * {@link TransactionIsolationLevel} */ @SqlStatementCustomizingAnnotation(TransactionIsolation.Factory.class) @Target({ElementType.PARAMETER, ElementType.METHOD, ElementType.TYPE}) @Retention(RetentionPolicy.RUNTIME) public @interface TransactionIsolation { TransactionIsolationLevel value() default TransactionIsolationLevel.UNKNOWN; class Factory implements SqlStatementCustomizerFactory { @Override public SqlStatementCustomizer createForType(Annotation annotation, Class<?> sqlObjectType) { TransactionIsolationLevel level = ((TransactionIsolation) annotation).value(); return stmt -> setTxnIsolation(stmt, level); } @Override public SqlStatementCustomizer createForMethod(Annotation annotation, Class<?> sqlObjectType, Method method) { return createForType(annotation, sqlObjectType); } @Override public SqlStatementParameterCustomizer createForParameter(Annotation annotation, Class<?> sqlObjectType, Method method, Parameter param, int index, Type type) { return (stmt, level) -> setTxnIsolation(stmt, (TransactionIsolationLevel) level); } private void setTxnIsolation(SqlStatement<?> stmt, TransactionIsolationLevel level) throws SQLException { final int initialLevel = stmt.getContext().getConnection().getTransactionIsolation(); stmt.addCustomizer(new StatementCustomizer() { @Override public void beforeExecution(PreparedStatement stmt, StatementContext ctx) throws SQLException { setTxnIsolation(ctx, level.intValue()); } @Override public void afterExecution(PreparedStatement stmt, StatementContext ctx) throws SQLException { setTxnIsolation(ctx, initialLevel); } private void setTxnIsolation(StatementContext ctx, int level) throws SQLException { final Connection c = ctx.getConnection(); if (c.getTransactionIsolation() != level) { c.setTransactionIsolation(level); } } }); } } }