<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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.<br>
<br>
<br>
Caused by: org.postgresql.util.PSQLException: ERROR: operator does
not exist: integer = character varying<br>
Hint: No operator matches the given name and argument type(s). You
might need to add explicit type casts.<br>
Position: 78<br>
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)<br>
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)<br>
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187)<br>
... 39 more<br>
<br>
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? <br>
<br>
Could it be because I didn't finish the 2 additional steps of <b>Setting
up SSL/HTTPS</b> and <b>Enforcing HTTPS connections</b> before
attempting to deploy, is there a problem with the JPA integration
with Postgres?<br>
<br>
Find attached the server.log file generated when i first attempted
it with postgres 9.3 and then with 9.2.<br>
<br>
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.<br>
<br>
<br>
<br /><br />
<hr style='border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;' />
<table style='border-collapse:collapse;border:none;'>
<tr>
<td style='border:none;padding:0px 15px 0px 8px'>
<a href="http://www.avast.com/">
<img border=0 src="http://static.avast.com/emails/avast-mail-stamp.png" />
</a>
</td>
<td>
<p style='color:#3d4d5a; font-family:"Calibri","Verdana","Arial","Helvetica"; font-size:12pt;'>
This email is free from viruses and malware because <a href="http://www.avast.com/">avast! Antivirus</a> protection is active.
</p>
</td>
</tr>
</table>
<br />
</body>
</html>