"not working" is exceptionally vague. That's very specific to your environment Java code that we won't be able to test, so you must explain to us exactly what you expect to happen, and more importantly, what problems are occurring, including error messages.

Also, the post will be much easier to follow if you remove all of the commented lines.

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:

  main::java::lang::ClassNotFoundException=HASH(0x33f4400)

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". ;-)

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]

I don't get why you even want to do this with Java at all.

The code is just dropping a table if it exists but methinks most modern databases have a nice feature whereas you can say,

DROP table xzy IF EXISTS ...

I don't know if your db has such a feature but I would check. This makes it so you can avoid all of the error handling stuff.

Next, the code just creates a table. Pardon me for stating the obvious but this reads a lot like, "hey, somebody said I had to use Perl but since I hate to learn new stuff I'm just gonna wrap my Java stuff..."

If so that is sad. Perl has much more to offer you in exchange for minimal effort.

This code isn't my end goal. This code was only being used as a test script. If successful, I was going to move to more complex scripts.

See also

FYI, you don't need to write [href://http://..., you can just put [http://.... TIA.

According to the docs the syntax is right. - href only does not work.

«The Crux of the Biscuit is the Apostrophe»

Any ideas or suggestions would be appreciated

Don't use Java for this...
Instead, use the very capable DBI module.

I'm genuinely curious why you are trying to do this in this way...

I was having issues getting the DBI module to work with JDBC and Teradata. I thought that Java could be used as alternative.

According to this source, there is a Teradata DBI driver that "is now a standalone XS module; Inline::C no longer required"

is this failing? can it be found? Also, does the program fails at compilation or runtime?

Edit: It looks there is at least 1 Perl DB Driver Module (very old) on CPAN offering connection to Teradata. There is another deprecated offering a newer version outside CPAN. I would investigate this route rather than inling all code to JAVA. Limited mileage but the first thing to investigate.

Edit: note to fellow monks: teradata db access needs a proprietary driver just as mysql, sqlite et al. do. The only hope on this front is if Teradata::SQL can be made to work.

teradata db access needs a proprietary driver just as mysql, sqlite et al. do.

I'm not sure what you mean by this. Both MySQL and SQLite can be accessed perfectly well using open drivers - no requirement for proprietary ones.

---

🦛

I mean Perl's DBD/DBI will not provide access to a database without the driver, any driver, opensource or otherwise. 'proprietary' is the wrong word, I mean supplied externally.