[keycloak-user] Problem with Oracle sql
mzmien
mzmien at onet.pl
Wed Oct 18 18:21:14 EDT 2017
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
More information about the keycloak-user
mailing list