Yes, a Java Program works, it does show a certificate error, but, it does at least yield results

Here is the Java Program that partially works

package db;

 

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

 

public class jdbcTeradataConnectionTestCertificate {

 

 

 

    public static void main(String[] args) throws Exception 
    {

try 
{

String serverURL = "jdbc:teradata://172.28.130.20/LOGMECH=LDAP"; // Wo
+rked on my laptop, but not main main pc
Class.forName("com.teradata.jdbc.TeraDriver");
String username = "!NEDVFCollections";
String password = "xxxxx";

Connection con = DriverManager.getConnection(serverURL, username, pass
+word);

String query="select top 2* from NED_COLL_TABLES.T_PM_PREPAY_FIN WHERE
+ SYS = 8773";
        
        PreparedStatement stmt=con.prepareStatement(query);
        ResultSet rs=stmt.executeQuery();
        while(rs.next()) 
        {
            String col1=rs.getString(1);
            System.out.println("col1="+col1);
        }

}

 

 

catch (Exception e) 
{
e.printStackTrace();
}

 

 

}
[download]

Here are the results it yielded, as one can see, it did print out values "GBR"

C:\Work\Programming\javaProgrammingLog>java jdbcTeradataConnectionTest
+Certificate.java
2023-12-07.10:41:13.437 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.
+JDK6_SQL_Connection@783a467b getPeerCertificates failed for connectio
+n to /172.28.130.20:443 begin-log-stack-trace>>> javax.net.ssl.SSLPee
+rUnverifiedException: peer not authenticated
        at java.base/sun.security.ssl.SSLSessionImpl.getPeerCertificat
+es(SSLSessionImpl.java:1034)
        at com.teradata.jdbc.jdbc_4.io.CertChecker.checkCert(CertCheck
+er.java:67)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.isUsableSocket(TD
+NetworkIOIF.java:1424)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDN
+etworkIOIF.java:614)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConne
+ction(TDNetworkIOIF.java:185)
        at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createIO(TDNetwor
+kIOIF.java:176)
        at com.teradata.jdbc.jdbc.GenericTeradataConnection.<init>(Gen
+ericTeradataConnection.java:319)
        at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:18
+8)
        at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_
+Connection.java:36)
        at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLCo
+nnection(JDK6ConnectionFactory.java:25)
        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(C
+onnectionFactory.java:181)
        at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(C
+onnectionFactory.java:171)
        at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:229)
        at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:164)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager
+.java:683)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager
+.java:230)
        at db.jdbcTeradataConnectionTestCertificate.main(jdbcTeradataC
+onnectionTestCertificate.java:68)
        at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.i
+nvoke(DirectMethodHandleAccessor.java:104)
        at java.base/java.lang.reflect.Method.invoke(Method.java:577)
        at jdk.compiler/com.sun.tools.javac.launcher.Main.execute(Main
+.java:421)
        at jdk.compiler/com.sun.tools.javac.launcher.Main.run(Main.jav
+a:192)
        at jdk.compiler/com.sun.tools.javac.launcher.Main.main(Main.ja
+va:132)
 <<<end-log-stack-trace
col1=GBR
col1=GBR
[download]

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.