Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <001501c6b28b$83db8d80$6f01a8c0@JAN>
From: "Jan Strauch" <waynel@web.de>
To: <users@tomcat.apache.org>
Subject: Databaseaccess speed
Date: Fri, 28 Jul 2006 23:18:51 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0010_01C6B29C.2F9FEC50"
Sender: waynel@web.de

------=_NextPart_000_0010_01C6B29C.2F9FEC50
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello world !!!

I have a greater problem with delays between write and read-access using =
tomcat.

The scenario:

tomcat 5.0.28
mysql  Ver 14.7 Distrib 4.1.10a, for suse-linux (x86_64)

1. a servlet inserts data given by user via browser into the database
2. a second servlet uses these data to create html and sends it to user

The problem is: this only works if there are 30 minutes time between 1. =
and 2.
If i connect to mysql via console, it takes the same 30 mins to access =
and view the data in the DB given in step 1.

- all connections of the servlets are closed after the job
- all variables are freed
- everything else is freed, closed or destroyed

Maybe tomcat or mysql waits for something.=20
Timeout of something ? but what?
The only timeout explicitely given in the configs is for 600 secs for =
sessioninactivity.

Please help me

Thanks wayne

------=_NextPart_000_0010_01C6B29C.2F9FEC50--