Red Hat Single Sign-On (RH SSO) fails to connect to a PostgreSQL Schema that contains dashes '-' in its name
문제
There is a liquibase managed connection error in RH SSO when using a schema containing an - character such as rh-sso:
FATAL [com.arjuna.ats.arjuna] (MSC service thread 1-8) ARJUNA012260: Received exception for com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DataSourceJDBCAccess:oskeycloak0JBossTSTxTable: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
Position: 14
at org.postgresql@42.2.14//org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
...
at org.jboss.threads@2.4.0.Final-redhat-00001//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
at java.base/java.lang.Thread.run(Thread.java:829)
환경
- Red Hat Single Sign-On (RH SSO)
- 7.X
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
