<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Hey Marek,</div><div class=""><br class=""></div><div class="">I am using MySQL 5.6.23 with JDBC driver version 5.1.33.</div><div class=""><br class=""></div><div class="">Darcy</div><div class=""><br class=""></div><br class=""><div><blockquote type="cite" class=""><div class="">On Feb 29, 2016, at 2:16 AM, Marek Posolda <<a href="mailto:mposolda@redhat.com" class="">mposolda@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">Which JDBC driver and DB version are
you using? Just found this thread during googling:
<a class="moz-txt-link-freetext" href="http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog">http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog</a>
. Wonder if it can be related to your issue...<br class="">
<br class="">
I am testing MySQL with JDBC driver version 5.1.29 and never saw
the issue like this.<br class="">
<br class="">
Marek<br class="">
<br class="">
On 28/02/16 06:00, Darcy Welsh wrote:<br class="">
</div>
<blockquote cite="mid:E074F712-1D84-48CA-AB9A-A6B16441D699@yahoo.com" type="cite" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class="">
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class="">Hi,</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class=""><br class="">
</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class="">I successfully upgraded from 1.7.0
to 1.8.0, however, seeing the following error when attempting to
upgrade from 1.8.0 to either 1.8.1 or 1.9.0:</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class=""><br class="">
</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class=""><span style="color: rgb(195, 55,
32);" class="">22:45:48,803 ERROR
[org.keycloak.services.resources.KeycloakApplication]
(ServerService Thread Pool -- 51) Failed to migrate datamodel:
java.lang.RuntimeException: Failed to update database</span></div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:153)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:42)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:30)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:103)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:103)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.models.cache.infinispan.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:61)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.models.cache.infinispan.DefaultCacheRealmProvider.getMigrationModel(DefaultCacheRealmProvider.java:43)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:21)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:139)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:82)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
java.lang.reflect.Constructor.newInstance(Constructor.java:408)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
java.util.concurrent.FutureTask.run(FutureTask.java:266)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
java.lang.Thread.run(Thread.java:745)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.threads.JBossThread.run(JBossThread.java:320)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class="">Caused
by: liquibase.exception.DatabaseException: Incorrect database
name '' [Failed SQL: CREATE TABLE ``.DATABASECHANGELOG (ID
VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME
VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL,
ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL,
MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS
VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20)
NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL)]</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:112)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:214)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1074)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1136)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1126)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1122)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:63)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>...
36 more</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class="">Caused
by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Incorrect database name ''</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
java.lang.reflect.Constructor.newInstance(Constructor.java:408)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.Util.handleNewInstance(Util.java:377)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.Util.getInstance(Util.java:360)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo; color: rgb(195, 55, 32);" class=""><span class="Apple-tab-span" style="white-space:pre"> </span>...
45 more</div>
<div class=""><br class="">
</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class="">Any ideas as to the potential
cause/resolution? </div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class=""><br class="">
</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class="">The MySQL datasource is configured
as follows:</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class=""><br class="">
</div>
<div style="margin: 0px; line-height: normal;" class="">
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> <datasource jta="true"
jndi-name="java:jboss/datasources/KeycloakDS"
pool-name="KeycloakDS" enabled="true"
use-java-context="true"></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<connection-url>jdbc:mysql://localhost:3306/keycloak</connection-url></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> <connection-property
name="defaultFetchSize"></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> 1000</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </connection-property></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<driver>mysql</driver></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> <pool></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<max-pool-size>20</max-pool-size></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </pool></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> <security></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<user-name>keycloak</user-name></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<password>keycloakrocks!</password></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </security></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> <timeout></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<set-tx-query-timeout>true</set-tx-query-timeout></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </timeout></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> <statement></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<prepared-statement-cache-size>100</prepared-statement-cache-size></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<share-prepared-statements>true</share-prepared-statements></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </statement></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </datasource></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><span style="font-size: 11px; font-family: Menlo;" class="">
<drivers></span></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> <driver name="mysql"
module="com.mysql.jdbc"></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlDataSource</datasource-class></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </driver></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> .</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> .</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> .</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class=""> </drivers></span></font></div>
<div style="font-family: Menlo; font-size: 11px;" class=""><br class="">
</div>
<div style="font-family: Menlo; font-size: 11px;" class=""><br class="">
</div>
<div style="font-family: Menlo; font-size: 11px;" class=""><br class="">
</div>
<div style="font-family: Menlo; font-size: 11px;" class="">Any
help would be much appreciated.</div>
<div style="font-family: Menlo; font-size: 11px;" class=""><br class="">
</div>
<div style="font-family: Menlo; font-size: 11px;" class="">Thank-you
in advance,</div>
<div style="font-family: Menlo; font-size: 11px;" class="">Darcy
Welsh</div>
</div>
<div style="margin: 0px; font-size: 11px; line-height: normal;
font-family: Menlo;" class=""><br class="">
</div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre wrap="" class="">_______________________________________________
keycloak-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br class="">
</div>
</div></blockquote></div><br class=""></body></html>