[keycloak-user] Problem with Oracle sql

[Meissa M'baye Sakho]

Mike,
Can you validate your datasource connexion by running the command-cli below
after starting the CLI:

1) first you start the CLi by running the command below from you
/Keycloak_Home/bin
./jboss-cli.sh --connect

2)you run the command below to validate that you datasource configuration
is ok. It will request a valid connection to the database
/subsystem=datasources/data-source=KeycloakDS:test-connection-in-pool

Meissa


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