<div dir="ltr">At the moment when the provider is specified in keycloak-server.json we only load that one provider. If you only need to use the EntityManagerFactory within your user federation provider you don't need a JpaConnectionProvider at all. Just create the EntityManagerFactory within your UserFederationProviderFactory. We only use the JpaConnectionProvider as we have multiple providers using the same EntityManagerFactory.</div><div class="gmail_extra"><br><div class="gmail_quote">On 29 October 2015 at 13:57, Matuszak, Eduard <span dir="ltr"><<a href="mailto:eduard.matuszak@atos.net" target="_blank">eduard.matuszak@atos.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<font face="Calibri" size="2"><span style="font-size:11pt">
<div>Hello</div>
<div> </div>
<div>I am trying to implement a userfederation-provider based on a jpa-connection. My approach was:</div>
<div> </div>
<div>According to an additional datasource-defintion for the federated DB in the standalone.xml</div>
<div> </div>
<div><font size="1"><span style="font-size:8pt"> <datasource jta="true" jndi-name="<font color="red"><b>java:jboss/datasources/CCPDS</b></font>" pool-name="CCPDS" enabled="true" use-ccm="true"></span></font></div>
<div><font size="1"><span style="font-size:8pt"> <connection-url>jdbc:oracle:thin:@servername:1521:schemaname</connection-url></span></font></div>
<div style="padding-left:36pt"><font size="1"><span style="font-size:8pt">..</span></font></div>
<div> </div>
<div>, I tried to register this datasource as an additional connectionJpa-entry in keycloak-server.json as follows:</div>
<div> </div>
<div><font size="1"><span style="font-size:8pt">..</span></font></div>
<div><font size="1"><span style="font-size:8pt"> "connectionsJpa": {</span></font></div>
<div><font size="1"><span style="font-size:8pt"> "default": {</span></font></div>
<div><font size="1"><span style="font-size:8pt"> "dataSource": "java:jboss/datasources/CCPKCDS",</span></font></div>
<div><font size="1"><span style="font-size:8pt"> "databaseSchema": "update"</span></font></div>
<div><font size="1"><span style="font-size:8pt"> }<font color="red"><b>,</b></font></span></font></div>
<div><font size="1" color="red"><span style="font-size:8pt"><b> "</b><b>FED</b><b>-</b><b>DB</b><b>": {</b></span></font></div>
<div><font size="1" color="red"><span style="font-size:8pt"><b> "dataSource": "java:jboss/datasources/CCPDS"</b></span></font></div>
<div><font size="1" color="red"><span style="font-size:8pt"><b> }</b></span></font></div>
<div><font size="1"><span style="font-size:8pt"> },</span></font></div>
<div><font size="1"><span style="font-size:8pt">..</span></font></div>
<div> </div>
<div>According to these configuration I hoped to be able to establish the appropriate entity manager by coding:</div>
<div> </div>
<div><font face="Consolas" size="1"><span style="font-size:8pt"> <font color="#3F7F5F">// Get the appropriate entity manager from the KeycloakSession</font></span></font></div>
<div><font face="Consolas" size="1"><span style="font-size:8pt"> EntityManager <font color="#6A3E3E">em</font> = <font color="#6A3E3E">session</font>.getProvider(JpaConnectionProvider.<font color="#7F0055"><b>class</b></font>, <font color="#2A00FF">"</font><font color="red"><b>FED</b></font><font color="red"><b>-</b></font><font color="red"><b>DB</b></font><font color="#2A00FF">"</font>).getEntityManager();</span></font></div>
<div> </div>
<div>This did not work, indeed there is still only one (default) JpaConnectionProvider available in the session (JpaConnectionProviderList size is 1):</div>
<div> </div>
<div><font face="Consolas" size="2"><span style="font-size:10pt"> Set<JpaConnectionProvider> <font color="#6A3E3E"><u>JpaConnectionProviderList</u></font> = <font color="#6A3E3E">session</font>.getAllProviders(JpaConnectionProvider.<font color="#7F0055"><b>class</b></font>);</span></font></div>
<div> </div>
<div>My question is: isn’t it in principle possible to register a second jpaConnector additionally to the default one or is there something missing or wrong in my approach?</div>
<div> </div>
<div>Thanks for any help in advance.</div>
<div> </div>
<div><font face="Verdana" size="2"><span style="font-size:9pt">Best regards, Eduard Matuszak</span></font></div>
<div><font face="Verdana" size="2"><span style="font-size:9pt"> </span></font></div>
<div><img><font size="2"><span style="font-size:9pt"> </span></font></div>
<div><font face="Verdana" size="2" color="#1F497D"><span style="font-size:9pt"><b>Dr. Eduard Matuszak</b></span></font></div>
<div> </div>
<div><font face="Verdana" size="1"><span style="font-size:8pt">Worldline, an atos company</span></font></div>
<div><font face="Verdana" size="1"><span style="font-size:8pt">T <a href="tel:%2B49%20%28211%29399%20398%2063" value="+4921139939863" target="_blank">+49 (211)399 398 63</a></span></font></div>
<div><font face="Verdana" size="1"><span style="font-size:8pt">M <a href="tel:%2B49%20%28163%29166%2023%2067" value="+491631662367" target="_blank">+49 (163)166 23 67</a></span></font></div>
<div><font face="Verdana" size="1"><span style="font-size:8pt">F <a href="tel:%2B49%28211%29%20399%2022%20430" value="+4921139922430" target="_blank">+49(211) 399 22 430</a></span></font></div>
<div><a href="mailto:eduard.matuszak@atos.net" target="_blank"><font face="Verdana" size="1" color="blue"><span style="font-size:8pt"><u>eduard.matuszak@atos.net</u></span></font></a><font face="Verdana" size="1" color="#1F497D"><span style="font-size:8pt"> </span></font></div>
<div><font face="Verdana" size="1"><span style="font-size:8pt">Max-Stromeyer-Straße 116</span></font></div>
<div><font face="Verdana" size="1"><span style="font-size:8pt">78467 Konstanz</span></font></div>
<div><font face="Verdana" size="1"><span style="font-size:8pt">Germany</span></font></div>
<div><a href="http://worldline.com/de/1/Home.html" target="_blank"><font face="Verdana" size="1" color="blue"><span style="font-size:8pt"><u>de.worldline.com</u></span></font></a></div>
<div><a href="http://worldline.jobs.de" target="_blank"><font face="Verdana" size="1" color="blue"><span style="font-size:8pt"><u>worldline.jobs.de</u></span></font></a></div>
<div><a href="http://www.facebook.com/WorldlineKarriere" target="_blank"><font face="Verdana" size="1" color="blue"><span style="font-size:8pt"><u>facebook.com/WorldlineKarriere</u></span></font></a></div>
<div><img><font size="2"><span style="font-size:9pt"> </span></font></div>
<div> </div>
<div> </div>
<div><font face="Arial" size="2"><span style="font-size:9pt">Worldline GmbH<br>
Geschäftsführer: Wolf Kunisch<br>
Aufsichtsratsvorsitzender: Christophe Duquenne<br>
Sitz der Gesellschaft: Frankfurt/Main<br>
Handelsregister: Frankfurt/Main HRB 40 417<br>
<br>
* * * * * * * * L E G A L D I S C L A I M E R * * * * * * * *<br>
This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail by error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the internet,
the Atos group liability cannot be triggered for the message content. Although the sender endeavors to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and shall not be liable for any damages resulting
from any virus transmitted.<br>
* * * * * * * * L E G A L D I S C L A I M E R * * * * * * * *</span></font></div>
<div><font color="#1F497D"> </font></div>
<div> </div>
<div> </div>
<div> </div>
</span></font>
</div>
<br>_______________________________________________<br>
keycloak-user mailing list<br>
<a href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br></blockquote></div><br></div>