All Forums Connectivity
cjeanmarie 1 post Joined 08/11
29 Oct 2013
JDBC Connection from Oracle 11g Java Stored Procedure

When using a Java Stored Procedure from within the Oracle 11g database, an attempt to open a connection to Teradata using the JDBC driver version 14 throws the following error.
Exception in thread "Root Thread" java.lang.NullPointerException

at com.teradata.jdbc.jdbc_4.parcel.ClientAttributesParcel .<init>(


at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:218)

at com.teradata.jdbc.jdk14.JDK14_SQL_Connection.<init>(JD

at com.teradata.jdbc.jdbc.ConnectionFactory.constructSQLC onnection(

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(

at com.teradata.jdbc.TeraDriver.doConnect( :232)

at com.teradata.jdbc.TeraDriver.connect( 158)

at java.sql.DriverManager.getConnection(DriverManager.jav a:583)

at java.sql.DriverManager.getConnection(DriverManager.jav a:187)

at TDTest.requestPriceDetails(TDTest:12)


The connection code is:


create or replace and compile java source named "TDTest" as

  // Required class libraries.

  import java.sql.*;

  import oracle.jdbc.driver.*;

  import oracle.aurora.util.*;

  import com.teradata.jdbc.*;


  public class TDTest {

    public static int requestPriceDetails(String anchor, Integer rc, Integer sg, String upc, Integer req_id) throws SQLException {

      com.teradata.jdbc.TeraDriver td = new com.teradata.jdbc.TeraDriver();


      String tdConnectionString = "jdbc:teradata://";

      Connection tdConn = DriverManager.getConnection(tdConnectionString, "user", "password");

      return 0;




The same code works run using the Oracle JVM on the same server. Is there a parameter that needs to be passed in this JVM?



tomnolan 594 posts Joined 01/08
30 Oct 2013

First, the Oracle Database server-side JVM for Oracle Java Stored Procedures is not one of the supported environments for the Teradata JDBC Driver.
Having said that, this problem corresponds to a known issue -- JDBC DR 167176 Avoid NullPointerException at logon when System property "" is not set
We will be shipping a Teradata JDBC Driver change to address that issue soon. In the meantime, you can work around this Oracle JVM issue by setting the System property "" yourself to some value -- the actual value doesn't matter; it simply needs to be non-null.
System.setProperty("", "Oracle Database JVM");

You must sign in to leave a comment.