369 | 15 Sep 2014 @ 12:56 PDT | General | Reply | Problem when iterating jdbc resultSet | Thank you for reporting this problem! This appears to be a Teradata Database problem, and DBS DR 173418 has been created to cover this issue.
|
368 | 10 Sep 2014 @ 10:07 PDT | Database | Reply | How can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's | Unity Source Link is our product to enable access to an Oracle database from a Teradata Database.
http://developer.teradata.com/database/reference/unity-source-link-scenario
http://www.info.terad... |
367 | 05 Sep 2014 @ 06:43 PDT | Database | Reply | Help with macro | I agree with Dieter.
You need to use the right tool for the job. If you need to vary your WHERE-clause conditions significantly, then a macro isn't the right choice for you.
I... |
366 | 04 Sep 2014 @ 09:47 PDT | Database | Reply | Error: "3927: Response Parcel requested a max byte count less than 256" | That problem is likely to be too difficult to troubleshoot on this forum. We would need to examine the Teradata JDBC Driver debug log in order to determine what is occurring.
If you are a ... |
365 | 03 Sep 2014 @ 12:47 PDT | Database | Reply | errors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]" | >>> After every batch, 1001 errors are printed: one with code 1338, others with 1339.
My guess is that the first exception has error code 1338, and 999 of the following have ... |
364 | 29 Aug 2014 @ 10:52 PDT | Connectivity | Reply | JDBC Connection to Teradta 14 best practices for high volumn. | Deadlock would not be caused by failing to close a session.
Deadlock is caused by lock contention; specifically, two or more sessions attempting to acquire locks that other sessions hold.
... |
363 | 26 Aug 2014 @ 06:46 PDT | General | Reply | Using Liquibase | I have never used Liquibase, but the error message indicates that the JDBC URL is incorrect.
Your error message shows a period (.) between "jdbc" and "teradata", but that is in... |
362 | 26 Aug 2014 @ 06:42 PDT | Connectivity | Reply | JDBC FastLoad - error 3737 | That restriction is documented in the Teradata JDBC Driver Reference (available here on Developer Exchange).
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.... |
361 | 18 Aug 2014 @ 06:45 PDT | Connectivity | Reply | Setting up JDBC Driver for Teradata Database on Vmware and Cognos | There is no need to set up the Teradata JDBC Driver within the Teradata Database.
This IBM web page discusses how to set up the Teradata JDBC Driver for use with Cognos:
http://www-01.ibm... |
360 | 04 Aug 2014 @ 06:55 PDT | Connectivity | Reply | Handling Large volume of data thru JDBC connection | Many customers succesfully use JDBC FastLoad to insert millions of rows into an empty table.
Regarding your question: "we will also be running multiple instances of this Java applicat... |
359 | 30 Jul 2014 @ 11:02 PDT | Viewpoint | Reply | How can users abort their own queries without being able to abort anyone else's? | Regarding this:
I tried using Statement.cancel() from JDBC API, but it works when server receives signal, Most of times it takes longer(minutes) to cancel.
Please keep in mind th... |
358 | 29 Jul 2014 @ 07:05 PDT | Database | Reply | Identify Set - Multiset Tables in TD 14 | As Raja noted, you can change the default session mode in dbscontrol from Teradata to ANSI. That is dbscontrol General setting number 8.
A couple of things to be aware of...
You h... |
357 | 29 Jul 2014 @ 06:57 PDT | Database | Reply | 9804: Response Row Size/Constant Row Size overflow | Here is the relevant section from the Teradata Database Reference / Messages manual:
The response row is limited to two 64k fields generated by the projection list and the order by clause.... |
356 | 22 Jul 2014 @ 07:00 PDT | Connectivity | Reply | Teradata jdbc driver upgrade from 13.00.00.07 to 15.00.00.15 | Regarding #1, the Teradata JDBC Driver Reference (here on Developer Exchange) contains a "What's New" section that lists the new features of each release. You can find the major diffe... |
355 | 15 Jul 2014 @ 06:48 PDT | Database | Reply | User-generated transaction ABORT - while reading the data from JDBC driver | The Teradata Database returns Error 3514 when the application executes the ABORT command (in TERA mode) or the ROLLBACK command (in ANSI mode).
When the application calls the Teradata JDBC... |
354 | 14 Jul 2014 @ 06:47 PDT | Teradata Studio | Reply | How Do You Create A Teradata Database? | The important part of the exception message is: UnknownHostException: testDatabase
which means that you specified "testDatabase" as your Teradata Database hostname, which is not ... |
353 | 25 Jun 2014 @ 02:34 PDT | Teradata Applications | Reply | Is anyone actual using Unity Source Link to read Oracle from Teradata? | @Joe said "Unity Source Link seems like just the thing to get us out of the ETL business"
Whether Unity Source Link provides adequate performance for your use cases would depend ... |
352 | 24 Jun 2014 @ 06:45 PDT | Extensibility | Reply | Teradata R - create table based on a data frame using JDBC | Error 3932 is a Teradata Database error, not a Teradata JDBC Driver problem.
Please read Andreas Marek's blog for information about how to use the Teradata JDBC Driver with R.
http://... |
351 | 19 Jun 2014 @ 06:50 PDT | Connectivity | Reply | JDBC Fastload Error Tables | No, JDBC FastLoad does not enable the application to choose the database name for the error tables. JDBC FastLoad uses the same database name for the error tables as for the destination table.
|
350 | 18 Jun 2014 @ 09:43 PDT | Database | Reply | Problem with ANSI TIME type and ODBC driver | >>> 13.10 Teradata with 13.10 odbc drivers, 14.00 Teradata with 14.00 drivers
The TTU software version doesn't need to exactly match the Teradata Database software version. Mo... |
349 | 18 Jun 2014 @ 09:35 PDT | Connectivity | Reply | Pulling "SHOW VIEW" data using JDBC | The SHOW command output result set can contain mulitple rows. Are you calling the ResultSet.next method to fetch all the rows returned by the Teradata Database?
The SHOW command output res... |
348 | 05 Jun 2014 @ 10:05 PDT | Database | Reply | Parameter Values in SYSLIB.AbortSessions | First, please keep in mind that I simply copy-and-pasted the documentation from the Teradata Database Reference. I did not compose that text myself.
But to answer your question...
... |
347 | 04 Jun 2014 @ 06:58 PDT | General | Reply | Performance Implication | Working with Unicode character data is slightly slower than working with Latin character data. If you are considering changing one or more columns of character data from Latin to Unicode, it would ... |
346 | 04 Jun 2014 @ 06:54 PDT | Database | Reply | Parameter Values in SYSLIB.AbortSessions | The SYSLIB.AbortSessions function is documented in the Teradata Database Reference book "Application Programming Reference" Chapter 4 "System PMPC APIs".
The fifth para... |
345 | 27 May 2014 @ 10:35 PDT | Connectivity | Reply | XA supported JDBC driver | No, the Teradata Database does not support XA at the present time. This corresponds to DBS RFC 106514 "provide XA support".
If you are a customer, then please create a customer inci... |