Hi all,
I would like to perform query banding at the connection level.  We are trying to track down a blocking issue, across a couple hundred, that are all hitting a single metadata table.  A few are not playing nice and we would like to use query banding to narrow it down.
 

I'm running an Apache Spark application that uses terajdbc4 to fetch data from a Teradata server.  It seems to be returning the wrong value for the nullability for many of the columns in the table.  I've found two scenarios at work:

I wrote a Java stored procedure, packed it into a jar and installed it into the Teradata database. I want to use the default database connection as described here [1]. Most of the code was generated by the Teradata wizard for stored procedures.
 

Keep getting this INFO Level Log in my Glassfish Application Server.
Some research show me that this behavior is related to a method called getClientInfoProperties() when this method is not fully implemented.

I am not sure if the database forum is the right place for this topic, but it might be.

Hi,
I am trying to read data from Teradata DB in a MapReduce job using the JDBC Driver. I get the following exception/stack trace:
 
Provided connection string: jdbc:teradata://teradata/database=dbname
 

java.lang.ExceptionInInitializerError: null

My company is running an R-Studio Server Pro on a Red Hat Linix 6 platform (64bit) and a Teradata 14 RDBMS. When trying to connect via RJDBC, I get an error that seems to be well known in the forums, but the standard recipes for resolving the issues don't help. Here is how I connect to the Teradata DB:

Hi,
we have a jdbc data source configured in sap netweaver java server,which connects to Teradata(13.10.07.28). the jdbc driver version is 15.00.00.20.
we have an ejb consuming that data source.
the java server is running on windows.

How do I turn off TITLEDASHES when using Teradata JDBC driver?

I'm building my firsh Java application using Teradata as the backend database. I would like to impliment an auto refresh feature, that would monitor a table in the database for changes and refresh the tableview I have in the application. I know TMM has an auto refresh. Does anyone know how this is accomplished?
Thanks for the help in advanced!

Hi All,

Request you all to please help me on connecting my Td SQL Assistant.

I have Windows 8 64 bit Laptop and have successfully installed Vmware Player with TDExpress14.0.3_Sles10_4GB.

I am able to connect bteq but I want to connect to TD Sql Assistant which i think needs an ODBC Driver.

Hi all,
   I need to get data from users from a webpage (jsp) and connect to a teradata database and load them into the tables in the database. I am using jsp to create the webpage. Is it possible to directly connect to the teradata database by scripting in jsp?. If so, some guidance will be appreciated. Thank you

Hi,
 
I am using the following code to read clob data from teradata. 

I am connecting to Teradata via JDBC and LDAP using the following URL format:
jdbc:teradata://myserver/LOGMECH=LDAP,LOGDATA=username@@password

Hi,
I am using JDBC FastLoad to transfer data between different teradata environments.
I have been hitting an error message:

Hi,
 
I am trying to export data from hdfs to teradata using teradata connector cli version 1.3. I am contsantly hit with below error while executing in batchinsert mode. 

Hi,
I new with Teradata and I will try to connect TD DB with JDBC. When I try a specific request I get an SQLException with the message :

Is this possible? I see in the FastLoadCSV docs that you can specify other field separators besides comma.

Hi Team,
 
I am getting following exception while calling setSavePoint of Connection interface. 
 
SavePoint currentSavepoint = connection.setSavepoint("BatchSavePoint");
 

Hi,
              I have a table that has 80,000 records i have to read all data and I cannot filter records. It takes over 90 seconds. This is way too slow. I tried with setFetchSize of 50,100,1000,10000. Nothing helped.
     Connection conn = getJdbcTemplate().getDataSource().getConnection();

    conn.setAutoCommit(false);

I have a teradata database name that contains a dash character -.
Searched the web but in vain. Does somebody know how can you escape the special characters in jdbc connection string? The string looks as follows:
"jdbc:teradata://HostName/DATABASE=Database-Name"

Hello all ,
Thank you for reading this .
I pull data from oracle to teradata using a PreparedStatement batch request and some data are the same .
So when I execute preparedStatement.executeBatch() method , I catch an Exception which is Duplicate row error in perf.TB_C_TMP and 
the program exits on error .

Hi, I'm an end user, mainly running queries on our database and using reporting services.

Hello all,
 
Thanks in advance for reading this.  
 
I am trying to pull data from Teradata and load it into MySQL without hitting the disk.  
 
I am currently doing it with a perl script and connecting BTEQ to LOAD DATA INFILE with a named pipe in linux.  
 

Hello @ll,

I'm new on Teradata and I'm facing some troubles trying to connect to a TD12 using Teradata Studio 14.
I have this error:

hi,
I have a table with same column title(not the column names), runing a SQL on it from Java is returing same values for both the columns, it is because of same column title, but same SQL in SQL Assitant returns correct values, where can i find and confirm if same title is reason. is there a driver documentation which states this behaviour.

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

HI ALL:
              I am trying to call Graphgen funtion with jdbc, it seems not work.but it works in Teradata sql assistant.
             Any one can help?  Thanks!!!

Hi,
 
I just installed Teradata Express 13 VMWare instance. Everything installed and works fine, except I am unable to connect to the dbc database via a Teradata 13 JDBC driver. The URL supplied is:  "jdbc:teradata://localhost/DBS_PORT=1025,DATABASE=dbc,CHARSET=UTF8".
Please advise?
 
Thanks... Vince
 

Has anyone had any luck installing the TeraData JDBC drivers on WebLogic 12c?  Are Teradata JDBC drivers supported in WebLogic 12c?

Is there a list of error codes (and the associated messages) of all the SQLExceptions that the Teradata JDBC driver throws? I can't find it anywhere in the documentation...
Thanks,
Jan
 

Hi,
 
i am trying to connect to Teradata using JDBC from my Linux server using Pentaho and i get the following error.
can you please help
GSSException: Failure unspecified at GSS-API level (Mechanism level: UserFile parameter null)
        at com.teradata.tdgss.jtdgss.TdgssParseXml.<init>(Unknown Source)

Hi,
 trying to use Aster JDBC driver to query database tables & columns.

I apologize if this is a repeat topic, I tried to search through the forums here and found nothing useful about this topic.