mc0R3euW

1 ✘ adamj@Harvester-LINUX  ~/Development/Personal/Scala/span-digital-exercise   master  sbt "run --db-uri jdbc:mysql://localhost:3306/spandigitalexercise?user=adamj&password=password" 
2[info] Loading settings from idea.sbt ...
3[info] Loading global plugins from /home/adamj/.sbt/1.0/plugins
4[info] Loading settings from plugins.sbt,assembly.sbt ...
5[info] Loading project definition from /rhome/adamj/Development/Personal/Scala/span-digital-exercise/project                                                                                                                                
6[info] Loading settings from build.sbt ...                                                                                                                                                                                                  
7[info] Set current project to span-digital-exercise (in build file:/rhome/adamj/Development/Personal/Scala/span-digital-exercise/)                                                                                                          
8[info] Compiling 1 Scala source to /rhome/adamj/Development/Personal/Scala/span-digital-exercise/target/scala-2.12/classes ...                                                                                                              
9[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:35:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.                                                                                                                                                                                                                               
10[info]     context.run(query[Teams].filter(_.name == lift(name))) match {                                                                                                                                                                   
11[info]                ^                                                                                                                                                                                                                     
12[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:35:16: Dynamic query                                                                                    
13[info]     context.run(query[Teams].filter(_.name == lift(name))) match {                                                                                                                                                                   
14[info]                ^                                                                                                                                                                                                                     
15[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:49:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.                                                                                                                                                                                                                               
16[info]     context.run(query[Teams].sortBy(_.id)(Ord.ascNullsLast))                                                                                                                                                                         
17[info]                ^                                                                                                                                                                                                                     
18[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:49:16: Dynamic query                                                                                    
19[info]     context.run(query[Teams].sortBy(_.id)(Ord.ascNullsLast))                                                                                                                                                                         
20[info]                ^                                                                                                                                                                                                                     
21[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:59:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.                                                                                                                                                                                                                               
22[info]     context.run(query[Teams].insert(_.name -> lift(name)).returning(_.id))                                                                                                                                                           
23[info]                ^                                                                                                                                                                                                                     
24[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:59:16: Dynamic query                                                                                    
25[info]     context.run(query[Teams].insert(_.name -> lift(name)).returning(_.id))                                                                                                                                                           
26[info]                ^                                                                                                                                                                                                                     
27[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:68:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.                                                                                                                                                                                                                               
28[info]     context.run(query[Results].sortBy(_.id)(Ord.ascNullsLast))                                                                                                                                                                       
29[info]                ^                                                                                                                                                                                                                     
30[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:68:16: Dynamic query                                                                                    
31[info]     context.run(query[Results].sortBy(_.id)(Ord.ascNullsLast))                                                                                                                                                                       
32[info]                ^                                                                                                                                                                                                                     
33[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:80:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.                                                                                                                                                                                                                               
34[info]     context.run(                                                                                                                                                                                                                     
35[info]                ^                                                                                                                                                                                                                     
36[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:80:16: Dynamic query                                                                                    
37[info]     context.run(                                                                                                                                                                                                                     
38[info]                ^
39[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:221:16: Can't translate query at compile time because the idiom and/or the naming strategy aren't known at this point.
40[info]     context.run(teamNameTotalPointsQuery.sortBy(_._2)(Ord.descNullsLast))
41[info]                ^
42[info] /rhome/adamj/Development/Personal/Scala/span-digital-exercise/src/main/scala/com/github/oopman/spandigitalexercise/DAO.scala:221:16: Dynamic query
43[info]     context.run(teamNameTotalPointsQuery.sortBy(_._2)(Ord.descNullsLast))
44[info]                ^
45[info] Done compiling.
46[info] Packaging /rhome/adamj/Development/Personal/Scala/span-digital-exercise/target/scala-2.12/span-digital-exercise_2.12-1.0.jar ...
47[info] Done packaging.
48[info] Running com.github.oopman.spandigitalexercise.Main --db-uri jdbc:mysql://localhost:3306/spandigitalexercise?user=adamj&password=password
49Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
50[error] (run-main-0) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE  IF NOT EXISTS results
51[error] (
52[error]   id INTEGER NOT NULL PRIMARY KEY AUTO_INC' at line 7
53[error] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE  IF NOT EXISTS results
54[error] (
55[error]   id INTEGER NOT NULL PRIMARY KEY AUTO_INC' at line 7
56[error]         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
57[error]         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
58[error]         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
59[error]         at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
60[error]         at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
61[error]         at com.mysql.jdbc.Util.getInstance(Util.java:387)
62[error]         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
63[error]         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
64[error]         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
65[error]         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
66[error]         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
67[error]         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
68[error]         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
69[error]         at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
70[error]         at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
71[error]         at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
72[error]         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
73[error]         at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
74[error]         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
75[error]         at io.getquill.context.jdbc.JdbcContext.$anonfun$executeAction$1(JdbcContext.scala:98)
76[error]         at io.getquill.context.jdbc.JdbcContext.$anonfun$executeAction$1$adapted(JdbcContext.scala:95)
77[error]         at io.getquill.context.jdbc.JdbcContext.$anonfun$withConnection$1(JdbcContext.scala:44)
78[error]         at scala.Option.getOrElse(Option.scala:121)
79[error]         at io.getquill.context.jdbc.JdbcContext.withConnection(JdbcContext.scala:42)
80[error]         at io.getquill.context.jdbc.JdbcContext.executeAction(JdbcContext.scala:95)
81[error]         at com.github.oopman.spandigitalexercise.DAO.<init>(DAO.scala:26)
82[error]         at com.github.oopman.spandigitalexercise.CLI$.apply(CLI.scala:94)
83[error]         at com.github.oopman.spandigitalexercise.Main$.delayedEndpoint$com$github$oopman$spandigitalexercise$Main$1(Main.scala:7)
84[error]         at com.github.oopman.spandigitalexercise.Main$delayedInit$body.apply(Main.scala:6)
85[error]         at scala.Function0.apply$mcV$sp(Function0.scala:34)
86[error]         at scala.Function0.apply$mcV$sp$(Function0.scala:34)
87[error]         at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
88[error]         at scala.App.$anonfun$main$1$adapted(App.scala:76)
89[error]         at scala.collection.immutable.List.foreach(List.scala:389)
90[error]         at scala.App.main(App.scala:76)
91[error]         at scala.App.main$(App.scala:74)
92[error]         at com.github.oopman.spandigitalexercise.Main$.main(Main.scala:6)
93[error]         at com.github.oopman.spandigitalexercise.Main.main(Main.scala)
94[error]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
95[error]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
96[error]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
97[error]         at java.lang.reflect.Method.invoke(Method.java:498)
98[error]         at sbt.Run.invokeMain(Run.scala:93)
99[error]         at sbt.Run.run0(Run.scala:87)
100[error]         at sbt.Run.execute$1(Run.scala:65)
101[error]         at sbt.Run.$anonfun$run$4(Run.scala:77)
102[error]         at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:12)
103[error]         at sbt.util.InterfaceUtil$$anon$1.get(InterfaceUtil.scala:10)
104[error]         at sbt.TrapExit$App.run(TrapExit.scala:252)
105[error]         at java.lang.Thread.run(Thread.java:748)
106Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
107Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
108Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
109[error] java.lang.RuntimeException: Nonzero exit code: 1
110[error]         at sbt.Run$.executeTrapExit(Run.scala:124)
111[error]         at sbt.Run.run(Run.scala:77)
112[error]         at sbt.Defaults$.$anonfun$bgRunTask$5(Defaults.scala:1185)
113[error]         at sbt.Defaults$.$anonfun$bgRunTask$5$adapted(Defaults.scala:1180)
114[error]         at sbt.internal.BackgroundThreadPool.$anonfun$run$1(DefaultBackgroundJobService.scala:366)
115[error]         at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:12)
116[error]         at scala.util.Try$.apply(Try.scala:209)
117[error]         at sbt.internal.BackgroundThreadPool$BackgroundRunnable.run(DefaultBackgroundJobService.scala:289)
118[error]         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
119[error]         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
120[error]         at java.lang.Thread.run(Thread.java:748)
121[error] (Compile / run) Nonzero exit code: 1
122Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
123[error] Total time: 17 s, completed 05 Jun 2018 7:54:19 PM
124Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
125Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
126Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
127Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
128Tue Jun 05 19:54:19 SAST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.