Failure acquiring datasource

[alexey1607]

Failure acquiring datasource

[alexey1607]

the problem was in istio

[lmsurpre]

@alexey1607 thanks for the update. can we close this one as "invalid" in that case?

[alexey1607]

@lmsurpre you can close. But I have new problem,

I have a postgres cluster and there is a connection puller (pgbouncer) in front of it.

New error

org.postgresql.util.PSQLException: ERROR: prepared statement "S_1" already exists

how do I pass this a connection string?
jdbc:postgresql://pgdb-01:6544,pgdb-02:6544/lfh?ApplicationName=lfh&prepareThreshold=0&reWriteBatchedInserts=true&targetServerType=master

or this

jdbc:postgresql://pgdb-vip:6544/lfh?ApplicationName=lfh&prepareThreshold=0

What config should I edit?
/opt/ol/wlp/usr/servers/defaultServer/configDropins/overrides/datasources.xml
or
/opt/ol/wlp/usr/servers/defaultServer/config/default/fhir-server-config.json

I can't find a description of this in the documentation.

thank you!

[lmsurpre]

The docs for this are at https://linuxforhealth.github.io/FHIR/guides/FHIRServerUsersGuide/#331-the-jdbc-persistence-layer

fhir-server-config.json only has a few persistence fields...the most important of which is the jndiName for the datasource.
so all the connection info is in datasources.xml