• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

mybatis / spring / 1949

09 Jul 2026 10:07PM UTC coverage: 90.381% (+0.1%) from 90.242%
1949

push

github

web-flow
Merge pull request #1269 from mybatis/renovate/byte-buddy.version

Update byte-buddy.version to v1.18.11-jdk5

323 of 386 branches covered (83.68%)

949 of 1050 relevant lines covered (90.38%)

0.9 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

66.67
/src/main/java/org/mybatis/spring/SqlSessionTemplate.java
1
/*
2
 * Copyright 2010-2026 the original author or authors.
3
 *
4
 * Licensed under the Apache License, Version 2.0 (the "License");
5
 * you may not use this file except in compliance with the License.
6
 * You may obtain a copy of the License at
7
 *
8
 *    https://www.apache.org/licenses/LICENSE-2.0
9
 *
10
 * Unless required by applicable law or agreed to in writing, software
11
 * distributed under the License is distributed on an "AS IS" BASIS,
12
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13
 * See the License for the specific language governing permissions and
14
 * limitations under the License.
15
 */
16
package org.mybatis.spring;
17

18
import static java.lang.reflect.Proxy.newProxyInstance;
19

20
import static org.apache.ibatis.reflection.ExceptionUtil.unwrapThrowable;
21
import static org.mybatis.spring.SqlSessionUtils.closeSqlSession;
22
import static org.mybatis.spring.SqlSessionUtils.getSqlSession;
23
import static org.mybatis.spring.SqlSessionUtils.isSqlSessionTransactional;
24
import static org.springframework.util.Assert.notNull;
25

26
import java.lang.reflect.InvocationHandler;
27
import java.lang.reflect.Method;
28
import java.sql.Connection;
29
import java.util.List;
30
import java.util.Map;
31

32
import org.apache.ibatis.cursor.Cursor;
33
import org.apache.ibatis.exceptions.PersistenceException;
34
import org.apache.ibatis.executor.BatchResult;
35
import org.apache.ibatis.session.Configuration;
36
import org.apache.ibatis.session.ExecutorType;
37
import org.apache.ibatis.session.ResultHandler;
38
import org.apache.ibatis.session.RowBounds;
39
import org.apache.ibatis.session.SqlSession;
40
import org.apache.ibatis.session.SqlSessionFactory;
41
import org.springframework.beans.factory.DisposableBean;
42
import org.springframework.dao.support.PersistenceExceptionTranslator;
43

44
/**
45
 * Thread safe, Spring managed, {@code SqlSession} that works with Spring transaction management to ensure that the
46
 * actual SqlSession used is the one associated with the current Spring transaction. In addition, it manages the session
47
 * life-cycle, including closing, committing or rolling back the session as necessary based on the Spring transaction
48
 * configuration.
49
 * <p>
50
 * The template needs a SqlSessionFactory to create SqlSessions, passed as a constructor argument. It also can be
51
 * constructed indicating the executor type to be used, if not, the default executor type, defined in the session
52
 * factory will be used.
53
 * <p>
54
 * This template converts MyBatis PersistenceExceptions into unchecked DataAccessExceptions, using, by default, a
55
 * {@code MyBatisExceptionTranslator}.
56
 * <p>
57
 * Because SqlSessionTemplate is thread safe, a single instance can be shared by all DAOs; there should also be a small
58
 * memory savings by doing this. This pattern can be used in Spring configuration files as follows:
59
 *
60
 * <pre class="code">
61
 * {@code
62
 * <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
63
 *   <constructor-arg ref="sqlSessionFactory" />
64
 * </bean>
65
 * }
66
 * </pre>
67
 *
68
 * @author Putthiphong Boonphong
69
 * @author Hunter Presnall
70
 * @author Eduardo Macarron
71
 *
72
 * @see SqlSessionFactory
73
 * @see MyBatisExceptionTranslator
74
 */
75
public class SqlSessionTemplate implements SqlSession, DisposableBean {
76

77
  private final SqlSessionFactory sqlSessionFactory;
78

79
  private final ExecutorType executorType;
80

81
  private final SqlSession sqlSessionProxy;
82

83
  private final PersistenceExceptionTranslator exceptionTranslator;
84

85
  /**
86
   * Constructs a Spring managed SqlSession with the {@code SqlSessionFactory} provided as an argument.
87
   *
88
   * @param sqlSessionFactory
89
   *          a factory of SqlSession
90
   */
91
  public SqlSessionTemplate(SqlSessionFactory sqlSessionFactory) {
92
    this(sqlSessionFactory, sqlSessionFactory.getConfiguration().getDefaultExecutorType());
1✔
93
  }
1✔
94

95
  /**
96
   * Constructs a Spring managed SqlSession with the {@code SqlSessionFactory} provided as an argument and the given
97
   * {@code ExecutorType} {@code ExecutorType} cannot be changed once the {@code SqlSessionTemplate} is constructed.
98
   *
99
   * @param sqlSessionFactory
100
   *          a factory of SqlSession
101
   * @param executorType
102
   *          an executor type on session
103
   */
104
  public SqlSessionTemplate(SqlSessionFactory sqlSessionFactory, ExecutorType executorType) {
105
    this(sqlSessionFactory, executorType,
1✔
106
        new MyBatisExceptionTranslator(sqlSessionFactory.getConfiguration().getEnvironment().getDataSource(), true));
1✔
107
  }
1✔
108

109
  /**
110
   * Constructs a Spring managed {@code SqlSession} with the given {@code SqlSessionFactory} and {@code ExecutorType}. A
111
   * custom {@code SQLExceptionTranslator} can be provided as an argument so any {@code PersistenceException} thrown by
112
   * MyBatis can be custom translated to a {@code RuntimeException} The {@code SQLExceptionTranslator} can also be null
113
   * and thus no exception translation will be done and MyBatis exceptions will be thrown
114
   *
115
   * @param sqlSessionFactory
116
   *          a factory of SqlSession
117
   * @param executorType
118
   *          an executor type on session
119
   * @param exceptionTranslator
120
   *          a translator of exception
121
   */
122
  public SqlSessionTemplate(SqlSessionFactory sqlSessionFactory, ExecutorType executorType,
123
      PersistenceExceptionTranslator exceptionTranslator) {
1✔
124

125
    notNull(sqlSessionFactory, "Property 'sqlSessionFactory' is required");
1✔
126
    notNull(executorType, "Property 'executorType' is required");
1✔
127

128
    this.sqlSessionFactory = sqlSessionFactory;
1✔
129
    this.executorType = executorType;
1✔
130
    this.exceptionTranslator = exceptionTranslator;
1✔
131
    this.sqlSessionProxy = (SqlSession) newProxyInstance(SqlSessionFactory.class.getClassLoader(),
1✔
132
        new Class[] { SqlSession.class }, new SqlSessionInterceptor());
133
  }
1✔
134

135
  /**
136
   * Gets the sql session factory.
137
   *
138
   * @return the sql session factory
139
   */
140
  public SqlSessionFactory getSqlSessionFactory() {
141
    return this.sqlSessionFactory;
1✔
142
  }
143

144
  /**
145
   * Gets the executor type.
146
   *
147
   * @return the executor type
148
   */
149
  public ExecutorType getExecutorType() {
150
    return this.executorType;
1✔
151
  }
152

153
  /**
154
   * Gets the persistence exception translator.
155
   *
156
   * @return the persistence exception translator
157
   */
158
  public PersistenceExceptionTranslator getPersistenceExceptionTranslator() {
159
    return this.exceptionTranslator;
×
160
  }
161

162
  @Override
163
  public <T> T selectOne(String statement) {
164
    return this.sqlSessionProxy.selectOne(statement);
1✔
165
  }
166

167
  @Override
168
  public <T> T selectOne(String statement, Object parameter) {
169
    return this.sqlSessionProxy.selectOne(statement, parameter);
1✔
170
  }
171

172
  @Override
173
  public <K, V> Map<K, V> selectMap(String statement, String mapKey) {
174
    return this.sqlSessionProxy.selectMap(statement, mapKey);
×
175
  }
176

177
  @Override
178
  public <K, V> Map<K, V> selectMap(String statement, Object parameter, String mapKey) {
179
    return this.sqlSessionProxy.selectMap(statement, parameter, mapKey);
×
180
  }
181

182
  @Override
183
  public <K, V> Map<K, V> selectMap(String statement, Object parameter, String mapKey, RowBounds rowBounds) {
184
    return this.sqlSessionProxy.selectMap(statement, parameter, mapKey, rowBounds);
×
185
  }
186

187
  @Override
188
  public <T> Cursor<T> selectCursor(String statement) {
189
    return this.sqlSessionProxy.selectCursor(statement);
×
190
  }
191

192
  @Override
193
  public <T> Cursor<T> selectCursor(String statement, Object parameter) {
194
    return this.sqlSessionProxy.selectCursor(statement, parameter);
×
195
  }
196

197
  @Override
198
  public <T> Cursor<T> selectCursor(String statement, Object parameter, RowBounds rowBounds) {
199
    return this.sqlSessionProxy.selectCursor(statement, parameter, rowBounds);
×
200
  }
201

202
  @Override
203
  public <E> List<E> selectList(String statement) {
204
    return this.sqlSessionProxy.selectList(statement);
×
205
  }
206

207
  @Override
208
  public <E> List<E> selectList(String statement, Object parameter) {
209
    return this.sqlSessionProxy.selectList(statement, parameter);
1✔
210
  }
211

212
  @Override
213
  public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) {
214
    return this.sqlSessionProxy.selectList(statement, parameter, rowBounds);
×
215
  }
216

217
  @Override
218
  public void select(String statement, ResultHandler handler) {
219
    this.sqlSessionProxy.select(statement, handler);
×
220
  }
×
221

222
  @Override
223
  public void select(String statement, Object parameter, ResultHandler handler) {
224
    this.sqlSessionProxy.select(statement, parameter, handler);
×
225
  }
×
226

227
  @Override
228
  public void select(String statement, Object parameter, RowBounds rowBounds, ResultHandler handler) {
229
    this.sqlSessionProxy.select(statement, parameter, rowBounds, handler);
×
230
  }
×
231

232
  @Override
233
  public int insert(String statement) {
234
    return this.sqlSessionProxy.insert(statement);
×
235
  }
236

237
  @Override
238
  public int insert(String statement, Object parameter) {
239
    return this.sqlSessionProxy.insert(statement, parameter);
1✔
240
  }
241

242
  @Override
243
  public int update(String statement) {
244
    return this.sqlSessionProxy.update(statement);
×
245
  }
246

247
  @Override
248
  public int update(String statement, Object parameter) {
249
    return this.sqlSessionProxy.update(statement, parameter);
1✔
250
  }
251

252
  @Override
253
  public int delete(String statement) {
254
    return this.sqlSessionProxy.delete(statement);
×
255
  }
256

257
  @Override
258
  public int delete(String statement, Object parameter) {
259
    return this.sqlSessionProxy.delete(statement, parameter);
×
260
  }
261

262
  @Override
263
  public <T> T getMapper(Class<T> type) {
264
    return getConfiguration().getMapper(type, this);
1✔
265
  }
266

267
  @Override
268
  public void commit() {
269
    throw new UnsupportedOperationException("Manual commit is not allowed over a Spring managed SqlSession");
1✔
270
  }
271

272
  @Override
273
  public void commit(boolean force) {
274
    throw new UnsupportedOperationException("Manual commit is not allowed over a Spring managed SqlSession");
×
275
  }
276

277
  @Override
278
  public void rollback() {
279
    throw new UnsupportedOperationException("Manual rollback is not allowed over a Spring managed SqlSession");
1✔
280
  }
281

282
  @Override
283
  public void rollback(boolean force) {
284
    throw new UnsupportedOperationException("Manual rollback is not allowed over a Spring managed SqlSession");
×
285
  }
286

287
  @Override
288
  public void close() {
289
    throw new UnsupportedOperationException("Manual close is not allowed over a Spring managed SqlSession");
1✔
290
  }
291

292
  @Override
293
  public void clearCache() {
294
    this.sqlSessionProxy.clearCache();
×
295
  }
×
296

297
  @Override
298
  public Configuration getConfiguration() {
299
    return this.sqlSessionFactory.getConfiguration();
1✔
300
  }
301

302
  @Override
303
  public Connection getConnection() {
304
    return this.sqlSessionProxy.getConnection();
1✔
305
  }
306

307
  @Override
308
  public List<BatchResult> flushStatements() {
309
    return this.sqlSessionProxy.flushStatements();
1✔
310
  }
311

312
  /**
313
   * Allow gently dispose bean:
314
   *
315
   * <pre>
316
   * {@code
317
   *
318
   * <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
319
   *  <constructor-arg index="0" ref="sqlSessionFactory" />
320
   * </bean>
321
   * }
322
   * </pre>
323
   *
324
   * The implementation of {@link DisposableBean} forces spring context to use {@link DisposableBean#destroy()} method
325
   * instead of {@link SqlSessionTemplate#close()} to shutdown gently.
326
   *
327
   * @see SqlSessionTemplate#close()
328
   * @see "org.springframework.beans.factory.support.DisposableBeanAdapter#inferDestroyMethodIfNecessary(Object, RootBeanDefinition)"
329
   * @see "org.springframework.beans.factory.support.DisposableBeanAdapter#CLOSE_METHOD_NAME"
330
   */
331
  @Override
332
  public void destroy() throws Exception {
333
    // This method forces spring disposer to avoid call of SqlSessionTemplate.close() which gives
334
    // UnsupportedOperationException
335
  }
1✔
336

337
  /**
338
   * Proxy needed to route MyBatis method calls to the proper SqlSession got from Spring's Transaction Manager It also
339
   * unwraps exceptions thrown by {@code Method#invoke(Object, Object...)} to pass a {@code PersistenceException} to the
340
   * {@code PersistenceExceptionTranslator}.
341
   */
342
  private class SqlSessionInterceptor implements InvocationHandler {
1✔
343
    @Override
344
    public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
345
      var sqlSession = getSqlSession(SqlSessionTemplate.this.sqlSessionFactory, SqlSessionTemplate.this.executorType,
1✔
346
          SqlSessionTemplate.this.exceptionTranslator);
347
      try {
348
        var result = method.invoke(sqlSession, args);
1✔
349
        if (!isSqlSessionTransactional(sqlSession, SqlSessionTemplate.this.sqlSessionFactory)) {
1✔
350
          // force commit even on non-dirty sessions because some databases require
351
          // a commit/rollback before calling close()
352
          sqlSession.commit(true);
1✔
353
        }
354
        return result;
1✔
355
      } catch (Throwable t) {
1✔
356
        var unwrapped = unwrapThrowable(t);
1✔
357
        if (SqlSessionTemplate.this.exceptionTranslator != null && unwrapped instanceof PersistenceException) {
1!
358
          // release the connection to avoid a deadlock if the translator is no loaded. See issue #22
359
          closeSqlSession(sqlSession, SqlSessionTemplate.this.sqlSessionFactory);
1✔
360
          sqlSession = null;
1✔
361
          Throwable translated = SqlSessionTemplate.this.exceptionTranslator
1✔
362
              .translateExceptionIfPossible((PersistenceException) unwrapped);
1✔
363
          if (translated != null) {
1!
364
            unwrapped = translated;
1✔
365
          }
366
        }
367
        throw unwrapped;
1✔
368
      } finally {
369
        if (sqlSession != null) {
1✔
370
          closeSqlSession(sqlSession, SqlSessionTemplate.this.sqlSessionFactory);
1✔
371
        }
372
      }
373
    }
374
  }
375

376
}
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE TRIAL · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc