<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">I am often unit-testing from IDEA with
MySQL or PostgreSQL. This might help with table locks.<br>
<br>
You need to set system properties like (see keycloak-server.json):<br>
-Dkeycloak.connectionsJpa.url=jdbc:mysql://localhost/keycloak
-Dkeycloak.connectionsJpa.driver=com.mysql.jdbc.Driver
-Dkeycloak.connectionsJpa.user=keycloak
-Dkeycloak.connectionsJpa.password=keycloak<br>
<br>
Also you need to put MySQL dependency to
testsuite/integration/pom.xml :<br>
<br>
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
<pre style="background-color:#ffffff;color:#000000;font-family:'DejaVu Sans Mono';font-size:9.0pt;"><span style="background-color:#efefef;"><</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">dependency</span><span style="background-color:#efefef;">></span>
<span style="background-color:#efefef;"><</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">groupId</span><span style="background-color:#efefef;">></span>mysql<span style="background-color:#efefef;"></</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">groupId</span><span style="background-color:#efefef;">></span>
<span style="background-color:#efefef;"><</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">artifactId</span><span style="background-color:#efefef;">></span>mysql-connector-java<span style="background-color:#efefef;"></</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">artifactId</span><span style="background-color:#efefef;">></span>
<span style="background-color:#efefef;"></</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">dependency</span><span style="background-color:#efefef;">>
or:
</span><meta http-equiv="content-type" content="text/html; charset=windows-1252"><span style="background-color:#efefef;"><</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">dependency</span><span style="background-color:#efefef;">></span>
<span style="background-color:#efefef;"><</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">groupId</span><span style="background-color:#efefef;">></span>org.postgresql<span style="background-color:#efefef;"></</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">groupId</span><span style="background-color:#efefef;">></span>
<span style="background-color:#efefef;"><</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">artifactId</span><span style="background-color:#efefef;">></span>postgresql<span style="background-color:#efefef;"></</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">artifactId</span><span style="background-color:#efefef;">></span>
<span style="background-color:#efefef;"><</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">version</span><span style="background-color:#efefef;">></span>${postgresql.version}<span style="background-color:#efefef;"></</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">version</span><span style="background-color:#efefef;">></span>
<span style="background-color:#efefef;"></</span><span style="color:#000080;background-color:#efefef;font-weight:bold;">dependency</span><span style="background-color:#efefef;">>
This is not needed if you start test from command line with maven, as maven will use the "mysql" or "postgresql" profile and will use dependency by default.
Marek
</span></pre>
On 19/02/16 16:39, Bill Burke wrote:
</div><blockquote cite="mid:56C73720.1000907@redhat.com" type="cite"><pre wrap="">FYI, I don't think I can really fix, but I tried a concurrency test that
creates, fetches, and then deletes a client in multiple concurrent
threads. HSQL is giving me deadlock exceptions. Looks like it is
trying to obtain table locks. Sucks as I can't really unit test this
scenario.
</pre>
</blockquote>
</body></html>