search

fwbrasil / activate

Abandoned: Pluggable persistence in Scala
GNU Lesser General Public License v2.1
299 stars 46 forks source link

setUrl + postrgesql #175

Open b0c1 opened 9 years ago

b0c1 commented 9 years ago

I want to use postgres with activate 1.6.2 but I got:

tested with jdbc3 and jdbc4 postrges driver

java.lang.RuntimeException: Could not create datasource instance: org.postgresql.ds.PGSimpleDataSource
    at com.zaxxer.hikari.pool.HikariPool.initializeDataSource(HikariPool.java:502)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:123)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:90)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:69)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorage$class.initConnectionPool(JdbcRelationalStorage.scala:360)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorage$class.delayedInit(JdbcRelationalStorage.scala:349)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorageFactory$PooledJdbcRelationalStorageFromFactory.delayedInit(JdbcRelationalStorage.scala:392)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorageFactory$PooledJdbcRelationalStorageFromFactory.<init>(JdbcRelationalStorage.scala:392)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorageFactory$.buildStorage(JdbcRelationalStorage.scala:401)
    at com.trendensity.web.persistence.ConfigStorageFactory$.fromConfig(ConfigStorageFactory.scala:19)
    at com.trendensity.persistenceContext$delayedInit$body.apply(persistenceContext.scala:8)
    at scala.Function0$class.apply$mcV$sp(Function0.scala:40)
    at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
    at net.fwbrasil.activate.migration.MigrationContext$class.delayedInit(MigrationContext.scala:18)
    at com.trendensity.persistenceContext$.delayedInit(persistenceContext.scala:7)
    at com.trendensity.persistenceContext$.<init>(persistenceContext.scala:7)
    at com.trendensity.persistenceContext$.<clinit>(persistenceContext.scala)
    at com.trendensity.web.Bootstrap.initializeDatabase(Bootstrap.scala:26)
    at com.trendensity.web.Bootstrap.init(Bootstrap.scala:13)
    at org.scalatra.servlet.ScalatraListener.configureCycleClass(ScalatraListener.scala:67)
    at org.scalatra.servlet.ScalatraListener.contextInitialized(ScalatraListener.scala:23)
    at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)
    at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)
    at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)
    at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1349)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1342)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:505)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:41)
    at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:186)
    at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:498)
    at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:146)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:180)
    at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:461)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64)
    at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:609)
    at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:528)
    at org.eclipse.jetty.util.Scanner.scan(Scanner.java:391)
    at org.eclipse.jetty.util.Scanner$1.run(Scanner.java:329)
    at java.util.TimerThread.mainLoop(Timer.java:555)
    at java.util.TimerThread.run(Timer.java:505)
Caused by: 
java.lang.RuntimeException: java.beans.IntrospectionException: Method not found: setUrl
    at com.zaxxer.hikari.util.PropertyBeanSetter.setProperty(PropertyBeanSetter.java:109)
    at com.zaxxer.hikari.util.PropertyBeanSetter.setTargetFromProperties(PropertyBeanSetter.java:61)
    at com.zaxxer.hikari.pool.HikariPool.initializeDataSource(HikariPool.java:497)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:123)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:90)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:69)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorage$class.initConnectionPool(JdbcRelationalStorage.scala:360)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorage$class.delayedInit(JdbcRelationalStorage.scala:349)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorageFactory$PooledJdbcRelationalStorageFromFactory.delayedInit(JdbcRelationalStorage.scala:392)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorageFactory$PooledJdbcRelationalStorageFromFactory.<init>(JdbcRelationalStorage.scala:392)
    at net.fwbrasil.activate.storage.relational.PooledJdbcRelationalStorageFactory$.buildStorage(JdbcRelationalStorage.scala:401)
    at com.trendensity.web.persistence.ConfigStorageFactory$.fromConfig(ConfigStorageFactory.scala:19)
    at com.trendensity.persistenceContext$delayedInit$body.apply(persistenceContext.scala:8)
    at scala.Function0$class.apply$mcV$sp(Function0.scala:40)
    at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
    at net.fwbrasil.activate.migration.MigrationContext$class.delayedInit(MigrationContext.scala:18)
    at com.trendensity.persistenceContext$.delayedInit(persistenceContext.scala:7)
    at com.trendensity.persistenceContext$.<init>(persistenceContext.scala:7)
    at com.trendensity.persistenceContext$.<clinit>(persistenceContext.scala)
    at com.trendensity.web.Bootstrap.initializeDatabase(Bootstrap.scala:26)
    at com.trendensity.web.Bootstrap.init(Bootstrap.scala:13)
    at org.scalatra.servlet.ScalatraListener.configureCycleClass(ScalatraListener.scala:67)
    at org.scalatra.servlet.ScalatraListener.contextInitialized(ScalatraListener.scala:23)
    at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)
    at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)
    at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)
    at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1349)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1342)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:505)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:41)
    at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:186)
    at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:498)
    at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:146)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:180)
    at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:461)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:64)
    at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:609)
    at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:528)
    at org.eclipse.jetty.util.Scanner.scan(Scanner.java:391)
    at org.eclipse.jetty.util.Scanner$1.run(Scanner.java:329)
    at java.util.TimerThread.mainLoop(Timer.java:555)
    at java.util.TimerThread.run(Timer.java:505)
Caused by:
plamola commented 9 years ago

Ran into the same issue, with activate 1.7

Seems the PGSimpleDataSource doesn't like the url property, but expects a databaseName, serverName and portNumber property. See also this thread: http://t28077.db-postgresql-jdbc.databasetalk.us/pgsimpledatasource-not-support-jdbc-url-t28077.html

As a workaround, I've extended the original PooledJdbcRelationalStorage, to remove the url property from the Hikari config and to add the databaseName, serverName and portNumber property.

You can find it here: https://gist.github.com/plamola/15ef3804cfaf6516132a