#DateForumTypeThreadPost
36915 Sep 2014 @ 12:56 PDTGeneralReplyProblem when iterating jdbc resultSetThank you for reporting this problem! This appears to be a Teradata Database problem, and DBS DR 173418 has been created to cover this issue.
36810 Sep 2014 @ 10:07 PDTDatabaseReplyHow 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...
36705 Sep 2014 @ 06:43 PDTDatabaseReplyHelp with macroI 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...
36604 Sep 2014 @ 09:47 PDTDatabaseReplyError: "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 ...
36503 Sep 2014 @ 12:47 PDTDatabaseReplyerrors "[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 ...
36429 Aug 2014 @ 10:52 PDTConnectivityReplyJDBC 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. ...
36326 Aug 2014 @ 06:46 PDTGeneralReplyUsing LiquibaseI 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...
36226 Aug 2014 @ 06:42 PDTConnectivityReplyJDBC FastLoad - error 3737That 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....
36118 Aug 2014 @ 06:45 PDTConnectivityReplySetting up JDBC Driver for Teradata Database on Vmware and CognosThere 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...
36004 Aug 2014 @ 06:55 PDTConnectivityReplyHandling Large volume of data thru JDBC connectionMany 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...
35930 Jul 2014 @ 11:02 PDTViewpointReplyHow 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...
35829 Jul 2014 @ 07:05 PDTDatabaseReplyIdentify Set - Multiset Tables in TD 14As 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...
35729 Jul 2014 @ 06:57 PDTDatabaseReply9804: Response Row Size/Constant Row Size overflowHere 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....
35622 Jul 2014 @ 07:00 PDTConnectivityReplyTeradata jdbc driver upgrade from 13.00.00.07 to 15.00.00.15Regarding #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...
35515 Jul 2014 @ 06:48 PDTDatabaseReplyUser-generated transaction ABORT - while reading the data from JDBC driverThe 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...
35414 Jul 2014 @ 06:47 PDTTeradata StudioReplyHow 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 ...
35325 Jun 2014 @ 02:34 PDTTeradata ApplicationsReplyIs 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 ...
35224 Jun 2014 @ 06:45 PDTExtensibilityReplyTeradata R - create table based on a data frame using JDBCError 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://...
35119 Jun 2014 @ 06:50 PDTConnectivityReplyJDBC Fastload Error TablesNo, 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.
35018 Jun 2014 @ 09:43 PDTDatabaseReplyProblem 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...
34918 Jun 2014 @ 09:35 PDTConnectivityReplyPulling "SHOW VIEW" data using JDBCThe 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...
34805 Jun 2014 @ 10:05 PDTDatabaseReplyParameter Values in SYSLIB.AbortSessionsFirst, 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...   ...
34704 Jun 2014 @ 06:58 PDTGeneralReplyPerformance ImplicationWorking 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 ...
34604 Jun 2014 @ 06:54 PDTDatabaseReplyParameter Values in SYSLIB.AbortSessionsThe SYSLIB.AbortSessions function is documented in the Teradata Database Reference book "Application Programming Reference" Chapter 4 "System PMPC APIs".   The fifth para...
34527 May 2014 @ 10:35 PDTConnectivityReplyXA supported JDBC driverNo, 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...

Pages