#DateForumTypeThreadPost
6904 Aug 2011 @ 10:12 PDTDatabaseReplyIs there a "reserved words" table/view?Teradata Database 13.10 introduced the SYSLIB.SQLRestrictedWords view.
6820 Jul 2011 @ 03:07 PDTConnectivityReplyCannot deploy JDBC driver to WebLogic 10.3.4We are still in the process of moving content over from the old Download Center to here on Developer Exchange. In the meantime, you can open an incident with Customer Support and request the app...
6729 Jun 2011 @ 11:05 PDTConnectivityReplyTERADATA SQL ERROR 3945: Invalid data length for VarChar, VarByte, orVARGRAPHIC while using JDBC connectionI recommend that you open an incident with Customer Support, because this is likely to be too complex to troubleshoot here on Developer Exchange. You will need to enable the LOG=DEBUG connection...
6627 Jun 2011 @ 08:29 PDTConnectivityReplyTeraEncrypt: Error - JDBC 13 Exception when connecting to Teradata 12 Database That's going to be too complicated to troubleshoot here on Developer Exchange. Instead, please open an incident with Customer Support. Thanks, --Tom
6531 May 2011 @ 09:39 PDTConnectivityReplyJDBC - MultiStatement with the "execute" methodWhen your application uses the Statement/PreparedStatement execute method to execute a multi-statement request, the Teradata JDBC Driver sends the entire multi-statement request to the Teradata Dat...
6431 May 2011 @ 09:32 PDTConnectivityReplyCould you tell me the reason why login time out? >>> Could you tell me the reason why login time out? By default, there is no login timeout for the Teradata JDBC Driver. The exception you listed "Exceeded login timeout" occurs when you spec...
6323 May 2011 @ 10:02 PDTConnectivityReplyExecuteUpdate -- -row count return type is int>>> I would have thought that I should have gotten an exception when i tried to createStatement() & specifically requested the SCROLL_INSENSITIVE... shouldn't have said -- "Lob_support not on, scro...
6218 May 2011 @ 10:51 PDTThird Party SoftwareReplyColdfusion and TeraData JDBC DocumentationSorry about that. We are still in the process of moving content over from the old Download Center to here on Developer Exchange. If you're a customer and you need the document right away, you ca...
6118 May 2011 @ 10:41 PDTConnectivityReplyExecuteUpdate -- -row count return type is intFor a DML statement that does not return rows, such as an INSERT, UPDATE, or DELETE statement, the Teradata "activity count" is the same concept as the JDBC API "update count". You can retrieve the...
6016 May 2011 @ 09:34 PDTConnectivityReplyThreads hanging permanently on Teradata requestsIn the stack traces you listed, the Teradata JDBC Driver is waiting for a response from the Teradata Database. If the problem is reproducible, then I recommend that you open an incident with Cus...
5912 May 2011 @ 09:50 PDTThird Party SoftwareReplyJDeveloper Error "Table qualifiers not supported by data source"You're not using the Teradata JDBC Driver; you're actually using the JDBC-ODBC bridge with the Teradata ODBC Driver. Notice that the first line of the exception stack trace includes "[ODBC Terad...
5811 May 2011 @ 02:58 PDTThird Party SoftwareReplyJDBC Driver and mass updateThe Teradata JDBC Driver, and the Teradata Database, have supported JDBC PreparedStatement batches for several years, beginning with Teradata JDBC Driver 03.02.00.00 and Teradata Database V2R6.0, w...
5729 Apr 2011 @ 01:18 PDTDatabaseReplyStored Procedure support in Teradata 14I haven't heard anything to suggest that rumor is true.
5614 Apr 2011 @ 10:05 PDTDatabaseReplyTeradata JDBC Driver Error - Error 1338>>> I think the driver being used is 13.00.00.27 No, the exception message indicates that you are using Teradata JDBC Driver version 13.00.00.16. >>> Shouldn’t the 13.0 driver be backward...
5513 Apr 2011 @ 01:27 PDTConnectivityReplyLogin failure for Packet transmitPlease post the complete stack trace. Thanks, --Tom
5411 Apr 2011 @ 11:07 PDTConnectivityReplyproblem with jdbc/dialectPlease post the complete stack trace. Thanks, --Tom
5331 Mar 2011 @ 10:19 PDTDatabaseReplyTable metadata inspectionThe short answer is that you should use what works best for your application. The Teradata JDBC Driver implements the DatabaseMetaData methods by querying the Data Dictionary views, and in some ...
5223 Mar 2011 @ 09:25 PDTDatabaseReplyThe size of Prepared Statement objectAre you asking about a PreparedStatement object created by the Teradata JDBC Driver?
5117 Mar 2011 @ 12:17 PDTToolsReplyERROR ~ [Teradata DBMS] : Response limit exceeded.Here's a different link for the Teradata JDBC Driver User Guide: http://www.info.teradata.com/templates/eSrchResults.cfm?txtttlkywrd=CJDBC&rdsort=Title Regarding your SQLException "Data size ...
5017 Mar 2011 @ 12:07 PDTConnectivityReplyJDBC 'getIndexInfo()' method return data lacks 'is Primary Index' flag?DatabaseMetaData.getIndexInfo is a vendor-neutral API, so the Teradata JDBC Driver is limited in terms of the information that we can provide. A "primary index" is a Teradata-specific concept, a...
4904 Mar 2011 @ 11:02 PSTConnectivityReplyTeradata JDBC Exception Those error messages typically indicate that the Teradata JDBC Driver has lost its connection to the Teradata Database. Common causes of connectivity problems, in order from most likely to less ...
4814 Feb 2011 @ 12:57 PSTConnectivityReplyExecuteUpdate -- -row count return type is intThe Teradata Database handles this issue. Here is the relevant excerpt from the Teradata Database Messages manual, for code 6813: 6813 Numeric overflow in internal counters. The number of row...
4718 Jan 2011 @ 01:20 PSTConnectivityReplyjdbc 3749 errorTeradata Database V2R5.0 is very old. You should use a newer demo version of the Teradata Database. There is a known problem with V2R5.0 returning Error 3749 "Options Parcel information is inval...
4617 Jan 2011 @ 12:59 PSTConnectivityReplyjdbc 3749 errorWhich version of the Teradata Database are you using?
4506 Jan 2011 @ 10:26 PSTConnectivityReplyConnection.createStatement fails to use ResultSet type informationScrollable result sets' depending on LOB support is true for both PreparedStatement objects and regular non-prepared Statement objects. (And also true for CallableStatement objects.) I just test...

Pages