Subject Re: [Firebird-Java] Firebird + Tomcat + Localhost
Author Rick Fincher
Hi Marco,

You may want to try to ping localhost and see if there is a delay in
your system setup.

I'm using a similar setup on Redhat 9 and I don't see this. The Tomcat
release notes have a entry:

GLIBC 2.2 / Linux 2.4 users should define an environment variable:
export LD_ASSUME_KERNEL=2.2.5

Redhat Linux 9.0 users should use the following setting to avoid
stability problems:
export LD_ASSUME_KERNEL=2.4.1

You may need to set something like that but I don't know anything about
Conectiva or Gentoo Linux, so I can't say for sure.

What version of Tomcat and Jaybird are you using?

Rick



Marco Lovato wrote:

>Hi all,
>
>I am in trouble.
>I developed an application in Java to run under Windows.
>Worked ok, but we changed it to Linux (in that case, Conectiva Linux).
>And then firebird simply got extremely slow on same application.
>
>So I tested on my notebook. I have WinXP (the app worked properly).
>But when turning to Gentoo, same thing has ocurred... superslowmotion.
>The app makes the query, and hangs for 10-15 secs (with CPU 0.5%).
>
>Does anybody have a clue? What kind of tune has to be made?
>
>This happens ONLY at this circustance:
>
>- Linux
>- Firebird
>- Tomcat using jdbc
>- Connection to LOCALHOST
>
>If the database is on another machine, or someone else (a tomcat on
>other machine), everything goes fine.
>
>Code:
>mcfly lib # cat /etc/hosts
>127.0.0.1 mcfly localhost mcfly
>
>Code:
>mcfly lib # cat /etc/hostname
>mcfly
>
>The poor performance:
>
>
>[13:16:37] DEBUG
>com.aero.mb.report.NewReportExtractionAction:841
>#files = 46
>[13:16:58] DEBUG
>com.aero.mb.report.NewReportExtractionAction:899
>Processing File: #1
>
>
>Can you see the superdelay? 21 secs? Normally it is less than 1 sec.
>And if I use another database (another machine) this do not happen.
>And also if someone uses only my database.
>
>Thanks
>
>Marco
>
>
>
>