[keycloak-user] Problem with Oracle sql

[Hynek Mlnarik]

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 at 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user




-- 

--Hynek