LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   32bit vs 64 bit (https://www.linuxquestions.org/questions/linux-newbie-8/32bit-vs-64-bit-4175542540/)

jobart08 05-13-2015 08:55 PM

32bit vs 64 bit
 
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!

jefro 05-13-2015 08:58 PM

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

jobart08 05-13-2015 09:47 PM

Quote:

Originally Posted by jefro (Post 5362163)

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.

jefro 05-13-2015 10:15 PM

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

jobart08 05-13-2015 10:20 PM

Quote:

Originally Posted by jefro (Post 5362189)
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!

jefro 05-14-2015 04:12 PM

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


All times are GMT -5. The time now is 09:44 PM.