I am often unit-testing from IDEA with MySQL or PostgreSQL. This might help with table locks.

You need to set system properties like (see keycloak-server.json):
-Dkeycloak.connectionsJpa.url=jdbc:mysql://localhost/keycloak -Dkeycloak.connectionsJpa.driver=com.mysql.jdbc.Driver -Dkeycloak.connectionsJpa.user=keycloak -Dkeycloak.connectionsJpa.password=keycloak

Also you need to put MySQL dependency to testsuite/integration/pom.xml :

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

or:

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>${postgresql.version}</version>
</dependency>


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
On 19/02/16 16:39, Bill Burke wrote: 
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.