8:47 a.m.
No, you need to have connection open so that Liquibase that generates the
script can check current database dialect. Keycloak does not support
Liquibase offline mode [1] at the moment. If that is needed, feel free to
create JIRA and describe your usecase.
[1] http://www.liquibase.org/2015/07/without-a-connection.html
On Thu, Oct 19, 2017 at 12:21 AM, mzmien <mzmien(a)onet.pl> wrote:
Hi All!
I'm trying to "generate" raw sql file for the latest keycloak 3.3.0.CR2,
but without connection to the database (Oracle). Is't possible?
Every time, I'm trying to start standalone.sh I'm getting an error:
caused by: java.net.ConnectException: Connection refused
My standalone.xml
<cut>
<datasource jndi-name="java:jboss/datasources/KeycloakDS"
pool-name="KeycloakDS" enabled="true" jta="true"
use-java-context="true">
<connection-url>
jdbc:oracle:thin:@127.0.0.1:1521:ORCLCDB
</connection-url>
<driver>
oracle
</driver>
<security>
<user-name>username</user-name>
<password>password</password>
</security>
<new-connection-sql>select * from dual</new-connection-sql>
</datasource>
</cut>
In drivers section:
<cut>
<driver name="oracle"
module="com.oracle.db">
<xa-datasource-class>oracle.
jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
</cut>
and strategy options:
<cut>
<properties>
<property name="dataSource"
value="java:jboss/datasources/KeycloakDS"/>
<property name="initializeEmpty"
value="false"/>
<property name="migrationStrategy"
value="manual"/>
<property name="migrationExport"
value="${jboss.home.dir}/keycloak-database-update.sql"/>
</properties>
</cut>
I'm expecting keycloak-database-updata.sql file...
Thanks!
Regards,
Mike
_______________________________________________
keycloak-user mailing list
keycloak-user(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user
--
--Hynek