I’d suggest using existing JDBC connection pool li...
# vertxo
orangy
02/22/2018, 4:30 PM
I’d suggest using existing JDBC connection pool libraries, such as HikariCP. Unless vert.x has its own, I don’t know…
n
napperley
02/23/2018, 10:54 PMVert.x has native libraries for MySQL, MongoDB, Redis, and Postgres but not for SQL Server.
c
chirag
02/24/2018, 3:17 PMWhat should i use for SQL Server
chirag
02/24/2018, 3:17 PMmy problem is Its connection keeps reset if it stays idle for sometime
o
orangy
02/24/2018, 3:21 PM
That’s normal behavior of any database. If connection is unused (and in many other cases), DB can easily close connection. You shouldn’t rely on connection being stable, it’s just against all odds in modern distributed world 🙂 Connection pools can solve it by maintaining configured number of connection, HikariCP is one of the best I know. I think you can easily find how to use it with vert.x
c
chirag
02/24/2018, 3:24 PMThen how its should be handled in code ?
HikariCP gives different connection properties
chirag
02/24/2018, 3:26 PMCan you please show me any Code snippet ,What practices to follow in production while connecting to DB through JDBC...
This is specifically painful with SQL Server
5 Views