It's a beta, but it works pretty good. It supports most applications, including most J2EE application servers, such as WebLogic, Websphere, JBOSS, and the J2EE reference implementation. And it's the only third party JDBC driver for Teradata that currently supports V2R6.1, V2R6.0 and V2R5.1 secure logons.
And, it's free!
If you use this driver, Let me know what problems you run in to, or let me know it is working for you, and what type of use you are using it for. I really need feedback if people want me to keep working on this project!.
Download the file TdatJdbcDriver.jar, and add it to your CLASSPATH (note the name change from previous versions).
To use it, the class is us.mcdevitt.TdatJdbcDriver,
And the URL is jdbc:tdat:whatever.
Connection con = DriverManager.getConnection("jdbc:tdat:mydbcname, "uid", "pwd");
The url can include a port number, and can include optional slashes:
You can use DataSources as well as driver connections.
PooledConnections work, but are not well debugged. Let me know if they work well for you.
The support for 2-phase commit (XA transactions) is not complete and not tested yet.
You can force Teradata vs ANSI transaction semantics in the url:
Most of my testing has been with Teradata mode.
Let me know what problems you hit, and I'll fix them.
Compared to the NCR driver, My driver has many advantages:
1) Much faster than the type 2 or type 3 NCR driver (faster than the NCR driver or the JDBC-ODBC bridge driver). I believe it's a good bit faster than their type 4 driver as well, and is much smaller.
2) More compliant. Passes almost all the Sun JDBC certification tests.
3) Type 4, 100% pure java, doesn’t need any gateway or native code. Runs on any platform that supports a JAVA VM.
4) Works in EJBs, Servlets, Applets, and applications (the NCR type 4 driver probably does all this).
5) Extensive tracing facilities built in.
6) Easy to install -- One jar only.
The current state of the driver is that it's not quite complete. Missing features:
1) Support for updateable cursors (WHERE CURRENT OF).
2) Support for cursor scrolling other than FORWARD_ONLY
3) XA support not complete and not yet tested.
4) LOB support not yet available.
New features of the May 2006 driver:
New features of the July 2005 driver:
New features of the January 2003 driver:
1) Fixes for better handling of errors in logon strings, and support for "trace" and "databaseName" properties when loging on via propertySets (these were supported via urls only before).
Note: If your Application Server doesn't use the JDBC driver manager, it may need to know an "implementation classname". This would typically be us.mcdevitt.TdatJdbcConnectionPoolDataSource.
Copyright © 2002-2006 Charles F McDevitt.