Keycloak appliance not working with either Postgres 9.2 or 9.3
by Edem Morny
I've attempted to change the datasource within the alpha-1 appliance to
point to my own Postgresql, as encouraged by section 3.3.1 version of
the documentation. However, when I do so and startup the JBoss 7, the
application fails to deploy, with Postgres related errors.
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not
exist: integer = character varying
Hint: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
Position: 78
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187)
... 39 more
When I look at the database, there are 27 tables in the database i
created, so I assume the problem is not with the datasource configuration?
Could it be because I didn't finish the 2 additional steps of *Setting
up SSL/HTTPS* and *Enforcing HTTPS connections* before attempting to
deploy, is there a problem with the JPA integration with Postgres?
Find attached the server.log file generated when i first attempted it
with postgres 9.3 and then with 9.2.
Hoping there's a resolution to this soon, cos I'm really looking forward
to using this instead of JASIG's CAS in 2 upcoming projects.
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
10 years, 2 months
- 2
- 1