Re: Behavior Change
Posted by: walid abdelnour
Date: August 23, 2014 01:30PM

Hi Filipe,

I am sorry but what do u mean by "web client structure" ?
I did not write any client, the user uses his browser to access
the web application deployed on the (Glassfish) server.

Let me just detail the old vs the new server setup :

old server (UNIX) :
-mysql : mysql 5.0.67
-glassfish : 3.1
-Java (JDK/JRE) : 6

new server (red hat):
-mysql : mysql 5.6.16
-glassfish : 4.0
-Java (JDK/JRE) : 7

The web application (Java war file) is deployed on glassfish UNMODIFIED.
This web application does not initiate any http query but just process
the request received from the browser thru a servlet mecanism.
(and communicate with mysql to insert/update/delete relevant info).

The background processes are simple java console applications
using same java jdbc connector as the web application,
namely : mysql-connector-java-5.1.18-bin.jar

As far as i understood, since version 3.0 (or before) Glassfish uses by default HTTP 1.1 with persistent connections.

*** if i run the solution on the new server but configure it to use the old mysql server, it works like a charm.***
*** if i run the solution on the old server but configure it to use the new mysql server, it also hangs.***

This is what lead me to think the change is coming from mysql rather than from another module/framework of the solution, but I am unable to pinpoint it.

To re-iterate my initial question, if process 1 has a live connection to mysql but is not currently issuing any sql commands / traffic, and another
process 2 is trying to exclusively aquire a lock to access 1 table, should process 2 be blocked until process 1 closes the connection (Because this is what is happening with me), or is it configurable ?


Options: ReplyQuote

Written By
July 15, 2014 06:45AM
August 11, 2014 02:24AM
August 14, 2014 11:29AM
August 18, 2014 01:59AM
August 19, 2014 04:09AM
Re: Behavior Change
August 23, 2014 01:30PM
September 01, 2014 11:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.