'Spring Boot: connect to a unix socket (pgpool)

I am unable to connect to a unix socket via Spring Boot (to connect to Pgpool-II).

From what I've seen, this can be done in two steps:

  • Add junixsocket to my maven/gradle dependencies
  • Pass the JDBC properties socketFactory and socketFactoryArg

I thought I could pass the properties easily via my application.properties file, but it doesn't work. For example :

spring.datasource.socketFactory=...
spring.datasource.socketFactoryArg=...

I'm not going to detail everything here, but I tried a lot of things without success. It should not be very complicated, but being new to Spring Boot, I think I'm missing something...

Does anyone have experience with unix sockets and Spring Boot?

NOTE: junixsocket offers "Command-line demo" to test, and it works very well. For me it's just related to my bad Spring Boot configuration.

javapostgresqlspring-bootunix-socketpgpool


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions