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.