aurora db (mysql) syntax error

256 views

Skip to first unread message

Andres March

unread,

Sep 22, 2017, 4:56:36 PM9/22/17

to Lagom Framework Users

We are seeing issues creating the schema in aurora with slick using the mariadb driver. It seems like a simple syntax issue but I wanted to check before I work on a fix.

our config:

jdbc-defaults.slick.driver = "slick.driver.MySQLDriver$"

db.default {

driver = "org.mariadb.jdbc.Driver"

url = "jdbc:mysql:aurora://somehost.aws.io:3306/dbName_"${env}

username = user_name

password = "secret"

}

the error:

[[31merror[0m] a.a.OneForOneStrategy - invalid callable syntax. must be like {? = call <procedure/function name>[(?,?, ...)]}

but was : create table `journal` (`ordering` BIGINT NOT NULL AUTO_INCREMENT UNIQUE,`deleted` BOOLEAN DEFAULT false NOT NULL,`persistence_id` VARCHAR(255) NOT NULL,`sequence_number` BIGINT NOT NULL,`message` BLOB NOT NULL,`tags` VARCHAR(255))

java.sql.SQLSyntaxErrorException: invalid callable syntax. must be like {? = call <procedure/function name>[(?,?, ...)]}

at org.mariadb.jdbc.MariaDbConnection.prepareCall(MariaDbConnection.java:558)

at org.mariadb.jdbc.MariaDbConnection.prepareCall(MariaDbConnection.java:526)

at com.zaxxer.hikari.pool.ProxyConnection.prepareCall(ProxyConnection.java:289)

at com.zaxxer.hikari.pool.HikariProxyConnection.prepareCall(HikariProxyConnection.java)

at com.lightbend.lagom.internal.persistence.jdbc.SlickProvider$$anonfun$com$lightbend$lagom$internal$persistence$jdbc$SlickProvider$$createTableInternal$1$$anonfun$apply$5.apply(SlickProvider.scala:140)

at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:70)

at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:69)

at slick.dbio.DBIOAction$$anon$1$$anonfun$run$1.apply(DBIOAction.scala:161)

[[31merror[0m] a.a.OneForOneStrategy - invalid callable syntax. must be like {? = call <procedure/function name>[(?,?, ...)]}

but was : create table `read_side_offsets` (`read_side_id` VARCHAR(255) NOT NULL,`tag` VARCHAR(255) NOT NULL,`sequence_offset` BIGINT,`time_uuid_offset` CHAR(36))