<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hello Richard,</p>
    <p>it looks like it is not so easy as I originally thought.</p>
    <p>It would most probably require some development effort - or at
      least some non-trivial Tomcat/Spring Boot knowledge (that I
      personally do not have).</p>
    <p>If no one from the community is able to help you with this, you
      can create a JIRA (of "Improvement" kind).</p>
    <p>Under a subscription we'll be glad to devote developers' time to
      it.</p>
    <p>Best regards,<br>
    </p>
    <pre class="moz-signature" cols="72">Pavol Mederly
Software developer
evolveum.com
</pre>
    <div class="moz-cite-prefix">On 14/05/2020 22:54, Richard Frovarp
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:fb733ad13e837ebef8248d328e81791f416ad4dc.camel@ndsu.edu">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
      <style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Ubuntu;
        panose-1:2 11 5 4 3 6 2 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
code
        {mso-style-priority:99;
        font-family:"Courier New";}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
span.DefaultFontHxMailStyle
        {mso-style-name:"Default Font HxMail Style";
        font-family:"Ubuntu",sans-serif;
        color:windowtext;
        font-weight:normal;
        font-style:normal;
        text-decoration:none none;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:"Courier New";}
p.xmsonormal, li.xmsonormal, div.xmsonormal
        {mso-style-name:x_msonormal;
        margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style>
      <div>I've spent some time wildly trying to guess as to how to make
        this work.</div>
      <div><br>
      </div>
      <div>First, with midPoint 4.0.2, Configuration example 1 is wrong:</div>
      <div><br>
      </div>
      <div><a
href="https://wiki.evolveum.com/display/midPoint/Using+MidPoint+with+embedded+Tomcat"
          moz-do-not-send="true">https://wiki.evolveum.com/display/midPoint/Using+MidPoint+with+embedded+Tomcat</a></div>
      <div><br>
      </div>
      <div><br>
      </div>
      <div>midpoint.log:2020-05-14 12:49:00,550 [] [main] WARN
(org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext):
        Exception encountered during context initialization - cancelling
        refresh attempt:
        org.springframework.context.ApplicationContextException: Unable
        to start web server; nested exception is
        org.springframework.beans.factory.BeanCreationException: Error
        creating bean with name 'tomcatEmbeddedServletContainerFactory'
        defined in class path resource
[com/evolveum/midpoint/web/boot/EmbeddedTomcatAutoConfiguration$EmbeddedTomcat.class]:
        Initialization of bean failed; nested exception is
        org.springframework.beans.factory.UnsatisfiedDependencyException:
        Error creating bean with name
'com.evolveum.midpoint.web.boot.MidPointSpringApplication$ServerCustomization':
        Unsatisfied dependency expressed through field 'sessionTimeout';
        nested exception is
        org.springframework.beans.TypeMismatchException: Failed to
        convert value of type 'java.lang.String' to required type 'int';
        nested exception is java.lang.NumberFormatException: For input
        string: "120m"</div>
      <div><br>
      </div>
      <div>If I drop the 'm' off of the entry, it doesn't throw an
        error. No idea if it is working at this point. Going to guess
        that example 2 is also wrong.
      </div>
      <div><br>
      </div>
      <div>I've moved off of trying to use the datasource for the main
        DB connection. I am quite interested in using it for connectors.
        In particular the DatabaseTableConnector</div>
      <div><br>
      </div>
      <div>I've tried this:</div>
      <div><br>
      </div>
      <div>warehouse.datasource.url: jdbc:mysql://localhost/warehouse</div>
      <div>warehouse.datasource.username: midpoint</div>
      <div>warehouse.datasource.password: <password></div>
      <div>warehouse.datasource.driver-class-name: com.mysql.jdbc.Driver</div>
      <div>warehouse.datasource.name: jdbc/warehouse                   </div>
      <div>warehouse.datasource.type: javax.sql.DataSource</div>
      <div><br>
      </div>
      <div>Then I get the following as an error:</div>
      <div><br>
      </div>
      <div><span style="color: rgb(51, 51, 51); font-family:
          "Source Sans Pro", "Helvetica Neue",
          Helvetica, Arial, sans-serif; font-size: 14px;
          font-variant-ligatures: normal; orphans: 2; white-space:
          normal; widows: 2;">org.identityconnectors.framework.common.exceptions.ConnectorException(javax.naming.NoInitialContextException:
          Need to specify class name in environment or system property,
          or as an applet parameter, or in an application resource file:
java.naming.factory.initial)->javax.naming.NoInitialContextException(Need
          to specify class name in environment or system property, or as
          an applet parameter, or in an application resource file:
          java.naming.factory.initial)</span></div>
      <div><span style="color: rgb(51, 51, 51); font-family:
          "Source Sans Pro", "Helvetica Neue",
          Helvetica, Arial, sans-serif; font-size: 14px;
          font-variant-ligatures: normal; orphans: 2; white-space:
          normal; widows: 2;"><br>
        </span></div>
      <div><span style="color: rgb(51, 51, 51); font-family:
          "Source Sans Pro", "Helvetica Neue",
          Helvetica, Arial, sans-serif; font-size: 14px;
          font-variant-ligatures: normal; orphans: 2; white-space:
          normal; widows: 2;">This says you need to do a change in
          embedded Tomcat, but the main application is already using a
          datasource, so I'm not sure. I am quite familiar with setting
          up JNDI via context files, however no experience with Spring
          Boot.</span></div>
      <div><span style="color: rgb(51, 51, 51); font-family:
          "Source Sans Pro", "Helvetica Neue",
          Helvetica, Arial, sans-serif; font-size: 14px;
          font-variant-ligatures: normal; orphans: 2; white-space:
          normal; widows: 2;"><a
href="https://stackoverflow.com/questions/24941829/how-to-create-jndi-context-in-spring-boot-with-embedded-tomcat-container"
            moz-do-not-send="true">https://stackoverflow.com/questions/24941829/how-to-create-jndi-context-in-spring-boot-with-embedded-tomcat-container</a></span></div>
      <div><span style="color: rgb(51, 51, 51); font-family:
          "Source Sans Pro", "Helvetica Neue",
          Helvetica, Arial, sans-serif; font-size: 14px;
          font-variant-ligatures: normal; orphans: 2; white-space:
          normal; widows: 2;"><br>
        </span></div>
      <div><span style="color: rgb(51, 51, 51); font-family:
          "Source Sans Pro", "Helvetica Neue",
          Helvetica, Arial, sans-serif; font-size: 14px;
          font-variant-ligatures: normal; orphans: 2; white-space:
          normal; widows: 2;"><br>
        </span></div>
      <div>On Thu, 2020-05-14 at 11:53 -0500, Jason Everling wrote:</div>
      <blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px
        #729fcf solid;padding-left:1ex">
        <div class="WordSection1">
          <p class="MsoNormal"><span class="DefaultFontHxMailStyle">Maybe
            </span><a
              href="https://howtodoinjava.com/spring-boot2/datasource-configuration/"
              moz-do-not-send="true">https://howtodoinjava.com/spring-boot2/datasource-configuration/</a><span
              class="DefaultFontHxMailStyle"><o:p></o:p></span></p>
          <p class="MsoNormal"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
          <div
            style="mso-element:para-border-div;border:none;border-top:solid
            #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
            <p class="MsoNormal" style="border:none;padding:0in"><b>From:
              </b><a href="mailto:hazelton@internet2.edu"
                moz-do-not-send="true">Keith Hazelton</a><br>
              <b>Sent: </b>Thursday, May 14, 2020 11:28 AM<br>
              <b>To: </b><a href="mailto:midpoint@lists.evolveum.com"
                moz-do-not-send="true">midPoint General Discussion</a><br>
              <b>Subject: </b>Re: [midPoint] Where does one configure
              datasources in midPoint 4.0.2?</p>
          </div>
          <p class="MsoNormal"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">This email is a
                followup on how we could potentially improve
                documentation on datasource configuration for embedded
                Tomcat versions of midPoint.
                <o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">First, note that
                the Evolveum documentation on "Using midPoint with
                Embedded Tomcat",  includes the following under
                "Configuration"
                <a
href="https://wiki.evolveum.com/display/midPoint/Using+MidPoint+with+embedded+Tomcat"
                  moz-do-not-send="true">
https://wiki.evolveum.com/display/midPoint/Using+MidPoint+with+embedded+Tomcat</a>,"<o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">"MidPoint
                configuration is done as usual in config.xml file
                located in </span><code><span
                  style="font-size:10.0pt;color:black">midpoint.home</span></code><span
                style="font-size:12.0pt;color:black">.
                <u>Configuration for embedded tomcat can be done in two
                  places. Default configuration file name </u></span><code><u><span
                    style="font-size:10.0pt;color:black">application.yml</span></u></code><u><span
                  style="font-size:12.0pt;color:black"> is located on
                  classpath (admin-gui/src/main/resources folder).
                  Custom configuration file </span></u><code><u><span
                    style="font-size:10.0pt;color:black">application.yml</span></u></code><u><span
                  style="font-size:12.0pt;color:black"> can be placed
                  to </span></u><code><u><span
                    style="font-size:10.0pt;color:black">midpoint.home</span></u></code><u><span
                  style="font-size:12.0pt;color:black"> folder</span></u><span
                style="font-size:12.0pt;color:black">. <o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">...<o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">"Following table
                shows list of available properties that can be used to
                configure tomcat (e.g. http/https ports, session
                timeouts, logging, max-post-size, etc.)."<o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">The mentioned table
                does
                <u>not</u> mention datasource in its example of
                "available properties":<o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">It looks like the
                datasource settings in question are discussed
                <u>only</u> in Spring documentation on "Common
                Application properties", <a
href="https://docs.spring.io/spring-boot/docs/current/reference/html/appendix-application-properties.html"
                  moz-do-not-send="true">
https://docs.spring.io/spring-boot/docs/current/reference/html/appendix-application-properties.html</a><o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">That site includes
                page after page of datasource settings, under the "Data
                Properties" section.
                <o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">QUESTION: Do we
                know which of these properties need to be set, and to
                what values, to solve the problem under discussion? If
                we do, that could be the basis for improved
                documentation.<o:p></o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
          </div>
          <div>
            <p class="MsoNormal"><span
                style="font-size:12.0pt;color:black">           --Keith<o:p></o:p></span></p>
          </div>
          <p class="MsoNormal"><img
              style="width:7.2291in;height:.0208in"
              id="Horizontal_x0020_Line_x0020_1"
              src="cid:part8.04437A79.5043DD5F@evolveum.com"
              data-inline=""
              data-name="CD1BBBF4D29A4AC384AF6E721AFBE93C.png" class=""
              width="694" height="2" border="0"><o:p></o:p></p>
          <div id="divRplyFwdMsg">
            <p class="MsoNormal"><b><span style="color:black">From:</span></b><span
                style="color:black"> midPoint
                <a class="moz-txt-link-rfc2396E" href="mailto:midpoint-bounces@lists.evolveum.com"><midpoint-bounces@lists.evolveum.com></a> on behalf of
                Petr Gašparík - AMI Praha a.s.
                <a class="moz-txt-link-rfc2396E" href="mailto:petr.gasparik@ami.cz"><petr.gasparik@ami.cz></a><br>
                <b>Sent:</b> Thursday, May 14, 2020 4:15 AM<br>
                <b>To:</b> midPoint General Discussion
                <a class="moz-txt-link-rfc2396E" href="mailto:midpoint@lists.evolveum.com"><midpoint@lists.evolveum.com></a><br>
                <b>Subject:</b> Re: [midPoint] Where does one configure
                datasources in midPoint 4.0.2?</span>
              <o:p></o:p></p>
            <div>
              <p class="MsoNormal"> <o:p></o:p></p>
            </div>
          </div>
          <div>
            <div>
              <p class="MsoNormal">This should be definitely better
                documented, as embedded Tomcat is recommended, and in
                the near future the only one supported option.<br
                  clear="all">
                <o:p></o:p></p>
              <div>
                <div>
                  <div>
                    <div>
                      <div>
                        <div>
                          <div>
                            <div>
                              <div>
                                <div>
                                  <div>
                                    <div>
                                      <div>
                                        <div>
                                          <p><span
                                              style="font-size:10.0pt;font-family:"Arial",sans-serif">--</span></p>
                                          <p><span
                                              style="font-size:10.0pt;font-family:"Arial",sans-serif">s
                                              pozdravem</span></p>
                                          <div>
                                            <p><strong><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Petr
                                                  Gašparík</span></strong><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><br>
                                              </span><span
style="font-size:8.5pt;font-family:"Arial",sans-serif;color:gray">konzultant
                                                IT bezpečnosti</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><o:p></o:p></span></p>
                                          </div>
                                          <p><span
style="font-size:8.5pt;font-family:"Arial",sans-serif;color:black">gsm:
                                              [+420] 603 523 860<br>
                                              e‑mail: <a
                                                href="mailto:petr.gasparik@ami.cz"
                                                target="_blank"
                                                moz-do-not-send="true">petr.gasparik@ami.cz</a><o:p></o:p></span></p>
                                          <p><strong><span
style="font-size:8.5pt;font-family:"Arial",sans-serif;color:black">AMI
                                                Praha a.s.</span></strong><span
style="font-size:8.5pt;font-family:"Arial",sans-serif;color:black"><br>
                                              Pláničkova 11, 162 00
                                              Praha 6<o:p></o:p></span></p>
                                          <p><span
style="font-size:8.5pt;font-family:"Arial",sans-serif;color:black">tel.:
                                              [+420] 274 783 239 | web: <a
href="https://www.ami.cz" target="_blank" moz-do-not-send="true">www.ami.cz</a><o:p></o:p></span></p>
                                          <p style="margin-top:15.0pt"><span
style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black"><img
                                                id="_x0000_i1025"
                                                src="http://www.ami.cz/images/podpis/ami_logo.gif"
                                                alt="AMI Praha a.s."
                                                moz-do-not-send="true"
                                                border="0"></span><span
style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
                                          <p><span
style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#AAAAAA">Textem
                                              tohoto e‑mailu
                                              podepisující neslibuje
                                              uzavřít ani neuzavírá
                                              za společnost AMI Praha
                                              a.s.<br>
                                              jakoukoliv smlouvu. Každá
                                              smlouva, pokud bude
                                              uzavřena, musí mít
                                              výhradně písemnou formu.<br>
                                            </span><span
style="font-size:4.5pt;font-family:"Arial",sans-serif;color:#AAAAAA"> </span><span
style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#AAAAAA"><br>
                                              Tento e‑mail je určen
                                              výhradně pro potřeby
                                              jeho adresáta/ů a může
                                              obsahovat důvěrné
                                              nebo osobní<br>
                                              informace. Nejste‑li
                                              zamýšleným příjemcem,
                                              je zakázáno jakékoliv
                                              zveřejňování,
                                              zprostředkování<br>
                                              nebo jiné použití těchto
                                              informací. Pokud jste
                                              obdrželi e‑mail
                                              neoprávněně, informujte
                                              o tom prosím<br>
                                              odesílatele a vymažte
                                              neprodleně všechny kopie
                                              tohoto e‑mailu včetně
                                              všech jeho příloh.
                                              Nakládáním<br>
                                              s neoprávněně získanými
                                              informacemi se vystavujete
                                              riziku právního postihu.<o:p></o:p></span></p>
                                        </div>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
              <p class="MsoNormal"><o:p> </o:p></p>
            </div>
            <p class="MsoNormal"><o:p> </o:p></p>
            <div>
              <div>
                <p class="MsoNormal">čt 14. 5. 2020 v 11:02 odesílatel
                  Pavol Mederly <<a
                    href="mailto:mederly@evolveum.com"
                    moz-do-not-send="true">mederly@evolveum.com</a>>
                  napsal:<o:p></o:p></p>
              </div>
              <blockquote type="cite" style="margin:0 0 0 .8ex;
                border-left:2px #729fcf solid;padding-left:1ex">
                <div>
                  <p>Richard,</p>
                  <p>I believe that even for embedded Tomcat (used when
                    running in standalone mode) you can configure data
                    sources, probably by setting up things in
                    application.yml file.</p>
                  <p>Best regards,<o:p></o:p></p>
                  <pre>Pavol Mederly</pre>
                  <pre>Software developer</pre>
                  <pre><a href="http://evolveum.com" target="_blank" moz-do-not-send="true">evolveum.com</a></pre>
                  <div>
                    <p class="MsoNormal">On 13/05/2020 19:22, Jason
                      Everling wrote:<o:p></o:p></p>
                  </div>
                  <blockquote type="cite" style="margin:0 0 0 .8ex;
                    border-left:2px #729fcf solid;padding-left:1ex">
                    <div>
                      <p class="xmsonormal">Yeah that was kind of what I
                        meant by container, I believe its using Tomcat
                        as the backend, or Jetty? In any case, you
                        should still be able to create them, we don’t
                        use that method so someone else would have to
                        chime in on configuring them.</p>
                      <p class="xmsonormal"> </p>
                      <div style="border:none;border-top:solid #E1E1E1
                        1.0pt;padding:3.0pt 0in 0in 0in">
                        <p class="xmsonormal"><b>From: </b><a
                            href="mailto:richard.frovarp@ndsu.edu"
                            target="_blank" moz-do-not-send="true">Richard
                            Frovarp</a><br>
                          <b>Sent: </b>Tuesday, May 12, 2020 12:07 PM<br>
                          <b>To: </b><a
                            href="mailto:midpoint@lists.evolveum.com"
                            target="_blank" moz-do-not-send="true">midpoint@lists.evolveum.com</a><br>
                          <b>Subject: </b>Re: [midPoint] Where does one
                          configure datasources in midPoint 4.0.2?</p>
                      </div>
                      <p class="xmsonormal"> </p>
                      <p class="xmsonormal">Not running in a container.
                        Just did the download and run using the</p>
                      <p class="xmsonormal">start.sh script in the
                        tarball.</p>
                      <p class="xmsonormal"> </p>
                      <p class="xmsonormal">On Tue, 2020-05-12 at 11:51
                        -0500, Jason Everling wrote:</p>
                      <p class="xmsonormal">> Are you running
                        container? I thought there was settings for them
                        if</p>
                      <p class="xmsonormal">> using container, maybe
                        someone here has examples for containers. We</p>
                      <p class="xmsonormal">> still use tomcat with
                        global datasources so I cant speak to</p>
                      <p class="xmsonormal">> container’d deployment</p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">> From: Richard Frovarp</p>
                      <p class="xmsonormal">> Sent: Tuesday, May 12,
                        2020 11:18 AM</p>
                      <p class="xmsonormal">> To: <a
                          href="mailto:midpoint@lists.evolveum.com"
                          target="_blank" moz-do-not-send="true">
                          midpoint@lists.evolveum.com</a></p>
                      <p class="xmsonormal">> Subject: Re: [midPoint]
                        Where does one configure datasources in</p>
                      <p class="xmsonormal">> midPoint 4.0.2?</p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">> So unless I'm running
                        this directly through Tomcat I can't do</p>
                      <p class="xmsonormal">> datasource how it comes
                        normally?</p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">> I'm getting these:</p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">> 2020-05-12 11:11:52,084
                        [REPOSITORY] [midPointScheduler_Worker-3]</p>
                      <p class="xmsonormal">> WARN
                        (com.zaxxer.hikari.pool.PoolBase): HikariPool-1
                        - Failed to</p>
                      <p class="xmsonormal">> validate connection
                        com.mysql.jdbc.JDBC4Connection@5bce37af (No</p>
                      <p class="xmsonormal">> operations allowed
                        after connection closed.). Possibly consider
                        using</p>
                      <p class="xmsonormal">> a shorter maxLifetime
                        value.</p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">> Which I don't see a
                        setting on how to address that via config.xml. I</p>
                      <p class="xmsonormal">> know that 4.1
                        deprecates MariaDB and I'll need to change to</p>
                      <p class="xmsonormal">> PostgreSQL. I was kind
                        of hoping to use datasource so that I can skip</p>
                      <p class="xmsonormal">> providing passwords to
                        a lot of resources that will be reading data</p>
                      <p class="xmsonormal">> in from the same DB.</p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">> On Tue, 2020-05-12 at
                        11:04 -0500, Jason Everling wrote:</p>
                      <p class="xmsonormal">> > Those examples are
                        for tomcat native datasource configuration,</p>
                      <p class="xmsonormal">> > standard
                        configuration is done in config.xml in
                        midpoint.home</p>
                      <p class="xmsonormal">> > directory,</p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> >    
                        <repository></p>
                      <p class="xmsonormal">> >      </p>
                      <p class="xmsonormal">> >
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRe</p>
                      <p class="xmsonormal">> >
                        positoryFactory</repositoryServiceFactoryClass></p>
                      <p class="xmsonormal">> >      
                        <database>sqlserver</database></p>
                      <p class="xmsonormal">> >      
                        <jdbcUsername>midpoint</jdbcUsername></p>
                      <p class="xmsonormal">> >      
                        <jdbcPassword>password</jdbcPassword></p>
                      <p class="xmsonormal">> >      </p>
                      <p class="xmsonormal">> >
<jdbcUrl>jdbc:sqlserver://localhost:1433;database=midpoint</jdbcUrl</p>
                      <p class="xmsonormal">> > ></p>
                      <p class="xmsonormal">> >    
                        </repository></p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> > From: Richard
                        Frovarp</p>
                      <p class="xmsonormal">> > Sent: Tuesday, May
                        12, 2020 9:40 AM</p>
                      <p class="xmsonormal">> > To: <a
                          href="mailto:midpoint@lists.evolveum.com"
                          target="_blank" moz-do-not-send="true">
                          midpoint@lists.evolveum.com</a></p>
                      <p class="xmsonormal">> > Subject:
                        [midPoint] Where does one configure datasources
                        in</p>
                      <p class="xmsonormal">> > midPoint 4.0.2?</p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> > I've read the
                        documentation here:</p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> > <a
href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration"
                          target="_blank" moz-do-not-send="true">
https://wiki.evolveum.com/display/midPoint/Repository+Configuration</a></p>
                      <p class="xmsonormal">> > #Rep</p>
                      <p class="xmsonormal">> >
                        ositoryConfiguration-Datasourceconfiguration</p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> > But that doesn't
                        give a current answer. Grepping through
                        everything</p>
                      <p class="xmsonormal">> > looking for the
                        bits I think might exist in files doesn't give
                        me a</p>
                      <p class="xmsonormal">> > result.</p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> > I'm getting a
                        variety of connection problems, likely due to</p>
                      <p class="xmsonormal">> > timeouts,</p>
                      <p class="xmsonormal">> > and it looks like
                        the only way to set those is via a datasource.</p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> > Thanks,</p>
                      <p class="xmsonormal">> > Richard</p>
                      <p class="xmsonormal">> >
                        _______________________________________________</p>
                      <p class="xmsonormal">> > midPoint mailing
                        list</p>
                      <p class="xmsonormal">> > <a
                          href="mailto:midPoint@lists.evolveum.com"
                          target="_blank" moz-do-not-send="true">
                          midPoint@lists.evolveum.com</a></p>
                      <p class="xmsonormal">> > <a
                          href="https://lists.evolveum.com/mailman/listinfo/midpoint"
                          target="_blank" moz-do-not-send="true">
https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
                      <p class="xmsonormal">> >  </p>
                      <p class="xmsonormal">> >
                        _______________________________________________</p>
                      <p class="xmsonormal">> > midPoint mailing
                        list</p>
                      <p class="xmsonormal">> > <a
                          href="mailto:midPoint@lists.evolveum.com"
                          target="_blank" moz-do-not-send="true">
                          midPoint@lists.evolveum.com</a></p>
                      <p class="xmsonormal">> > <a
                          href="https://lists.evolveum.com/mailman/listinfo/midpoint"
                          target="_blank" moz-do-not-send="true">
https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
                      <p class="xmsonormal">> </p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">>  </p>
                      <p class="xmsonormal">>
                        _______________________________________________</p>
                      <p class="xmsonormal">> midPoint mailing list</p>
                      <p class="xmsonormal">> <a
                          href="mailto:midPoint@lists.evolveum.com"
                          target="_blank" moz-do-not-send="true">
                          midPoint@lists.evolveum.com</a></p>
                      <p class="xmsonormal">> <a
                          href="https://lists.evolveum.com/mailman/listinfo/midpoint"
                          target="_blank" moz-do-not-send="true">
https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
                      <p class="xmsonormal">_______________________________________________</p>
                      <p class="xmsonormal">midPoint mailing list</p>
                      <p class="xmsonormal"><a
                          href="mailto:midPoint@lists.evolveum.com"
                          target="_blank" moz-do-not-send="true">midPoint@lists.evolveum.com</a></p>
                      <p class="xmsonormal"><a
                          href="https://lists.evolveum.com/mailman/listinfo/midpoint"
                          target="_blank" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
                      <p class="xmsonormal"> </p>
                    </div>
                    <p class="MsoNormal"><br>
                      <br>
                      <o:p></o:p></p>
                    <pre>_______________________________________________</pre>
                    <pre>midPoint mailing list</pre>
                    <pre><a href="mailto:midPoint@lists.evolveum.com" target="_blank" moz-do-not-send="true">midPoint@lists.evolveum.com</a></pre>
                    <pre><a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a></pre>
                  </blockquote>
                </div>
              </blockquote>
            </div>
          </div>
          <p class="MsoNormal" style="margin-left:4.8pt">_______________________________________________<br>
            midPoint mailing list<br>
            <a href="mailto:midPoint@lists.evolveum.com" target="_blank"
              moz-do-not-send="true">midPoint@lists.evolveum.com</a><br>
            <a
              href="https://lists.evolveum.com/mailman/listinfo/midpoint"
              target="_blank" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></p>
          <p class="MsoNormal"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
        </div>
        <pre>_______________________________________________</pre>
        <pre>midPoint mailing list</pre>
        <pre><a href="mailto:midPoint@lists.evolveum.com" moz-do-not-send="true">midPoint@lists.evolveum.com</a></pre>
        <pre><a href="https://lists.evolveum.com/mailman/listinfo/midpoint" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a></pre>
        <pre>
</pre>
      </blockquote>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
    </blockquote>
  </body>
</html>