0 - 50 of 99 tags for jdbc

Pages

The Teradata JDBC Driver enables Java applications to connect to the Teradata Database.

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:

This package contains the Aster client tools for Windows.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for Solaris.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for MacOS.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for Linux.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for AIX.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

The RJDBC package enables an R application to use the Teradata JDBC Driver to access the Teradata Database.

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:

Use the following links to obtain the Aster Client tools for your platform :

( Windows | Linux | Solaris | AIX | Mac )

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!

The Teradata JDBC Driver Engineering team receives a lot of questions about what happens when a JDBC connection is created. Let's clarify the concepts Laddered Concurrent Connect (LCC) versus COP Discovery versus logon, and review what the Teradata JDBC Driver does to create a JDBC connection.

 

First, some definitions...

Beginning with Teradata Database 14.0 and Teradata JDBC Driver 13.10.00.21, the Client Attributes feature records a variety of information about the client system and client software in the system tables DBC.SessionTbl and DBC.EventLog.

 

 

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.

The following batches 5 rows of data, 2 of them with errors. The JDBC FastLoad PreparedStatement.executeBatch attempts to INSERT the batched rows into a database table but throws a JDBC SQLException. Here is how to capture the chain of JDBC FastLoad SQLException messages and stack trace from JDBC FastLoad PreparedStatement.executeBatch and the chain of JDBC FastLoad SQLWarning messages and stack trace from JDBC FastLoad Connection.rollback:

The following batches 5 rows of data, 2 of them with errors. The JDBC PreparedStatement.executeBatch attempts to INSERT the batched rows into a database table but throws a JDBC SQLException. Here is how to capture the chain of JDBC SQLException error messages and stack trace:

JDBC Connection parameter LOG=DEBUG prints error, timing, informational, and debug messages to Java System.out. The following shows how the messages can be captured with R.

The implementation of dbConnect in RJDBC version 0.1-5 thru 0.2-2 (http://www.rforge.net/RJDBC/news.html) erroneously creates two (duplicate) connections. The RJDBC version currently in use can be obtained by entering citation("RJDBC") at the R command prompt.

The following shows how to select rows from a database table using JDBC FastExport, which only works with JDBC PreparedStatement.

The following shows how to batch 2 rows of data, then invoke JDBC PreparedStatement.executeBatch to INSERT them into a database table.

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.