#DateForumTypeThreadPost
51911 Feb 2016 @ 10:38 PSTConnectivityReplyTeradata login timeoutBy default, there is no login timeout for the Teradata JDBC Driver.   That exception occurs when you specify a non-zero login timeout using the either the DriverManager.setLoginTimeout metho...
51803 Feb 2016 @ 12:03 PSTConnectivityReplytd wallet for jdbcIt is still the case that, at the present time, there is no interoperability between Teradata Wallet and the Teradata JDBC Driver.   We are in the planning stage for a new Teradata JDBC Driv...
51701 Feb 2016 @ 06:58 PSTConnectivityReplyCould you tell me the reason why login time out? As I said in my earlier post, by default, there is no login timeout for the Teradata JDBC Driver. A login timeout only occurs when your application (or application server) specifies a non-zero logi...
51626 Jan 2016 @ 06:56 PSTConnectivityReplyTeradata connectivity Issue through JDBC Driver in javaWhen you use the DriverManager.getConnection(String url, Properties) method, the only properties that are supported in the Properties object are "username" and "password". Since...
51525 Jan 2016 @ 06:57 PSTToolsReply Why USEXVIEWS=ON parameter has no effect on Teradata Studio ?USEXVIEWS is a Teradata JDBC Driver connection parameter, rather than a Teradata Studio setting. When you specify the USEXVIEWS=ON connection parameter, the Teradata JDBC Driver's DatabaseMetaD...
51420 Jan 2016 @ 11:02 PSTDatabaseReplySQL Question about use of LEFT, RIGHT and SUBSTR functions>>> (JDBC?)  driver might rewrite them to vaild TD syntax   Since TTU 8.1 (over 10 years ago), the Teradata JDBC Driver only replaces JDBC escape syntax inside curly braces { }...
51319 Jan 2016 @ 11:14 PSTConnectivityReplyGET METADATA FROM JDBC DRIVER (Query NOT performant)JDBC RFC 161165 shipped to Teradata JDBC Driver 15.00.00.28 and Teradata JDBC Driver 15.10.00.07 on July 2, 2015.   However, it's common for database names, table names, and column names...
51212 Jan 2016 @ 01:46 PSTConnectivityReplyCannot connect from oracle database to teradata databaseI assigned an engineer from my team to investigate your incident.
51112 Jan 2016 @ 10:00 PSTConnectivityReplyCannot connect from oracle database to teradata databaseIn the past, we have seen that type of exception occur due to outdated Java Cryptography Extension (JCE) libraries being present in the JVM.   This problem is too complex to troubleshoot via...
51005 Jan 2016 @ 02:02 PSTDatabaseReplyDatabase column size using JDBC getMetdata The ResultSetMetaData.getColumnDisplaySize method returns the maximum number of characters needed to display the designated column's values in character form. It should provide a fairly good ap...
50918 Dec 2015 @ 06:57 PSTConnectivityReplyhow to provide password encryptions in JDBC connections>>> if we need to set up application specific realms   No, application-specific realms are not required for Kerberos.
50816 Dec 2015 @ 01:59 PSTConnectivityReplyhow to provide password encryptions in JDBC connections>>> we understand SSO and TDWALLET isn't supported for this route of Teradata conenctions.   Single Sign-On (SSO) is supported with Kerberos authentication. Please refer to the ...
50703 Dec 2015 @ 06:50 PSTExtensibilityReplyJava interface to TPT OPERATORSMy post above remains accurate.
50619 Nov 2015 @ 09:28 PSTDatabaseReplyTeradata Syntax ReferenceAll the Teradata Database documentation is available online and for download.   Teradata Database 14.0 documentation in HTML is available here: http://www.info.teradata.com/HTMLPubs/DB_TTU_...
50512 Nov 2015 @ 09:24 PSTDatabaseReplyconnecting from teradata 13.10 to teradata 15 version databaseYou can test that combination, but keep in mind, that if you encounter a problem while using an unsupported software combination, you would be asked to upgrade to a newer software version.
50410 Nov 2015 @ 09:27 PSTConnectivityReplyTeradata connection Error@crwirz, it looks like you are running on some version of Windows. Please provide additional information: - the complete stack trace - the Microsoft Windows version - the Teradata JDBC Driver...
50305 Nov 2015 @ 11:35 PSTGeneralReplyTeradata Querydsl distinct limit query.GROUP BY produces distinct values, and works with TOP n.   select top 1000 ts.Gender from table ts group by ts.Gender order by ts.Gender asc
50204 Nov 2015 @ 12:28 PSTGeneralReplyTeradata Querydsl distinct limit query.Your problem is due to ordering by Gender in the qualify clause.   You would need to use a different order-by column in the qualify clause; specifically, something like an ID or LastName col...
50102 Nov 2015 @ 12:07 PSTGeneralReplyTeradata CIM - Supported BrowsersHere is the answer that I received from the CIM team:   IE 11 support starts with CIM 7.1 and will continue to be supported with our next release of CIM ... With each Major/Minor releas...
50030 Oct 2015 @ 06:57 PDTDatabaseReplyconnecting from teradata 13.10 to teradata 15 version databaseYou are asking about using TTU 13.10 client software to access Teradata Database 15.0. In our terminology, you are asking about "forward 3" compatibility.   I believe that the Tera...
49929 Oct 2015 @ 01:14 PDTDatabaseReplyDrop DatabasesA database must be empty before it can be dropped. The "delete database" command drops everything in a database. So dropping a database is a two-step process: delete database Ol...
49821 Oct 2015 @ 01:03 PDTGeneralReplyTeradata CIM - Supported BrowsersI do not work on the Teradata CIM product, but I will try to track down this info for you. It may take me a while.
49716 Oct 2015 @ 06:47 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"You must design your application to handle the error condition when a row, or rows, cannot be inserted. Logging the failed rows to a file is just a suggestion. If the data is important, then y...
49615 Oct 2015 @ 09:42 PDTDatabaseReplyFaled to invoke PreparedStatement executeUpdate methodSumit, this is a duplicate post, and you should have posted this question as a new forum thread. Please do not "necro" old threads from 3 years ago.   The Teradata JDBC Driver User...
49515 Oct 2015 @ 09:42 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"Sumit, this is a duplicate post, and you should have posted this question as a new forum thread. Please do not "necro" old threads from 2 years ago.   The Teradata JDBC Driver...

Pages