LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 05-13-2015, 08:55 PM   #1
jobart08
Member
 
Registered: Sep 2014
Posts: 68

Rep: Reputation: Disabled
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!

Last edited by jobart08; 05-13-2015 at 09:39 PM.
 
Old 05-13-2015, 08:58 PM   #2
jefro
Moderator
 
Registered: Mar 2008
Posts: 15,672

Rep: Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260
Maybe? http://stackoverflow.com/questions/1...g-postgres-8-2
 
Old 05-13-2015, 09:47 PM   #3
jobart08
Member
 
Registered: Sep 2014
Posts: 68

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by jefro View Post
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.
 
Old 05-13-2015, 10:15 PM   #4
jefro
Moderator
 
Registered: Mar 2008
Posts: 15,672

Rep: Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260Reputation: 2260
I was thinking the applications are causing this not the sql.
 
Old 05-13-2015, 10:20 PM   #5
jobart08
Member
 
Registered: Sep 2014
Posts: 68

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by jefro View Post
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!
 
Old 05-14-2015, 04:12 PM   #6
jefro
Moderator
 
Registered: Mar 2008
Posts: 15,672

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


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
64 bit or 32bit?? Pedroski Linux - Hardware 5 09-18-2011 01:46 PM
Is it 32bit or 64 bit? garyg007 Debian 3 03-29-2009 10:57 PM
32bit or 64 bit question mokku Linux - Newbie 2 10-26-2007 03:50 PM
64 bit cpu, 32bit kernel? cougyr Debian 7 10-03-2006 01:55 PM
Can I install 9.2-32bit on a 64 bit system? Riddick SUSE / openSUSE 5 11-21-2004 07:12 PM


All times are GMT -5. The time now is 02:36 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration