Slick - MySQL Syntax Error

Question

I'm using the Play Framework (2.3.1) together with Slick (play-slick version 0.8.0-M1) and a MySQL Database (5.5.28).

One of my queries results in a MySQLSyntaxErrorException:

Preparing statement: select x2."id", x2."course_id", x2."trainee_id", x2."transaction_id" from "trainee_grouptraining_GroupBooking" x2 where x2."course_id" = 1

The problem appears to be with the double quotation marks, since other queries work just fine and they use single quotation marks like the following:

Preparing statement: select x2.`id`, x2.`courseLanguage`, x2.`date`, x2.`description`, x2.`duration`, x2.`kind`, x2.`maxParticipants`, x2.`name`, x2.`courseType_id`, x2.`trainer_id` from `Course` x2 where x2.`id` = 1

What can i do about this?

Answer 1

I guess you are importing

scala.slick.driver.JdbcDriver.simple._

You should import

scala.slick.driver.MySQLDriver.simple._

instead.