[2.3] HikariCP Plugin 2.0.0 for Play Framework 2.3.x

[Megazord]

That is it!

https://github.com/edulify/play-hikaricp.edulify.com/releases/tag/2.0.0

I have released a complete new version of HikariCP Plugin. The release notes have more details.

Thanks to people who spent some of their time reviewing the code and even submitting pull requests. I think the project now has better code and better docs thanks to contributors.

Best,

--
Edulify.com Team

[Yann Simon]

congrats!!!

--
You received this message because you are subscribed to the Google Groups "play-framework" group.
To unsubscribe from this group and stop receiving emails from it, send an email to play-framewor...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[ßìnòy S]

I have tried and tried again to configure 2.x HikariCP plugin to work with Oracle using dataSource

Can someone post a working oracle configuration for HikariCP where port number is different from default?

Also I have my connection string in jdbcURl format like below

jdbcUrl = "jdbc:oracle:thin:@(DESCRIPTION = (LOAD_BALANCE=OFF)(FAILOVER=ON) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = odb.xyz.com)(PORT = 1111)) (ADDRESS = (PROTOCOL = TCP)(HOST = odb.xyz.com)(PORT = 1111))) (CONNECT_DATA = (SERVICE_NAME = ABCDEF)))"

I've pulled my hair off to get this to working using datasource but failed miserably.

Finally have reverted back to old version.

Appreciate the help

[Megazord]

Hello ßìnòy,

1. How was your dataSource configuration?
2. What was the stack trace or failure message?
3. Which version of play are you using?
4. To which old version you revert to? How is it configured?

HTH

[ßìnòy S]

Replies Inline

On Thursday, February 26, 2015 at 8:40:58 AM UTC-5, Megazord wrote:

Hello ßìnòy,

1. How was your dataSource configuration?

 

db {

  default {

    # You can expose this datasource via JNDI if needed (Useful for JPA)

    jndiName=LocalDevDS

    # Set a connection's default autocommit setting

    autocommit=true

    dataSourceClassName=oracle.jdbc.pool.OracleDataSource

    datasource{

      serverName=abc.def.com

      user=abcuser

      password=abcpass

      databaseName=ghidb

      portNumber=1234

      driverType=thin

    }

    maximumPoolSize=8

    registerMbeans=true

    # 15 minutes

    maxLifetime=450000

    # 5 minutes

    idleTimeout=300000

    connectionTimeout=60000

  }

}

 

 

2. What was the stack trace or failure message?

Caused by: java.lang.RuntimeException: Fail-fast during pool initialization

at com.zaxxer.hikari.pool.BaseHikariPool.initializeConnections(BaseHikariPool.java:500) ~[HikariCP-2.3.2.jar:na]

at com.zaxxer.hikari.pool.BaseHikariPool.<init>(BaseHikariPool.java:172) ~[HikariCP-2.3.2.jar:na]

at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:61) ~[HikariCP-2.3.2.jar:na]

at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:49) ~[HikariCP-2.3.2.jar:na]

at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) ~[HikariCP-2.3.2.jar:na]

at com.edulify.play.hikaricp.HikariCPDBApi$$anonfun$1.apply(HikariCPDBApi.scala:50) ~[play-hikaricp_2.11-2.0.0.jar:2.0.0]

... 35 common frames omitted

Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL

at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1536) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:214) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:184) ~[ojdbc7.jar:12.1.0.2.0]

at com.zaxxer.hikari.pool.BaseHikariPool.addConnection(BaseHikariPool.java:396) ~[HikariCP-2.3.2.jar:na]

at com.zaxxer.hikari.pool.BaseHikariPool.initializeConnections(BaseHikariPool.java:498) ~[HikariCP-2.3.2.jar:na]

... 40 common frames omitted

 

3. Which version of play are you using?

addSbtPlugin("com.typesafe.play" % "sbt-plugin" % "2.3.8")

 

4. To which old version you revert to? How is it configured?

db {

  default {

    # You can expose this datasource via JNDI if needed (Useful for JPA)

    jndiName=LocalDevDS

    driverClassName=oracle.jdbc.OracleDriver

    jdbcUrl="jdbc:oracle:thin:@abcd.defg.com:1234:ghidb"

    username=abc

    password=def

    # Set a connection's default autocommit setting

    autocommit=true

    maximumPoolSize=8

    registerMbeans=true

    # 15 minutes

    maxLifetime=450000

    # 5 minutes

    idleTimeout=300000

    connectionTimeout=60000

  }

}

[Megazord]

ßìnòy,

1. The problem is that you have to use "dataSource", with a capital "S".
4. This configuration should work with the new version, exception it is "autoCommit", again with a capital "C"

HTH

[ßìnòy S]

That worked.

Thanks