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.