Hi Roman,
the database is on the same machine, that's why I wanted to give type
2 a try.

Downgrading to 1.0.1 is not an option as it exhibited *very* weird
behaviour when dealing with commits.
I hope I am not starting a flame war here, but the problem with 1.0.1
is that my data was not persisted to the db even after a commit!
This, of course is a major annoyance if not a show-stopper!
The same happened for interclient.

But the question is: How do I use the type 2 driver? Can somebody
answer this question?

After that I am willing to help you figure out my problems with the
Driver being SLOOOOOOOOOW.

Thanks again fot your help I really appreciate it,
Umberto

--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> 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