Archives of the TeradataForum

Message Posted: Thu, 17 Apr 2003 @ 20:24:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Just for clarity, a JDBC type IV driver is one that is written in 100% pure Java, and doesn't rely on any non-java api calls (such as CLI or ODBC) and don't rely on any intermediate gateway.

As such, type IV drivers avoid the overhead of going back and forth between Java and non-java code, but more importantly it means that a type IV driver can be used on ANY systems that has a Java VM (and supports TCP/IP).

A Type IV driver could be used on a mainframe, a UNIX box, a PC, a Palm, a PocketPC, etc.

JDBC drivers that rely on gateways tend to be the slowest, as you are doubling the number of TCP/IP messages, and end up with a concentration point (and single point of failure) at the gateway machine.

I don't have a copy of NCR's beta JDBC type IV driver to compare to mine, but unless they have done something dreadfully wrong, I'm sure either will be a better choice than using a gateway. And I believe there are other Teradata JDBC type IV drivers out there.

	<Prev	Next>		<<First	<Prev	Next>	Last>>