150 - 199 of 99 tags for jdbc


I received this error when i run the query on my app, but when i run the same query on teradata studio, it run fine. Why???
I use jdbc driver for run this query.

JDBC support has been added to teradataR version 1.0.1 which provides the ability of using the Teradata JDBC Driver through teradataR to connect to the Teradata database.  teradataR allows R users to easily connect to a Teradata database and use statistical functions directly against the Teradata system without having to extract memory into data.  For mor

Hi, I need to download version but I can't seem to find a place to get it. The latest version in Developers Exchange is .00.35 but due to support issues I can only use versions of 13.10 betweem .00.00 and 00.10
Anyone knows where should I go find those versions?

I am running queries through a JDBC driver. I am able to execute select * from DBC.AccessRights with no issue. However, when I execute "SELECT COUNT(*) FROM DBC.AccessRights" I get the following error. Any help is appreciated. I can run both queries from bteq on the server.

Hi there,

We are facing problems with the JDBC driver, when issuing (real) unicode  SQL with more then 32kb text:
Caused by: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC] [Error 3702] [SQLState HY001] Insufficient memory to parse this request.

Dear All
I have recently moved from Windows to Mac and am trying to get used to the change. At the same time I am new to Teradata and want to learn it. I have installed Teradata Studio on Mac but I am unable to create a database connection and database to start working on it. 

I have a complex Stored Procedure.
When I compile it using teradata SQL Assistant ( ODBC) it works & runs fine.
However , when I use the same piece of code and run it on Teradata Studio Express(JDBC) it doesnt.
I get the following error :

does anybody know where to download the latest JDBC drivers (4.5.1 or higher) for Aster Data?

I'm new to Teradata and Websphere Application Server(WAS). I have installed Teradata JDBC Driver 14.00 (terajdbc4.jar




I am trying to connect to TeraData from R.


RStudio v0.96 (R v2.15.1)

JDBC v14.00.00.21

JDK v1.7.0_07

Mac v10.7.4






Hi everyone,
We're trying to connect to our teradata database through Java using TMODE=ANSI, and it's throwing the following error:

I got following error in my application(Web app deploying on JBoss EAP).
It seems exception generated at "CheckValidConnectionSQL.isValidConnection", when JDBC Driver try to check validity of connection.
I checked the JDBC User guide and SET LOB_SUPPORT to OFF, but still getting the same error.
Any advice?



I'm trying to call a Teradata macro via JDBC. I'm using the following code



I have gone through JDBC documentation, but I have not found a property or any other way, how to tell jdbc to retry a query that was aborted due to a deadlock.

We are running a lot of concurrent jobs and we get sometimes a deadlock - not because of actual deadlock, but because of lock table being full on an AMP.

I execute the sql by TeraJDBC13.1, but throw the exception:



16:55:31  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 1005, SQL State: HY000]  [Teradata JDBC Driver] [TeraJDBC] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33

As per subject, really.  Got a simple query:

SELECT * FROM dbc.databases WHERE databasename != 'foo'

When I try and run it through the JDBC connection I get the error:


We are trying to do a EntityManager.MERGE operation in JPA and trying to retrieve the ID generated from the identity column but Teradata doesn't return the ID like Oracle does. is there any way of pulling the ID back from the JPA transaction.

This reference guide provides information about the Teradata JDBC Driver, which is a Teradata Tools and Utilities product. A set of Frequently Asked Questions is also available.

I am using Eclipse and Servoy (www.servoy.com) to create a CRUD application.  Using other JDBC drivers works well in Servoy but the Teradata (v14) JDBC driver does not work as well for CRUD operations.  However, the things I can do using the Teradata drivers are single SELECT statements and INSERT, DELETE

When I call

ResultSet rs = dbmd.getColumns(null, "CUSTDATA", "TRANS", null);

it takes 16 seconds to get an answer back on a fairly unloaded system.  This table has 27 columns.


This seems to be excesvily slow.  Is there anything that can be done to speed this up?


I have a couple application are are using ENCRYPTION=ON in their connection strings.  Is there any way to tell on the database side (DBQL, etc) so that I may verify that the encryption parameters are being accepted?

If I use the following connection for JDBC Trace Logging:



What is the log file location?


I am using the connection string in the following programs:

Talend Open Studio




The Teradata JDBC Driver provides both forward-only and scrollable result sets. With a forward-only result set, an application can only fetch rows in the forward direction, using the ResultSet.next method. A scrollable result set enables an application to fetch rows in any order.

In the last Teradata Data Mover (TDM) article (Executing Partial Table Copies with Teradata Data Mover), we discussed creating a TDM job to copy a subset of rows in a table between Teradata systems. This example showed how customers can avoid copying an entire table to the target system when they only want to copy recent changes made to that table. The problem with the example in that article, though, is that the where clause has a hard-coded value in it. Customers will typically want to avoid having hard-coded values in their production TDM partial copy jobs because the subset of rows they want to copy will change every time they want to execute the job. It's possible for customers to just create a new TDM job every time they want to change the where clause, but that could lead to many unnecessary jobs being created in the TDM repository that copy data from the same table. It's much more efficient to create one job that will copy a dynamic subset of rows every time it is executed. Executing the same TDM job repeatedly instead of creating a new job every time rows need to be copied from the same table will eliminate the overhead associated with creating new TDM jobs.

In the last Teradata Data Mover (TDM) article (Introduction to Teradata Data Mover: Create your first job), we discussed creating and executing a TDM job to copy a full table between Teradata systems. This use case is very common in the field when customers want to initially populate the target Teradata system with the same table that exists on the source Teradata system. Customers will not want to copy the entire table to the target system every time changes are made to the source system though. Tables on production systems can get quite large and it doesn't make sense to copy the entire table when only a subset of rows have been changed since the last copy took place. This is why TDM supports executing partial table copies as well as full table copies.

Hello, I could not find the Teradata JDBC driver user guide for TTU 13.10 nor for TTU 14.  I am specifically looking for the install steps and the variables (classpath) values that need to be set.



when I try to create a volatile table through the execution of the following SQL instruction









I am unable to connect using the following snippet of code:

drv = JDBC("com.teradata.jdbc.TeraDriver","./TeraJDBC/terajdbc4.jar")

conn = dbConnect(drv,"jdbc:teradata://db1/TMODE=ANSI,CHARSET=UTF8",user="user1",password="pswrd1",dbname="test_db")

I get the following error messages:


Has anyone else seen this? Currently if I run up a connection via the JDBC driver under a 64bit JVM of 32bit JVM under a 64bit Ubuntu I get an unexpected hang. Under a 32bit JVM on a 32bit Ubuntu install everything works fine. The really weird thing is if I run the connection thread through strace it appears to be spinning never really connecting.

Apache Ant allows the user to run a SQL task using JDBC. The Teradata SQL Ant Wizard allows you to wrap selected SQL Statements into an Ant build script from the Eclipse DTP SQL Editor.

The XML Ant build script generated from the Wizard runs the selected SQL statements inside or outside of Eclipse. The Ant build script will facilitate a consistent setup of test or base production environments. This creates a mechanism to run SQL reports and to integrate with build or schedule tools. 

I have just complete some testing with a application I have made using the JDBC teradata driver. However, when I read from my resultset it appears that I lose non standard characters such as (± ¼ »). These are typically used within xml which is what I am also retrieving from the database, and they return as question marks, with an int value of 65533.
The values themselves are correctly shown in Teradata SQL assistant.
I have also tried creating a mysql database, which I could return the same characters from successfully.

I could connect the DBS via bteq when the program was retrying to connect to TD DBS(14f.00.00.00).
But who can tell me it is an issue of c3p0 module or TeraDriver?
DEBUG com.mchange.v2.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1276] [SQLState 08S01] Exceeded login timeout for
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)

a few weeks ago I found a document how to install the JDBC driver for Coldfusion. unfortunately I deleted it from my HD and now I came back to download it again but I can't find it anymore. The Document was about the setup of JRUN and Coldfusion with JDBC driver can anybody tell me where I can find it again.

Many Thanks in advanced

We are using webMethods for certain near real-time ETL feeds into our Teradata system. This tool uses JDBC to connect to the Teradata system and issue single row DML operations. In working with the webMethods development team, we asked if it was possible to batch multiple transations into a single commit statement. The answer we received was that the JDBC adapter being used does not support mass updates without using a stored procedure.

I have a Talend job that is using JDBC to connect to Teradata. I think the driver being used is and I know the Teradata system I am connecting to is

I think only the top most generic error message is being passed from the Teradata driver to Talend for all errors that are being returned:

[Teradata JDBC Driver] [TeraJDBC] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.


I need to get the following information of all table indices of a table with the JDBC 'getIndexInfo()' method
to be able to create a similar table but with modified indices.

- The index number
- The index column name of the index number
- The index column position of the index number
- The unique index flag of the index number
- Primary or Secondary index flag of the index number

The first 4 are returned nicely by the 'getIndexInfo()' method.

But I'cant see any information returned by the 'getIndexInfo()' method that
looks like a 'Primary or Secondary Index' flag.

I noticed that the statement.executeUpdate() method returns int data type , which conforms to JDBC standard. However, here is the question: it is Teradata!!! the affected row count can easily blow away the integer range. How to deal with such issue?

We are using the PooledConnections using V13 versions of the JDBC driver and have noticed that the volatile tables seem to stay even when we call the close method on the connection.

TeraConnectionPoolDataSource dataSource = new TeraConnectionPoolDataSource();
.. do connection
PooledConnection pc = dataSource.getPooledConnection();
Connection conn= pc.getConnection();
Statetment st= conn.createStatement();
st.execute( Create volatile table);
.. execute somemore inserts and selects
conn.close(); // AT ths point the volatile table should go away.

But if we do

Teradata Data Mover (TDM) is a relatively new product that allows users to copy database objects, such as tables and statistics, from one Teradata Database system to another. TDM can copy join/hash indexes, journals, and triggers as well.


Can I redistribute the JDBC jar files with an application? Or must I have the user get that on their own?

I remember reading about this topic somewhere, but search leads me nowhere.


I tried to issue the query banding statement along with my SQL query in a single transaction, like:
SET QUERY_BAND='AppName=B;'FOR Session;SELECT ....

This ran successfully in the Teradata SQL Assistant but not in Teradata Administrator as well as not in my application which uses JDBC connection via Teradata's JDBC driver.

I am a developer and a newbie to teradata.

I am trying to load a large table from my oracle database to teradata 13.0.

I have written a JDBC utility to fetch from my Oracle Instance and Load into teradata database.

The oracle table has 4 CLOB columns (it is a125 columns table) and has 100000 + rows.
My program errors out after inserting 84422 records with the following error:

Exception in thread "main" com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC] [Error 8505] [SQLState HY000] LOB ID could not be generated

The Teradata JDBC Driver and ODBC Driver allow developers to quickly build applications that interact with the Teradata Database. However, many developers are surprised when their fully functioning application suddenly hits a performance roadblock when it is deployed to their production environment.

This package provides examples of programs that can be used as a guide for purposes of developing JDBC applications solely for use with the Teradata Database, and is provided as an illustration of how JDBC functions operate with the Teradata Database.

Download the Teradata JDBC Driver This release of the JDBC driver is backwards compatible with previous releases back to Teradata Database V2R6.0.

The objective of this article is to explain step by step how to improve Talend in Teradata environment using Teradata utilities (FastLoad, MultiLoad).