Tom K asked:
[dbAnywhere woes snipped]
> -Is there other connection connection brokers that are better,
> reliable in production mode and where at? [snip]
I had very similar problems with DataGateway from Borland. Not only was
there instability issues wrt crashing, and leaving open connections
after the client (in our case, an applet) had abnormally disconnected,
but also there was very real scalibility problems. When under anything
more than a trivial load, the process (running on an NT server) would
quickly grow beyond the capacities of a dual PII-350MHZ processor,
386MB RAM, etc, etc server.
I ended up abandoning ISV proxies altogether and going with a
roll-your-own solution with Type 4 vendor supplied drivers (JConnect and
AS400 connection classes), with some apps speaking more-or-less directly
to the database and others going through server side tiers first (but
these are also written using the Type 4 drivers).
If anyone has had different experiences, let me know... but I think
that this solution offers good speed and n-tier (for an n that
dynamically changes values) flexibility, but with the cost of increased
development time (at least until you've finished rolling out your
in-house connection objects).
--
Within C++ is a smaller, cleaner language
struggling to get out.
It's called Java.
Thomas Moore
[EMAIL PROTECTED] Home Account
Software.Engineer [EMAIL PROTECTED]
phone://732.462.1880:268 NJ Patterns Group Home Page
employer://Celwave, RF http://members.home.net/twmoore/cjpg
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
