Targets Reachable by JDBC
This article will be enhanced from time to time to include an updated list of tested targets, JDBC drivers, JAVA versions and Operating System versions. If you are interested in our testing regimen, then please reference Loader Regression Testing.
Loader version 3.0 was released in 2006 and this was the first version that included support for a JDBC interface. The principal target database tested for this original JDBC release was Microsoft SQL Server, but our intention was to provide a general interface that worked for all JDBC drivers. To that end the design assumed that all drivers would be Type 4 (native JAVA) drivers. This does not preclude the use of other types of drivers, but we have expended zero effort to make alternate types compatible and few vendors provide any other type.
Subsequent releases provided a much improved (i.e. reduced CPU demand) C → JAVA interface. As time proceeded, we added regression testing for traditional Oracle database targets and then for Rdb targets when the JDBC for Rdb server became available. Testing on a wider set of targets gave us confidence that the generality of our approach was valid.
Customers seized on the opportunity presented by the JDBC interface to replicate to multiple other databases such as Teradata and MySQL, despite the fact that these targets had not been part of the Loader's regression testing environment. No unexpected behavior was found in the replicated data, although some surprises were found, such as all schemas being visible to metadata queries. This led to a number of ad-hoc enhancements of the interface to allow better use of those targets. JCC's interest in "Big Data" has also led to other enhancements, although those targets have not been included in the regression testing cycle, so far, and have been tested only in an ad-hoc fashion.
With the 3.5 release we have enhanced the Loader regression testing suite to validate proper and expected behavior against additional database targets. The full table of testing follows. The table shows the combinations of JDBC drivers, JAVA versions, target database versions, source and target operating systems that were tested. As you will note, we used Java 1.6 for most of these tests. However, that is only for this release. We have tested with older versions, over time, and those worked (sometimes with patches) reasonably well. See this article for a discussion on JAVA versions. Since a single VMS system may host multiple JAVA versions, we don't view this as a limitation. We do recommend that you upgrade when you can.
VMS Software Inc. and HPE have recently released Java 8 on OpenVMS. Java 8 requires a complete 64-bit interface. JCC LogMiner Loader V3.5.1 adds support for JAVA 8 on Integrity. We have added some tests to specifically use Java 8 and have expanded others to alternate between Java 1.6 and Java 8.
The following table indicates the versions tested for version V3.5.0 and V3.5.1 of the Loader.
|JCC LogMiner Loader version 3.05.00 and V3.05.01
|Source Architecture||OpenVMS Version||JAVA Version||Target Database||Host OS||JDBC Driver|
|Alpha||8.4||1.5.0-5||SQL Server 2005||Windows Server 2003||Microsoft 1.2.2828.100|
|SourceForge jTDS 1.2.7|
|Integrity||8.4-2L1||1.6.0-6||SQL Server 2012||Windows Server 2012 R2||Microsoft 4.1|
|SourceForge jTDS 1.2.7|
|Integrity||8.4||1.6.0-5||Oracle 18.104.22.168.0||RHEL 6.8 (Santiago)||ojdbc6 from the 12.1 install|
|Integrity||8.4 1H1||1.6.0-6||5.5.5-10.1.11-MariaDB||CentOS Linux release 7.4||mysql-connector-java-5.1.35|
|Integrity||8.4 1H1||22.214.171.124||V7.3-130||OpenVMS 8.4 1h1||Rdb JDBC Driver V126.96.36.199.0|
|Integrity||8.4||1.6.0-6||Oracle 10.1||OpenVMS 8.3||OJDBC14 from the kit|
|Integrity||8.4-2L1||1.6.0-6||Oracle 10.1||OpenVMS 8.3||OJDBC14 from the kit|
|Integrity||8.4 1H1||1.6.0-6||Oracle 188.8.131.52.0||OpenVMS 8.4 1h1||ojdbc6.jar from the kit|
|Integrity||8.4 1H1||1.6.0-6||PostgreSQL 9.4.14||CentOS Linux release 7.4||PostgreSQL 9.4.1207.jre6
|Alpha||8.4||1.4.2-4.p5||Oracle 184.108.40.206.0||RHEL 6.8 (Santiago)||Oracle driver 10.2.0.2.0 (From kit)|
|Integrity||8.4 1H1||1.6.0-6||Teradata DB 15.00.02.08||SUSE Linux Enterprise Server 11 SP1||Teradata driver 15.10.00.07|
|Integrity||8.4-2L1||1.6.0-6||Rdb V7.3-200||VMS 8.4-2||Rdb JDBC Driver 220.127.116.11.0|
|JCC LogMiner Loader version V3.05.01
|Integrity||8.4-1H1||1.8.0.03||Oracle 18.104.22.168.0||RHEL 7.4 (64 bit)||Oracle 22.214.171.124.0|
|Integrity||8.4-1H1||1.8.0.03||SQL Server 2016
|Windows Server 2016||Microsoft 6.2.2
SourceForge jTDS 1.3.1
|Integrity||8.4-1H1||1.8.0.03||PostgreSQL 9.4.14||CentOS Linux release 7.4||PostgreSQL 42.1.4|
|Integrity||8.4 1H1||1.8.0.03||Teradata DB 15.00.02.08||SUSE Linux Enterprise Server 11 SP1||Teradata driver 16.10.00.05|