[keycloak-user] Problem with Oracle sql

[Stian Thorgersen]

We can't support offline generation of the SQL scripts for migration as we
rely on migrating some data, not just DB schema.

On 19 October 2017 at 15:47, Hynek Mlnarik <hmlnarik at redhat.com> wrote:

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