ODBC（不推荐）

要求：JDK<=1.7（jdk从1.8开始，删除了jdbc-odbc桥，所以odbc的驱动是用不了的，建议重新安装jdk1.7或者更低的版本）

  1. # 方式1
  2. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  3. Connection conn = DriverManager.getConnection("jdbc:odbc:td16","dbc","dbc");
  4. # 方式2
  5. import sun.jdbc.odbc.JdbcOdbcDriver;
  6. DriverManager.registerDriver(new JdbcOdbcDriver());
  7. Connection conn = DriverManager.getConnection("jdbc:odbc:td16","dbc","dbc");

JDBC

依赖下载

https://downloads.teradata.com/download/connectivity/jdbc-driver

依赖安装

  1. mvn install:install-file -DgroupId=com.teradata.jdbc -DartifactId=terajdbc4 -Dversion=17.00.00.02 -Dpackaging=jar -Dfile=terajdbc4.jar

依赖引入

  1. <dependency>
  2.   <groupId>com.teradata.jdbc</groupId>
  3.   <artifactId>terajdbc4</artifactId>
  4.   <version>17.00.00.02</version>
  5. </dependency>

配置

配置文件可从TTU目录获取（${TTU_HOME}\Teradata\Client\xx.xx\teragss\etc\TdgssUserConfigFile.xml）。

  1. <?xml version="1.0" encoding="US-ASCII"?>
  3. <!-- TDGSS User Configuration File -->
  5. <!-- This file consists of five sections:
  6.         Header
  7.         LegalValues
  8.         Algorithms
  9.         GlobalQops
  10.         Mechanisms
  11. -->
  13. <TdgssConfigFile>
  15.     <Header
  16.         Version="1"
  17.         ConfigFileType="User">
  18.     </Header>
  20.     <!-- Mechanisms Section: This section puts it all together; what
  21.          mechanisms are available and what QOPs each supports. -->
  23.     <Mechanisms>
  25.         <!-- One entry for each supported mechanism goes here -->
  28.         <!-- Teradata Method 1 has been DEPRECATED.
  29.              You may still use the TD1 security mechanism by copying the
  30.              TD1 configuration settings from TdgssLibraryConfigFile.xml to
  31.              this file, and then modify them to enable TD1.
  32.              However, it is not recommended.
  33.         -->
  36.         <!-- Teradata Method 2 (uses AES) -->
  38.         <Mechanism Name="TD2">
  40.             <!-- DHKeyP and DHKeyG are for legacy (pre-14.0) use only -->
  42.             <MechanismProperties
  43.                 AuthenticationSupported="no"
  44.                 AuthorizationSupported="no"
  46.                 MechanismEnabled="yes"
  47.                 MechanismRank="20"
  48.                 DefaultMechanism="no"
  50.                 DelegateCredentials="no"
  51.                 MutualAuthentication="yes"
  52.                 ReplayDetection="yes"
  53.                 OutOfSequenceDetection="yes"
  54.                 ConfidentialityDesired="yes"
  55.                 IntegrityDesired="yes"
  56.                 AnonymousAuthentication="no"              
  57.                 DesiredContextTime=""
  58.                 DesiredCredentialTime=""
  59.                 CredentialUsage="0"
  61.                 VerifyDHKey="no"
  63. DHKeyP="E4BE0A78F54C4A0B17E7E9249A78BCC08868C17281D8463C880937853E73DDC787E41580A8AFE2594D984C9E0814C590790354ECCD1BE8EA85961E5E0974B32EFE178335F061E80189B4BDAA20F67B47"
  64. DHKeyG="0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005"
  66.                 />
  68. <!-- Uncomment DHKeyP2048 and DHKeyG2048, move up directly under DHKEYG above 
  69.      and modify to override the default values in TdgssLibraryConfigFile.xml
  70. DHKeyP2048="8AB3F86E8D374B782F31DAD5F27D6AFDA30150C11A20CF6346712AE2D2C6B70A5B79D45D4C0C232A065B207B121B2C33E147B5983C38A1087F272703B0B839CBA6F71C5D0EB51EC890934EACF2C7DD2A1DF6F55E89B145A0359D35EF8FB6C561E157B13FF927A35E69963648614902B1034EF71197F545DEF3236244EADAE0689E624CF1245953630AE042BD797C4025E37C51D9F6CBDA0B2278FA7D5CA2D9CA930BE2968330C811A4BA4D0845333C0D62E3EE742154F6B62F2951CD8C73C43B5AA1C7819DEF1D7C9314411E465F8E4796666594AADE0AEB3F1256E5719E7AE54DD34FFDA949634E4A293C5BC60AF258BB9FE558086E83B3DD3D7491966DEE93"
  72. DHKeyG2048="00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005"
  73. -->
  75.             <!-- To disable legacy (pre 14.0) security,
  76.                  uncomment the MechQop Value="0" directly below. -->
  78.             <!-- LEGACY QOP
  79.             <MechQop Value="0"/>
  80.             -->
  82.             <!-- To update security uncomment one or more QOPs and edit. -->
  84.             <!-- DEFAULT QOP
  85.             <MechQop Value="Default">
  86.                 AES-K128_GCM_PKCS5Padding_SHA2_DH-K2048
  87.                 AES-K128_CBC_PKCS5Padding_SHA1_DH-K2048
  88.                 AES-K192_GCM_PKCS5Padding_SHA2_DH-K2048
  89.                 AES-K192_CBC_PKCS5Padding_SHA1_DH-K2048
  90.                 AES-K256_GCM_PKCS5Padding_SHA2_DH-K2048
  91.                 AES-K256_CBC_PKCS5Padding_SHA1_DH-K2048
  92.             </MechQop>
  93.             -->
  95.             <!-- LOW SECURITY QOP
  96.             <MechQop Value="Low">
  97.                 AES-K128_CBC_PKCS5Padding_SHA1_DH-K2048
  98.             </MechQop>
  99.             -->
  101.             <!-- MEDIUM SECURITY QOP
  102.             <MechQop Value="Medium">
  103.                 AES-K192_CBC_PKCS5Padding_SHA1_DH-K2048
  104.             </MechQop>
  105.             -->
  107.             <!-- HIGH SECURITY QOP
  108.             <MechQop Value="High">
  109.                 AES-K256_CBC_PKCS5Padding_SHA1_DH-K2048
  110.             </MechQop>
  111.             -->
  113.         </Mechanism>
  117.         <!-- SSPI: Kerberos Compatability has been DEPRECATED.
  118.              You may still use the KRB5C security mechanism by copying the
  119.              KRB5C configuration settings from TdgssLibraryConfigFile.xml to
  120.              this file, and then modify them to enable KRB5C.
  121.              However, it is not recommended.
  122.         -->
  125.         <!-- SSPI: Kerberos -->
  127.         <Mechanism Name="KRB5">
  129.             <MechanismProperties
  130.                 AuthenticationSupported="yes"
  131.                 AuthorizationSupported="no"
  133.                 MechanismEnabled="yes"
  134.                 MechanismRank="40"
  135.                 DefaultMechanism="no"
  138.                 DelegateCredentials="yes"
  139.                 MutualAuthentication="yes"
  140.                 ReplayDetection="yes"
  141.                 OutOfSequenceDetection="yes"
  142.                 ConfidentialityDesired="yes"
  143.                 IntegrityDesired="yes"
  144.                 AnonymousAuthentication="no"              
  145.                 DesiredContextTime=""
  146.                 DesiredCredentialTime=""
  147.                 CredentialUsage="0"
  149.                 />
  151.         </Mechanism>
  154.         <!-- SSPI: NTLM Compatability has been DEPRECATED.
  155.              You may still use the NTLMC security mechanism by copying the
  156.              NTLMC configuration settings from TdgssLibraryConfigFile.xml to
  157.              this file, and then modify them to enable NTLMC.
  158.              However, it is not recommended.
  159.         -->
  162.         <!-- SSPI: NTLM has been DEPRECATED.
  163.              You may still use the NTLM security mechanism by copying the
  164.              NTLM configuration settings from TdgssLibraryConfigFile.xml to
  165.              this file, and then modify them to enable NTLM.
  166.              However, it is not recommended.
  167.         -->
  170.         <!-- SSPI: SPNEGO -->
  171.         <Mechanism Name="SPNEGO">
  173.             <MechanismProperties
  174.                 AuthenticationSupported="yes"
  175.                 AuthorizationSupported="no"
  176.                 SingleSignOnSupported="yes"
  178.                 DefaultMechanism="no"
  179.                 MechanismEnabled="yes"
  180.                 MechanismRank="65"
  182.                 DelegateCredentials="yes"
  183.                 MutualAuthentication="yes"
  184.                 ReplayDetection="yes"
  185.                 OutOfSequenceDetection="yes"
  186.                 ConfidentialityDesired="yes"
  187.                 IntegrityDesired="yes"
  188.                 AnonymousAuthentication="no"
  189.                 DesiredContextTime=""
  190.                 DesiredCredentialTime=""
  191.                 CredentialUsage="0"
  192.                 />
  194.         </Mechanism>
  196.         <!-- LDAPv3 -->
  198.         <Mechanism Name="ldap">
  200.             <!-- DHKeyP and DHKeyG are for legacy (pre-14.0) use only -->
  202.             <MechanismProperties
  203.                 AuthenticationSupported="yes"
  204.                 AuthorizationSupported="no"
  206.                 MechanismEnabled="yes"
  207.                 MechanismRank="70"
  208.                 DefaultMechanism="no"
  211.                 DelegateCredentials="no"
  212.                 MutualAuthentication="yes"
  213.                 ReplayDetection="yes"
  214.                 OutOfSequenceDetection="yes"
  215.                 ConfidentialityDesired="yes"
  216.                 IntegrityDesired="yes"
  217.                 AnonymousAuthentication="no"              
  218.                 DesiredContextTime=""
  219.                 DesiredCredentialTime=""
  220.                 CredentialUsage="0"
  222.                 VerifyDHKey="no"
  224. DHKeyP="E4BE0A78F54C4A0B17E7E9249A78BCC08868C17281D8463C880937853E73DDC787E41580A8AFE2594D984C9E0814C590790354ECCD1BE8EA85961E5E0974B32EFE178335F061E80189B4BDAA20F67B47"
  225. DHKeyG="0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005"
  227.                 LdapServerName=""
  228.                 LdapServerPort="389"
  229.                 LdapServerRealm=""
  230.                 LdapSystemFQDN=""
  231.                 LdapBaseFQDN=""
  232.                 />
  235. <!-- Uncomment DHKeyP2048 and DHKeyG2048, move up directly under DHKEYG above 
  236.      and modify to override the default values in TdgssLibraryConfigFile.xml
  237. DHKeyP2048="8AB3F86E8D374B782F31DAD5F27D6AFDA30150C11A20CF6346712AE2D2C6B70A5B79D45D4C0C232A065B207B121B2C33E147B5983C38A1087F272703B0B839CBA6F71C5D0EB51EC890934EACF2C7DD2A1DF6F55E89B145A0359D35EF8FB6C561E157B13FF927A35E69963648614902B1034EF71197F545DEF3236244EADAE0689E624CF1245953630AE042BD797C4025E37C51D9F6CBDA0B2278FA7D5CA2D9CA930BE2968330C811A4BA4D0845333C0D62E3EE742154F6B62F2951CD8C73C43B5AA1C7819DEF1D7C9314411E465F8E4796666594AADE0AEB3F1256E5719E7AE54DD34FFDA949634E4A293C5BC60AF258BB9FE558086E83B3DD3D7491966DEE93"
  239. DHKeyG2048="00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005"
  240. -->
  243.             <!-- To disable legacy (pre 14.0) security,
  244.                  uncomment the MechQop Value="0" directly below. -->
  246.             <!-- LEGACY QOP
  247.             <MechQop Value="0"/>
  248.             -->
  250.             <!-- To update security uncomment one or more QOPs and edit. -->
  252.             <!-- DEFAULT QOP
  253.             <MechQop Value="Default">
  254.                 AES-K128_GCM_PKCS5Padding_SHA2_DH-K2048
  255.                 AES-K128_CBC_PKCS5Padding_SHA1_DH-K2048
  256.                 AES-K192_GCM_PKCS5Padding_SHA2_DH-K2048
  257.                 AES-K192_CBC_PKCS5Padding_SHA1_DH-K2048
  258.                 AES-K256_GCM_PKCS5Padding_SHA2_DH-K2048
  259.                 AES-K256_CBC_PKCS5Padding_SHA1_DH-K2048
  260.             </MechQop>
  261.             -->
  263.             <!-- LOW SECURITY QOP
  264.             <MechQop Value="Low">
  265.                 AES-K128_CBC_PKCS5Padding_SHA1_DH-K2048
  266.             </MechQop>
  267.             -->
  269.             <!-- MEDIUM SECURITY QOP
  270.             <MechQop Value="Medium">
  271.                 AES-K192_CBC_PKCS5Padding_SHA1_DH-K2048
  272.             </MechQop>
  273.             -->
  275.             <!-- HIGH SECURITY QOP
  276.             <MechQop Value="High">
  277.                 AES-K256_CBC_PKCS5Padding_SHA1_DH-K2048
  278.             </MechQop>
  279.             -->
  281.         </Mechanism>
  283.         <!-- TDNEGO: Teradata Negotiated Method -->
  285.         <!-- To modify TDNEGO configuration, uncomment this
  286.              section and edit
  288.         <Mechanism Name="TDNEGO">
  290.             <MechanismProperties
  292.                 MechanismEnabled="yes"
  293.                 DefaultMechanism="no"
  294.                 DefaultNegotiatingMechanism="no"
  295.                 MechanismRank="10"
  297.                 />
  299.             <NegotiatedMechanism ObjectId="1.2.840.113554.1.2.2" Enable="yes"/>
  300.             <NegotiatedMechanism ObjectId="1.3.6.1.4.1.191.1.1012.1.20" Enable="yes"/>
  301.             <NegotiatedMechanism ObjectId="1.3.6.1.4.1.191.1.1012.1.1.9" Enable="yes"/>
  303.         </Mechanism>
  305.         (end of commented out section) --> 
  307.        <!-- JWT -->
  308.        <!-- To modify JWT mechanism configuration, uncomment this section and edit
  309.         <Mechanism Name="JWT">
  310.             <MechanismProperties
  311.                 MechanismEnabled="yes"
  312.                 DefaultMechanism="no"
  314.                 JWTDecryptionKeyFile=""
  315.                 JWTVerificationKeyFile=""
  316.                 JWTSkewTime="300"
  317.                 />
  318.         </Mechanism> 
  319.         (end of commented out section)-->
  321.     </Mechanisms>
  323. </TdgssConfigFile>

示例

1. Teradata Java Simple JDBC Demo

  1. Class.forName("com.teradata.jdbc.TeraDriver");
  2. Connection conn = DriverManager.getConnection("jdbc:teradata://192.168.136.128/dbc", "dbc", "dbc");
  3. Statement stmt = conn.createStatement();
  4. ResultSet rs = stmt.executeQuery("select khzhgxxlh,cjsj,gxsj from DIF_dev.DIF_KHKZGXB0527");
  5. while (rs.next()) {
  6.     System.out.println(String.format("%s,%s,%s",rs.getString(1),rs.getString(2),rs.getString(3)));
  7. }
  8. rs.close();
  9. stmt.close();
  10. conn.close();

2. Teradata Java FastExport Demo

  1. import java.sql.*;
  3. public class TeradataFastExport {
  4.     public static void main(String[] args) throws ClassNotFoundException, SQLException {
  5.         Class.forName("com.teradata.jdbc.TeraDriver");
  6.         String url = "jdbc:teradata://192.168.136.128/DATABASE=dbc,CHARSET=UTF8,TMODE=TERA,TYPE=FASTEXPORT,RECONNECT_COUNT=50";
  7.         Connection connection = DriverManager.getConnection(url, "dbc", "dbc");
  8.         PreparedStatement stmt = connection.prepareStatement("select khzhgxxlh,cjsj,gxsj from DIF_dev.DIF_KHKZGXB0527");
  9.         stmt.setFetchSize(100);
  10.         ResultSet rs = stmt.executeQuery();
  11.         int i = 1;
  12.         while (rs.next()) {
  13.             System.out.println(String.format("%d - %s", i++, rs.getObject(1)));
  14.         }
  15.     }
  16. }