<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Calibri">Hello,<br>
<br>
In my project I have over than 500 Resources integrated by using
DatabaseTable Resource Connector, all have its own database table
in a only one Postgres database schema instance (not the same used
by midpoint application).<br>
I scheduled for each a reconciliation task once per day, delayed
in a way that no more than two tasks runs in parallel.<br>
<br>
I see that after some hours of uptime, the number of opened
connections to postgres increase up to database limit, that is
100, and will no longer released, causing the following error at
next task execution: <br>
<br>
org.identityconnectors.framework.common.exceptions.ConnectorException:
org.postgresql.util.PSQLException: FATAL: remaining connection
slots are reserved for roles with the SUPERUSER attribute<br>
<br>
How can I avoid this and force to release connection after task
completion?<br>
<br>
Notice that each resource have its own database configuration,
that opens a new connection at reconciliation start, I suppose
that by sharing a connection pool among all resources may resolve,
but I don't find any documentation other than: <br>
<br>
</font><font face="Calibri"><span style="color: rgb(0, 0, 0);
font-family: Roboto, "Open Sans", -apple-system,
BlinkMacSystemFont, "Segoe UI", Roboto,
"Helvetica Neue", Arial, "Noto Sans",
sans-serif, "Apple Color Emoji", "Segoe UI
Emoji", "Segoe UI Symbol", "Noto Color
Emoji"; font-size: 16px; font-style: normal;
font-variant-ligatures: normal; font-variant-caps: normal;
font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: left; text-indent: 0px; text-transform: none;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;
white-space: normal; background-color: rgb(255, 255, 255);
text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial; display: inline
!important; float: none;">"It is not yet clear how to set up
data sources for embedded Tomcat."<br>
</span><a class="moz-txt-link-freetext" href="https://docs.evolveum.com/midpoint/devel/guides/environment/embedded-tomcat/">https://docs.evolveum.com/midpoint/devel/guides/environment/embedded-tomcat/</a><br>
<br>
</font><font face="Calibri"> I'm using midpoint embedded in a docker
container, that make use of tomcat embedded<br>
<br>
Thanks in advance,<br>
AXP<br>
</font><font face="Calibri"></font>
</body>
</html>