On Tue, Jul 31, 2001 at 08:54:05AM -0400, Berin Loritsch spoke thusly:
> Honestly though, in house we have used Informix and Oracle in our projects.
> Informix is pretty nice and the JDBC driver is blazingly fast. The Oracle
> driver is slower and does not handle BLOBs and CLOBs in a JDBC2.0 compatible
> manner.
Actually, I've used the oracle drivers and had them treal sblobs and
clobs in a JDBC compliant manner. I may be using a newer JDBC Driver
than you did, though, as there were changes between the 7.x and
current 8.x drivers.
> I haven't had the time or pleasure to mess with any of the other databases.
I have over the past few years *grin* See below.
> I really don't have a recommendation for you other than Merant--unless it
> is possible to change database vendors. Informix is on the affordable side,
> but is a PITA to install correctly (esp. on NT). PostgreSQL is also available
As is MySQL, but MySQL doesn't support a lot of things you're used to
in M$SQL, Oracle, and Postgres. JDBC Support through two community
built drivers.
DB/2 is a reasonable replacement, although expensive, and IMHO, much
more robust than both M$ and PostgreSQL. JDBC Support is excellent.
Oracle is the king, and is almost an OS unto itself. But we knew that
*grin*
I have heard nothing but good things about Informix. I have yet to try
it, but I know Oracle DBAs who think Informix is the second coming. I
haven't futzed with it and JDBC drivers yet.
HTH
--
+-------------------------------------------+
| Kevin Sonney [EMAIL PROTECTED] |
| Systems Programmer www.webslingerZ.com |
+-------------------------------------------+
"The weakest link in any civil rights case is always the
defendant. Imagine being a lawyer and getting a call from me. That's why I
try to, uh, behave myself." - Hunter S. Thompson
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
