Using play-slick with Vertica

[Jordan Messec]

Hi, 

I'm maintaining a Play project which I have recently updated from Play 2.3 to 2.5.4. One of the changes this includes is an update of slick and play-slick. 

My team is using Vertica as our underlying db. Although Slick does not technically provide support for Vertica, in the previous version I was able to use Vertica with the following application.conf setup:

db.vertica.slickdriver=scala.slick.driver.JdbcDriver

db.vertica.driver=com.vertica.jdbc.Driver

db.vertica.url=${some.url}

db.vertica.user=${some.user}

db.vertica.password=${some.pw}

Hoping that I could use a similar setup with the new version of slick and play-slick, my conf file now contains:

slick.dbs.default.driver=slick.driver.JdbcDriver

# I have also tried "slick.driver.JdbcDriver$" and "slick.driver.JdbcDriver$class"
slick.dbs.default.db.driver=com.vertica.jdbc.Driver
slick.dbs.default.db.url=${some.urll}
slick.dbs.default.db.user=${some.user}
slick.dbs.default.db.password=${some.password}

I also have in my build.sbt:

libraryDependencies ++= Seq(

"com.typesafe.slick" %% "slick" % "3.1.1",

"com.typesafe.play" %% "play-slick" % "2.0.0",

"com.vertica" % "vertica-jdbc" % "7.0.1"

...)

However this results in the following error when starting the Play application:

[ERROR] [10/06/2016 16:30:40.942] [p.a.d.s.DefaultSlickApi] [*] Failed to create Slick database config for key default.

slick.SlickException: Error getting instance of Slick driver "slick.driver.JdbcDriver$class"

at slick.backend.DatabaseConfig$.forConfig(DatabaseConfig.scala:65)

at play.api.db.slick.DefaultSlickApi$DatabaseConfigFactory.create(SlickApi.scala:89)

at play.api.db.slick.DefaultSlickApi$DatabaseConfigFactory.get$lzycompute(SlickApi.scala:81)

at play.api.db.slick.DefaultSlickApi$DatabaseConfigFactory.get(SlickApi.scala:80)

at play.api.db.slick.DefaultSlickApi.dbConfig(SlickApi.scala:66)

at play.api.db.slick.NamedDatabaseConfigProvider$$anon$1.get(SlickModule.scala:59)

at utils.liger.DimensionMapper.<init>(DimensionMapper.scala:32)

at utils.liger.DimensionMapper$$FastClassByGuice$$1320fe73.newInstance(<generated>)

at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)

at com.google.inject.internal.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:61)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:105)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)

at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:104)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)

at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:104)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)

at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:104)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.InjectorImpl$2$1.call(InjectorImpl.java:1016)

at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1103)

at com.google.inject.internal.InjectorImpl$2.get(InjectorImpl.java:1012)

at com.google.inject.internal.InjectorImpl.getInstance(InjectorImpl.java:1051)

at play.api.inject.guice.GuiceInjector.instanceOf(GuiceInjectorBuilder.scala:405)

at play.api.inject.RoutesProvider$$anonfun$2.apply(BuiltinModule.scala:82)

at play.api.inject.RoutesProvider$$anonfun$2.apply(BuiltinModule.scala:82)

at scala.Option.fold(Option.scala:158)

at play.api.inject.RoutesProvider.get$lzycompute(BuiltinModule.scala:82)

at play.api.inject.RoutesProvider.get(BuiltinModule.scala:78)

at play.api.inject.RoutesProvider.get(BuiltinModule.scala:77)

at com.google.inject.internal.ProviderInternalFactory.provision(ProviderInternalFactory.java:81)

at com.google.inject.internal.BoundProviderFactory.provision(BoundProviderFactory.java:72)

at com.google.inject.internal.ProviderInternalFactory.circularGet(ProviderInternalFactory.java:61)

at com.google.inject.internal.BoundProviderFactory.get(BoundProviderFactory.java:62)

at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)

at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:104)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)

at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:104)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:56)

at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)

at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:104)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:56)

at com.google.inject.internal.SingleParameterInjector.inject(SingleParameterInjector.java:38)

at com.google.inject.internal.SingleParameterInjector.getAll(SingleParameterInjector.java:62)

at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:104)

at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)

at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:267)

at com.google.inject.internal.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:46)

at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1103)

at com.google.inject.internal.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:40)

at com.google.inject.internal.SingletonScope$1.get(SingletonScope.java:145)

at com.google.inject.internal.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:41)

at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:56)

at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:205)

at com.google.inject.internal.InternalInjectorCreator$1.call(InternalInjectorCreator.java:199)

at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1092)

at com.google.inject.internal.InternalInjectorCreator.loadEagerSingletons(InternalInjectorCreator.java:199)

at com.google.inject.internal.InternalInjectorCreator.injectDynamically(InternalInjectorCreator.java:180)

at com.google.inject.internal.InternalInjectorCreator.build(InternalInjectorCreator.java:110)

at com.google.inject.Guice.createInjector(Guice.java:96)

at com.google.inject.Guice.createInjector(Guice.java:84)

at play.api.inject.guice.GuiceBuilder.injector(GuiceInjectorBuilder.scala:181)

at play.api.inject.guice.GuiceApplicationBuilder.build(GuiceApplicationBuilder.scala:123)

at play.api.inject.guice.GuiceApplicationLoader.load(GuiceApplicationLoader.scala:21)

at play.core.server.ProdServerStart$.start(ProdServerStart.scala:47)

at play.core.server.ProdServerStart$.main(ProdServerStart.scala:22)

at play.core.server.ProdServerStart.main(ProdServerStart.scala)

Caused by: java.lang.InstantiationException: slick.driver.JdbcDriver$class

at java.lang.Class.newInstance(Class.java:427)

at slick.backend.DatabaseConfig$.forConfig(DatabaseConfig.scala:63)

... 84 common frames omitted

Caused by: java.lang.NoSuchMethodException: slick.driver.JdbcDriver$class.<init>()

at java.lang.Class.getConstructor0(Class.java:3082)

at java.lang.Class.newInstance(Class.java:412)

... 85 common frames omitted

I'm willing to do what it takes to help slick work with Vertica, but I don't know where to start. Does anyone see anything I may have missed or have any advice on where to go to get started?

[Jordan Messec]

According to Slick 3.1 docs: 

Other SQL databases can be accessed right away with a reduced feature set.

 But I can't find anything explaining how that can be accomplished.