teradata DB connection在Jboss中的配置，

teradata DB connection在Jboss中的配置，

To set up the environment for teradata DB connection in Jboss4.0
Please do several actions to set up the environment for connection to teradata DB in Jboss4.0:

1)Put the named: teradata-ds.xml file into folder below:
JbossFolder\server\default\deploy

2)Put the named: TdgssUserConfigFile.xml file into folder below:
JbossFolder\server\default\conf

3)Put the named: terajdbc4.jar file into folder below:
JbossFolder\server\default\lib


teradata-ds.xml 代码如下：

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>TeradataDS</jndi-name>
    <connection-url>jdbc:teradata://serverIPAddress/DATABASE=dbName,TMODE=ANSI,CHARSET=UTF8</connection-url>	
    <driver-class>com.teradata.jdbc.TeraDriver</driver-class>
    <user-name>myName</user-name>
    <password>myPassword</password>
  </local-tx-datasource>
</datasources>

TdgssUserConfigFile.xml代码如下： 我没去弄明白什么意思，不管他，拿来能用就行^_^

<?xml version="1.0" encoding="US-ASCII"?>

<!-- TDGSS User Configuration File -->

<!-- This file consists of five sections:
        Header
        LegalValues
        Algorithms
        GlobalQops
        Mechanisms
-->

<TdgssConfigFile>

    <Header
        Version="1"
        ConfigFileType="User">
    </Header>

    <!-- Mechanisms Section: This section puts it all together; what
         mechanisms are available and what QOPs each supports. -->

    <Mechanisms>

        <!-- One entry for each supported mechanism goes here -->


        <!-- Teradata Method 1 -->
        <!-- This mechanism is required to support clients prior to
             TTU 8.0.  Previous clients use a different message 
             format and therefore require a separate mechanism.

             It should not have the attribute DefaultMechanism="no"
             since DBSV2 6.0 will not offer TD1 to TTU 8.0 clients.
        -->
        <Mechanism Name="TD1">

            <MechanismProperties
                AuthenticationSupported="no"
                AuthorizationSupported="no"

                MechanismEnabled="yes"
                MechanismRank="10"

                DelegateCredentials="no"
                MutualAuthentication="yes"
                ReplayDetection="yes"
                OutOfSequenceDetection="yes"
                ConfidentialityDesired="yes"
                IntegrityDesired="yes"
                AnonymousAuthentication="no"              
                DesiredContextTime=""
                DesiredCredentialTime=""
                CredentialUsage="0"
                />

        </Mechanism>


        <!-- Teradata Method 2 (uses AES) -->

        <Mechanism Name="TD2">

            <MechanismProperties
                AuthenticationSupported="no"
                AuthorizationSupported="no"

                MechanismEnabled="yes"
                MechanismRank="20"
                DefaultMechanism="no"

                DelegateCredentials="no"
                MutualAuthentication="yes"
                ReplayDetection="yes"
                OutOfSequenceDetection="yes"
                ConfidentialityDesired="yes"
                IntegrityDesired="yes"
                AnonymousAuthentication="no"              
                DesiredContextTime=""
                DesiredCredentialTime=""
                CredentialUsage="0"

                VerifyDHKey="no"
DHKeyP="E4BE0A78F54C4A0B17E7E9249A78BCC08868C17281D8463C880937853E73DDC787E41580A8AFE2594D984C9E0814C590790354ECCD1BE8EA85961E5E0974B32EFE178335F061E80189B4BDAA20F67B47"
DHKeyG="0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005"
                />

        </Mechanism>


        <!-- SSPI: Kerberos Compatability -->
        <!-- This mechanism is required to support clients prior to
             TTU 8.0.  Previous clients use a different message 
             format and therefore require a separate mechanism.

             It should not have the attribute DefaultMechanism="no"
             since DBSV2 6.0 will not offer KRB5C to TTU 8.0 clients.
        -->
        <Mechanism Name="KRB5C">

            <MechanismProperties
                AuthenticationSupported="yes"
                AuthorizationSupported="no"

                MechanismEnabled="yes"
                MechanismRank="30"

                DelegateCredentials="no"
                MutualAuthentication="yes"
                ReplayDetection="yes"
                OutOfSequenceDetection="yes"
                ConfidentialityDesired="yes"
                IntegrityDesired="yes"
                AnonymousAuthentication="no"              
                DesiredContextTime=""
                DesiredCredentialTime=""
                CredentialUsage="0"
                />

        </Mechanism>


        <!-- SSPI: Kerberos -->

        <Mechanism Name="KRB5">

            <MechanismProperties
                AuthenticationSupported="yes"
                AuthorizationSupported="no"

                MechanismEnabled="yes"
                MechanismRank="40"
                DefaultMechanism="no"


                DelegateCredentials="no"
                MutualAuthentication="yes"
                ReplayDetection="yes"
                OutOfSequenceDetection="yes"
                ConfidentialityDesired="yes"
                IntegrityDesired="yes"
                AnonymousAuthentication="no"              
                DesiredContextTime=""
                DesiredCredentialTime=""
                CredentialUsage="0"

                />

        </Mechanism>


        <!-- SSPI: NTLM Compatability -->
        <!-- This mechanism is required to support clients prior to
             TTU 8.0.  Previous clients use a different message 
             format and therefore require a separate mechanism.

             It should not have the attribute DefaultMechanism="no"
             since DBSV2 6.0 will not offer NTLMC to TTU 8.0 clients.
        -->

        <Mechanism Name="NTLMC">

            <MechanismProperties
                AuthenticationSupported="yes"
                AuthorizationSupported="no"

                MechanismEnabled="yes"
                MechanismRank="50"

                DelegateCredentials="no"
                MutualAuthentication="yes"
                ReplayDetection="yes"
                OutOfSequenceDetection="yes"
                ConfidentialityDesired="yes"
                IntegrityDesired="yes"
                AnonymousAuthentication="no"              
                DesiredContextTime=""
                DesiredCredentialTime=""
                CredentialUsage="0"            
                />

        </Mechanism>


        <!-- SSPI: NTLM -->
        <Mechanism Name="NTLM">

            <MechanismProperties
                AuthenticationSupported="yes"
                AuthorizationSupported="no"

                MechanismEnabled="yes"
                MechanismRank="60"
                DefaultMechanism="no"


                DelegateCredentials="no"
                MutualAuthentication="yes"
                ReplayDetection="yes"
                OutOfSequenceDetection="yes"
                ConfidentialityDesired="yes"
                IntegrityDesired="yes"
                AnonymousAuthentication="no"              
                DesiredContextTime=""
                DesiredCredentialTime=""
                CredentialUsage="0"                
                />

        </Mechanism>

        <!-- LDAPv3 -->

        <Mechanism Name="ldap">

            <MechanismProperties
                AuthenticationSupported="yes"
                AuthorizationSupported="yes"

                MechanismEnabled="yes"
                MechanismRank="70"
                DefaultMechanism="no"


                DelegateCredentials="no"
                MutualAuthentication="yes"
                ReplayDetection="yes"
                OutOfSequenceDetection="yes"
                ConfidentialityDesired="yes"
                IntegrityDesired="yes"
                AnonymousAuthentication="no"              
                DesiredContextTime=""
                DesiredCredentialTime=""
                CredentialUsage="0"

                VerifyDHKey="no"
DHKeyP="E4BE0A78F54C4A0B17E7E9249A78BCC08868C17281D8463C880937853E73DDC787E41580A8AFE2594D984C9E0814C590790354ECCD1BE8EA85961E5E0974B32EFE178335F061E80189B4BDAA20F67B47"
DHKeyG="0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005"

                LdapServerName=""
                LdapServerPort="389"
                LdapServerRealm=""
                LdapSystemFQDN=""
                LdapBaseFQDN=""
                />

        </Mechanism>

    </Mechanisms>

</TdgssConfigFile>

terajdbc4.jar 请参看附件

OVER