[keycloak-user] Problem with Oracle sql
Hynek Mlnarik
hmlnarik at redhat.com
Thu Oct 19 09:47:17 EDT 2017
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
More information about the keycloak-user
mailing list