/
TxPerRequestFilter.scala
37 lines (32 loc) · 1.35 KB
/
TxPerRequestFilter.scala
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
package skinny.orm.servlet
import scalikejdbc._
import javax.servlet._
import org.slf4j.LoggerFactory
import javax.servlet.http.HttpServletRequest
class TxPerRequestFilter extends PerRequestFilterBase {
private[this] val logger = LoggerFactory.getLogger(classOf[TxPerRequestFilter])
override def doFilter(req: ServletRequest, res: ServletResponse, chain: FilterChain) = {
if (isDBSessionRequired(req.asInstanceOf[HttpServletRequest])) {
using(connectionPool.borrow()) { conn =>
logger.debug(s"Thread local db session is borrowed from the pool. (connection pool: ${connectionPool.url})")
val db = ThreadLocalDB.create(conn)
try {
db.begin()
logger.debug(s"Thread local db session begun. (connection pool: ${connectionPool.url})")
chain.doFilter(req, res)
db.commit()
logger.debug(s"Thread local db session is committed. (connection pool: ${connectionPool.url})")
} catch {
case t: Throwable =>
db.rollbackIfActive()
logger.debug(s"Thread local db session is rolled back. (connection pool: ${connectionPool.url})")
throw t
} finally {
logger.debug(s"Thread local db session is returned to the pool. (connection pool: ${connectionPool.url})")
}
}
} else {
chain.doFilter(req, res)
}
}
}