I have updated my code. Unfortunately, I have not been able to get this program to run. However, at least I now have an error message

I am receiving the following error message:

Here is my updated code

 use strict;
use warnings;
use Inline Java => <<'END';

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class TeradataTableCreator {
  public static void createTable(String jdbcUrl, String username, Stri
+ng password) throws Exception {
    // Load Teradata JDBC driver
    Class.forName("com.teradata.jdbc.TeraDriver");

    // Establish the connection
    Connection connection = DriverManager.getConnection(jdbcUrl, usern
+ame, password);

    // Create a Statement
    Statement statement = connection.createStatement();

    // Execute the SQL statement to create a sample table
    String createTableSQL = "CREATE TABLE SampleTable (ID INT, Name VA
+RCHAR(255))";
    statement.executeUpdate(createTableSQL);

    // Close resources
    statement.close();
    connection.close();
  }
}

END

# Specify your Teradata connection details
my $jdbcUrl = "jdbc:teradata://000.00.000.00/TMODE=TERA,DBS_PORT=1025,
+CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";
my $username = "XXXXX";
my $password = "XXXXXX";

# Call the Java method to create the table
TeradataTableCreator->createTable($jdbcUrl, $username, $password);
[download]

main::java::lang::ClassNotFoundException

Java does not find a required class.

// Load Teradata JDBC driver
Class.forName("com.teradata.jdbc.TeraDriver");
[download]

Are you sure that is sufficient? According to https://docs.oracle.com/javase%2F7%2Fdocs%2Fapi%2F%2F/java/lang/Class.html#forName(java.lang.String), this method may return a class object, but it does not initialize it. This method is documented to throw a ClassNotFoundException, so its parameter is likely to be the first problem. Java has no clue where to find the class file.

// Establish the connection
Connection connection = DriverManager.getConnection(jdbcUrl, username,
+ password);
[download]

According to https://docs.oracle.com/javase/8/docs/api/java/sql/DriverManager.html#getConnection-java.lang.String-java.lang.String-java.lang.String-, this method does not throw a ClassNotFoundException. But:

The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers.

And that might be the second problem: The JDBC driver must somehow be registered. My guess is that that happens when the driver class is initialized, which does not happen in your code.

https://docs.oracle.com/javase/8/docs/api/java/sql/DriverManager.html#registerDriver-java.sql.Driver- explains:

Registers the given driver with the DriverManager. A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Yahoo! - I solved the problem - wasn't easy, but I did it. I'll share my code in case anyone else has the issue. The big item was I had to point to my class path jar file to point to terajdbc4.jar

use strict;

use warnings;

 

use Inline Java => <<'END' => CLASSPATH => 'C:/jars/terajdbc4.jar';

 

 

import java.sql.Connection;

import java.util.*;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.io.PrintWriter;

import java.sql.*;


 

public class TeradataConnectionTest {

public static void testConnection(String jdbcUrl, String username, Str
+ing password) {

try {

                System.out.println("Test up to part 1");

//e.printStackTrace();

//DriverManager.registerDriver(new com.teradata.jdbc.TeraDriver());

 

//DriverManager.registerDriver(new com.teradata.jdbc.TeraDriver()); Di
+d not work

Class.forName("com.teradata.jdbc.TeraDriver"); //Did not work

//  Class.forName("com.ncr.teradata.TeraDriver"); Did not work

Connection connectionA = DriverManager.getConnection(jdbcUrl, username
+, password);

System.out.println("Test up to part 2");

System.out.println("Connected to Teradata!");

// Perform your database operations here

connectionA.close();

} catch (SQLException e)

 {

// Print the stack trace or error message

e.printStackTrace();

   System.err.println("SQLException: " + e.getMessage());

} catch (Exception e) {

// Handle other exceptions

e.printStackTrace();

}

}

}

 

END

 

# Your Teradata connection details

#COMMENTED OUT ON 2/14/24 my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX
+/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

#Here is my JAVA connection  String url = "jdbc:teradata://XXX.XX.XXX.
+XX/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

#commented out on 2/16/24 my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX
+/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW;Ter
+aDriver=com.teradata.jdbc.TeraDriver";

my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX/TMODE=TERA,DBS_PORT=1025,
+CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

#my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX/TMODE=TERA,DBS_PORT=1025
+,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

my $username = "XXXXX";

my $password = "XXXXXX";

 

# Call the Java method to test the connection

TeradataConnectionTest->testConnection($jdbcUrl, $username, $password)
+;
[download]

I believe I am getting closer. Running the below code

use strict;
use warnings;
use Inline Java => <<'END';

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.io.PrintWriter;

public class TeradataConnectionTest {
public static void testConnection(String jdbcUrl, String username, Str
+ing password) {
try {

DriverManager.setLogWriter(new PrintWriter(System.out));
//DriverManager.registerDriver(new com.teradata.jdbc.TeraDriver()); Di
+d not work 
//Class.forName("com.teradata.jdbc.TeraDriver"); Did not work
//  Class.forName("com.ncr.teradata.TeraDriver"); Did not work
Connection connection = DriverManager.getConnection(jdbcUrl, username,
+ password);
System.out.println("Connected to Teradata!");
// Perform your database operations here
connection.close();
 } catch (SQLException e) 
 {
// Print the stack trace or error message
 e.printStackTrace();
   System.err.println("SQLException: " + e.getMessage());
 } catch (Exception e) {
 // Handle other exceptions
 e.printStackTrace();
 }
 }
}

END

# Your Teradata connection details
my $jdbcUrl = "jdbc:teradata://172.28.130.20/TMODE=TERA,DBS_PORT=1025,
+CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW;TeraDriver=com.teradata.jdbc.
+TeraDriver";
my $username = "XXXXX";
my $password = "XXXXX";

# Call the Java method to test the connection
TeradataConnectionTest->testConnection($jdbcUrl, $username, $password)
+;
[download]

I am receiving the following error:

DriverManager.getConnection("jdbc:teradata://172.28.130.20/TMODE=TERA,
+DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW;TeraDriver=com.
+teradata.jdbc.TeraDriver")
registerDriver: io.trino.jdbc.TrinoDriver@2dd9625c
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
    trying io.trino.jdbc.TrinoDriver
getConnection: no suitable driver found for jdbc:teradata://172.28.130
+.20/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW;
+TeraDriver=com.teradata.jdbc.TeraDriver
java.sql.SQLException: No suitable driver found for jdbc:teradata://17
+2.28.130.20/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMOD
+E=ALLOW;TeraDriver=com.teradata.jdbc.TeraDriver
        at java.sql/java.sql.DriverManager.getConnection(DriverManager
+.java:708)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager
+.java:230)
        at TeradataConnectionTest.testConnection(TeradataConnectionTes
+t.java:15)
        at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.i
+nvoke(DirectMethodHandleAccessor.java:104)
        at java.base/java.lang.reflect.Method.invoke(Method.java:577)
        at InlineJavaUserClassLink.invoke(InlineJavaUserClassLink.java
+:11)
        at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.i
+nvoke(DirectMethodHandleAccessor.java:104)
        at java.base/java.lang.reflect.Method.invoke(Method.java:577)
        at org.perl.inline.java.InlineJavaUserClassLoader.invoke_via_l
+ink(InlineJavaUserClassLoader.java:86)
        at org.perl.inline.java.InlineJavaUserClassLoader.invoke(Inlin
+eJavaUserClassLoader.java:131)
        at org.perl.inline.java.InlineJavaProtocol.CallJavaMethod(Inli
+neJavaProtocol.java:283)
        at org.perl.inline.java.InlineJavaProtocol.Do(InlineJavaProtoc
+ol.java:41)
        at org.perl.inline.java.InlineJavaServer.ProcessCommand(Inline
+JavaServer.java:153)
        at org.perl.inline.java.InlineJavaServer.ProcessCommand(Inline
+JavaServer.java:142)
        at org.perl.inline.java.InlineJavaServerThread.run(InlineJavaS
+erverThread.java:51)
SQLException: SQLState(08001)
java.sql.SQLException: No suitable driver found for jdbc:teradata://17
+2.28.130.20/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMOD
+E=ALLOW;TeraDriver=com.teradata.jdbc.TeraDriver
        at java.sql/java.sql.DriverManager.getConnection(DriverManager
+.java:708)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager
+.java:230)
        at TeradataConnectionTest.testConnection(TeradataConnectionTes
+t.java:15)
        at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.i
+nvoke(DirectMethodHandleAccessor.java:104)
        at java.base/java.lang.reflect.Method.invoke(Method.java:577)
        at InlineJavaUserClassLink.invoke(InlineJavaUserClassLink.java
+:11)
        at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.i
+nvoke(DirectMethodHandleAccessor.java:104)
        at java.base/java.lang.reflect.Method.invoke(Method.java:577)
        at org.perl.inline.java.InlineJavaUserClassLoader.invoke_via_l
+ink(InlineJavaUserClassLoader.java:86)
        at org.perl.inline.java.InlineJavaUserClassLoader.invoke(Inlin
+eJavaUserClassLoader.java:131)
        at org.perl.inline.java.InlineJavaProtocol.CallJavaMethod(Inli
+neJavaProtocol.java:283)
        at org.perl.inline.java.InlineJavaProtocol.Do(InlineJavaProtoc
+ol.java:41)
        at org.perl.inline.java.InlineJavaServer.ProcessCommand(Inline
+JavaServer.java:153)
        at org.perl.inline.java.InlineJavaServer.ProcessCommand(Inline
+JavaServer.java:142)
        at org.perl.inline.java.InlineJavaServerThread.run(InlineJavaS
+erverThread.java:51)
SQLException: No suitable driver found for jdbc:teradata://172.28.130.
+20/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW;T
+eraDriver=com.teradata.jdbc.TeraDriver
[download]

So, it is almost like it is calling out to the trino driver, not the Teradata driver. How would appropriately register the driver, what is the syntax?

Will look into posting with cleaner code

However, when I say that it is not working, it is not doing what it is designed to do, which is to create a table - and this same code in JAVA does create a table fine

The perl script does not yield any error messages

However, as I'm typing this response, I noticed that it doesn't have a "strict" in the beginning of the code, so I'll look into adding and re-testing to help trouble shoot

Yahoo! - I solved the problem - wasn't easy, but I did it. I'll share my code in case anyone else has the issue. The big item was I had to point to my class path jar file to point to terajdbc4.jar

use strict;

use warnings;

 

use Inline Java => <<'END' => CLASSPATH => 'C:/jars/terajdbc4.jar';

 

 

import java.sql.Connection;

import java.util.*;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.io.PrintWriter;

import java.sql.*;


 

public class TeradataConnectionTest {

public static void testConnection(String jdbcUrl, String username, Str
+ing password) {

try {

                System.out.println("Test up to part 1");

//e.printStackTrace();

//DriverManager.registerDriver(new com.teradata.jdbc.TeraDriver());

 

//DriverManager.registerDriver(new com.teradata.jdbc.TeraDriver()); Di
+d not work

Class.forName("com.teradata.jdbc.TeraDriver"); //Did not work

//  Class.forName("com.ncr.teradata.TeraDriver"); Did not work

Connection connectionA = DriverManager.getConnection(jdbcUrl, username
+, password);

System.out.println("Test up to part 2");

System.out.println("Connected to Teradata!");

// Perform your database operations here

connectionA.close();

} catch (SQLException e)

 {

// Print the stack trace or error message

e.printStackTrace();

   System.err.println("SQLException: " + e.getMessage());

} catch (Exception e) {

// Handle other exceptions

e.printStackTrace();

}

}

}

 

END

 

# Your Teradata connection details

#COMMENTED OUT ON 2/14/24 my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX
+/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

#Here is my JAVA connection  String url = "jdbc:teradata://XXX.XX.XXX.
+XX/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

#commented out on 2/16/24 my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX
+/TMODE=TERA,DBS_PORT=1025,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW;Ter
+aDriver=com.teradata.jdbc.TeraDriver";

my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX/TMODE=TERA,DBS_PORT=1025,
+CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

#my $jdbcUrl = "jdbc:teradata://XXX.XX.XXX.XX/TMODE=TERA,DBS_PORT=1025
+,CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";

my $username = "XXXXX";

my $password = "XXXXXX";

 

# Call the Java method to test the connection

TeradataConnectionTest->testConnection($jdbcUrl, $username, $password)
+;
[download]

I removed the comments to make it easier to read.

Here is the updated code.

use Inline Java => <<'END_OF_JAVA_CODE' ;
import java.sql.*;

public class T20000JD
{
    // Name of the user able to create, drop, and manipulate tables
    public static String sUser = "XXXXX";
    public static String sPassword = "XXXXX";

    public static void main(String args[])
    throws ClassNotFoundException
    {
   
String url =  "jdbc:teradata://172.28.130.20/TMODE=TERA,DBS_PORT=1025,
+CHARSET=UTF8,LOGMECH=LDAP,SSLMODE=ALLOW";
        
        String sDropTbl = "DROP TABLE NED_COLL_TABLES.T_PM_TEST_TMP";
        String sCreateTbl = "CREATE TABLE NED_COLL_TABLES.T_PM_TEST_TM
+P (empID INTEGER NOT NULL, " +
            "empName VARCHAR(30) NOT NULL, empDept VARCHAR(50) NOT NUL
+L, " +
            "empJob VARCHAR(300), PRIMARY KEY(empID))";
    
        String sCreateIdx = "CREATE INDEX (empName) ON employee";
        String sCreateIdx2 = "CREATE UNIQUE INDEX (empName, empDept) O
+N employee";

        try
        {
            System.out.println("\n Sample T20000JD: \n");
            System.out.println(" Looking for the Teradata JDBC driver.
+.. ");
        
            Class.forName("com.teradata.jdbc.TeraDriver");
            System.out.println(" JDBC driver loaded. \n");

         
            System.out.println(" Attempting to connect to Teradata via
+" +
                               " the JDBC driver...");
           
            Connection con = DriverManager.getConnection(url, sUser, s
+Password);
            System.out.println(" User " + sUser + " connected.");
            System.out.println(" Connection to Teradata established. \
+n");

            try
            {
            
                Statement stmt = con.createStatement();
                System.out.println(" Statement object created. \n");

                try
                {
                   
                    try
                    {
                        System.out.println(" Dropping table if present
+: "
                                           + sDropTbl);
                        // Executing the drop table command
                        stmt.executeUpdate(sDropTbl);
                        System.out.println(" Table dropped.\n");
                    }
                    catch (SQLException ex)
                    {
                        

                        while (ex != null)
                        {
                           
                            System.out.println("\n Drop table exceptio
+n " +
                                               "ignored: " + ex);
                            
                            System.out.println(" Error code: "
                                               + ex.getErrorCode());
                        
                            System.out.println(" SQL State: "
                                               + ex.getSQLState());
                          
                            System.out.println(" Message: "
                                              + ex.getMessage());
                          
                            System.out.println(" Localized Message: "
                                               + ex.getLocalizedMessag
+e());

                           
                            System.out.println(" Stack Trace: ");
                            ex.printStackTrace();

                            
                            ex = ex.getNextException();
                        }

                        System.out.println(" Table could not be droppe
+d." +
                                           " Execution will continue..
+.\n");
                    }

                    
                    System.out.println(" Creating table: " + sCreateTb
+l);
                    stmt.executeUpdate(sCreateTbl);
                    System.out.println(" Sample table created. \n");
                   
                    System.out.println(" Creating table indexes: "
                                       + sCreateIdx + " " + sCreateIdx
+2);
                    stmt.executeUpdate(sCreateIdx);
                    stmt.executeUpdate(sCreateIdx2);
                    System.out.println(" Table indexes created.");
                }
                finally
                {
                   
                    stmt.close();
                    System.out.println("\n Statement object closed. \n
+");
                }
            }
            finally
            {
                
                System.out.println(" Closing connection to Teradata...
+");
                con.close();
                System.out.println(" Connection to Teradata closed. \n
+");
            }

            System.out.println(" Sample T20000JD finished. \n");
        }
        catch (SQLException ex)
        {
          
            System.out.println();
            System.out.println("*** SQLException caught ***");

            while (ex != null)
            {
                System.out.println(" Error code: " + ex.getErrorCode()
+);
                System.out.println(" SQL State: " + ex.getSQLState());
                System.out.println(" Message: " + ex.getMessage());
                ex.printStackTrace();
                System.out.println();
                ex = ex.getNextException();
            }

            throw new IllegalStateException ("Sample failed.") ;
        }
    } // End main
} // End class T20000JD
END_OF_JAVA_CODE
[download]