Re: [keycloak-user] Problem with Oracle sql
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(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user