transaction.scala

 case object transaction	{
  import java.sql.Connection

  def apply[T](query: => T):Option[T] = {
    val conn:Connection = play.db.DB.getConnection
    val	auto:Boolean = conn.getAutoCommit
    try	{
      conn.setAutoCommit(false)
      Some(query)
    } catch {
      case e: Exception =>
      	conn.rollback
	None
    } finally {
      conn.commit
      conn.setAutoCommit(auto)
    }
  }
}

{
val conn:Connection = play.db.DB.getConnection
transaction(conn) {
SQL(...)
SQL(...)
}

}

case object transaction {
import java.sql.Connection

def apply[T](connection : java.sql.Connection)(query: => T):Option[T] = {

val auto:Boolean = conn.getAutoCommit
try {
  conn.setAutoCommit(false)
  Some(query)
} catch {
  case e: Exception =>
    conn.rollback
None
} finally {
  conn.commit
  conn.setAutoCommit(auto)
}

}
}