import scala.slick.driver.PostgresDriver
private val postgres = PostgresDriver.simple.Database.forURL(url, driver = driver)


def myMethod(testCode: Session => Any) {
  val session = postgres.createSession()

  session.conn.setAutoCommit(false)
  try {
  testCode(session)
  } finally {
  session.rollback()
  session.close()
}

SBT具有以下依赖关系

"com.typesafe.slick" %% "slick" % "2.1.0",
"com.github.tminglei" %% "slick-pg" % "0.6.3"

虽然我已将Autocomit设置为FALSE，但我得到了关注。我一定遗漏了什么？

scala.slick.SlickException: Cannot roll back session in auto-commit mode
at scala.slick.jdbc.JdbcBackend$BaseSession.rollback(JdbcBackend.scala:415)
at mycompany.tests.DatabaseSpec$class.withSession(DatabaseSpec.scala:29)

使用myMethod的API有

tableQuery.insertOrUpdate(tableRow)

推荐答案

Slick中的会话.Rollback()实现是

def rollback() {
  if(conn.getAutoCommit) throw new SlickException("Cannot roll back session in auto-commit mode")
  doRollback = true
}

您的连接似乎出于某种原因保持在自动提交模式。油滑似乎不是原因。