Good day all. I have 2 servers, 1 dev server running 32bit Debian Lenny with Tomcat8.0.15 and Java 1.8.0_25 and Postgres 8.3.4. The other server UAT is running a 64bit Debian Wheezy with Tomcat8.0.15 and Java 1.8.0_25 and Postgres 8.3.9.

My problem is that, the application deployed in the dev server runs properly, but when deployed on the UAT server, we get an error.

[MRS ERR 2015-05-13 16:03:33] com.bdo.clg.mrs.users.dao.UserDAOERROR: operator does not exist: integer = character varying
org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying

Another difference we noticed is in the logs.
Dev logs shows this

[MRS 2015-04-01 13:51:27] resetXPassDay.sql: UPDATE mrs_usr SET x_pass_day = '0'
WHERE login_name = 'GABS'

notice the ' ' in login_name

UAT shows this

MRS 2015-05-13 16:03:33] resetXPassDay.sql: UPDATE mrs_usr SET x_pass_day = '0' WHERE login_name = ARANTGA

no ' ' in login_name.


We already tried redeploying and reinstalling tomcat and java. Need help in pin pointing the cause of the problem.

Thanks!

Maybe? http://stackoverflow.com/questions/1...g-postgres-8-2

Thanks for the quick reply. I stumbled upon that post early on my research but Im not quite sure if that is the cause. They both are running on postgresql Postgres 8.3.X. Im not sure if the patch version makes any difference, but if it was postgres, why is it working in dev and not in UAT?

Thanks again.

I was thinking the applications are causing this not the sql.

Hi. By application you mean the one deployed in tomcat? Or are you pertaining to tomcat or java?

Thanks!

It is just my guess that some form of access to this setup is causing it rather than the setup.