Hi Umberto,

> I am runnign tomcat 4.1.27 on a HP netserver 800 with 1.3GB of RAM
> with SUSE Linux 8.0 and j2sdk 1.4.x. The vary same web now has been
> ported to oracle and the performance gap I see is unsettling!
>
> I use JSP with JSTL 1.0.4 grabbed from jakarta.apache.org.
> The db is on another Netserver, running the same linux on a 100MB
> fully switched lan.

Database is on another machine?

> IBCONSOLE or Interclient do not show this behavior and are
> reasonably fast. Only transactions appear not to commit consistently
> and THAT is a problem :-) !

I'm afraid type 2 driver will not help you in this case. JayBird and
client library implement the same protocol and I believe that protocol
is a bottleneck (there's too heavy message exchange between server and
client).

Type 2 driver can help you if database server would run on the same
machine, in this case it should be possible to use IPC instead of
sockets. But today I got a bug report that IPC does not work.

Also beta 1 contained a bug that could cause your slowdown. Either use
current CVS version, or downgrade to JayBird 1.0.1.

Hope this helps.

Roman Rokytskyy