transaction.scala

 case object transaction	{
  import java.sql.Connection

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