[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