Kevin Sonney wrote:
>
> 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.
There are currently work arounds for Oracle in the Jdbc Connection pooling and
in the DB actions. This is using the latest driver (well, as of a month ago).
The issues with BLOB and CLOB handling are that unless you use the CLI JDBC
driver, you cannot use the getBinaryStream() or setBinaryStream() methods
for anything over 4k. The thin driver requires that you recast the ResultSet
or PreparedStatement to the Oracle version and use getBLOB() method and
manipulate it from there. You also have to alter your SQL statements so that
you select the blob or insert an "empty_blob()" to prepare it for manipulation.
That is counter intuitive--and a royal pain to have to maintain.
> 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.
I have. Informix is a pain to set up--especially on the Windows platform
(it is much easier on UNIX). However, once you set it up, Informix Rocks.
I think Informix has to have the fastest JDBC driver I have ever used to
this point. With Informix on a remote machine (modest hardware), my application
ran faster than native access to a local database. The difference in the
drivers is that amazing. Also, JDBC access is MUCH FASTER than the Informix
ODBC drivers.
To give an overall example of what I mean, I have a program called DataXfer
that manipulates data and moves it between the filesystem and the database
or between databases. When I was using the JDBC-ODBC bridge, the transfer
took over an hour. When I switched to the Informix JDBC driver, the transfer
took less than 5 minutes. The ODBC driver has much more latency, and the
overhead of the JDBC-ODBC driver adds that much more to the query.
---------------------------------------------------------------------
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]>
