Advertisement
Guest User

Untitled

a guest
Mar 13th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. TABLE()
  2.  
  3. Syntax error in SQL statement "TABLE[*]()"; expected "TRUNCATE, {"; SQL statement:
  4. TABLE() [42001-191] [SQL State=42001, DB Errorcode=42001]
  5.  
  6. SELECT * FROM M
  7.  
  8. Table "M" not found; SQL statement:
  9. SELECT * FROM M [42102-191] [SQL State=42S02, DB Errorcode=42102]my
  10.  
  11. import slick.driver.H2Driver.api._
  12. import scala.concurrent.Await
  13. import scala.concurrent.duration._
  14. import scala.concurrent.ExecutionContext.Implicits.global
  15.  
  16. final case class Message(sender:String, content:String)
  17.  
  18. final class MessageTable(tag: Tag) extends Table[Message](tag, "M") {
  19.  
  20. def id = column[Long]("id", O.PrimaryKey, O.AutoInc)
  21.  
  22. def sender = column[String]("sender")
  23.  
  24. def content = column[String]("content")
  25.  
  26. def * = (sender, content) <>(Message.tupled, Message.unapply)
  27. }
  28.  
  29. object Curator {
  30. def main(args: Array[String]) {
  31. final case class Message(sender: String, content: String)
  32. val db = Database.forConfig("h2file")
  33. lazy val messages = TableQuery[MessageTable]
  34. Await.ready(db.run(messages.schema.create),2 seconds)
  35. db.close()
  36. }
  37. }
  38.  
  39. h2file = {
  40. connectionPool = disabled
  41. url = "jdbc:h2:~/scala/workspace/Curator/t"
  42. driver = "org.h2.Driver"
  43. keepAliveConnection = true
  44. }
  45.  
  46. name := "Curator"
  47.  
  48. version := "1.0"
  49.  
  50. scalaVersion := "2.11.8"
  51.  
  52. libraryDependencies ++= Seq(
  53. "com.typesafe.slick" %% "slick" % "3.1.0",
  54. "com.h2database" % "h2" % "1.4.185",
  55. "ch.qos.logback" % "logback-classic" % "1.1.2"
  56. )
  57.  
  58. Driver: H2 Database Engine (org.h2.Driver)
  59. URL: jdbc:h2:~/scala/workspace/Curator/t"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement