#DateWhereItemComment
2116 Dec 2015 @ 01:40 PSTToolsIntroducing Teradata WalletMany Java applications such as Eclipse (which Teradata Studio is based on), and many commercial application servers such as WebSphere and WebLogic, provide an encrypted password store for JDBC...
2030 Nov 2015 @ 09:51 PSTToolsIntroducing Teradata WalletWe plan to introduce a password encryption feature for the Teradata JDBC Driver.   Initially, it will be a separate feature from Teradata Wallet. They may interoperate at some point in ...
1930 Nov 2015 @ 09:40 PSTToolsCreating a Simple Java User Defined Function using the Teradata Plug-in for EclipseYour EXTERNAL NAME clause is incorrect. You specified the second parameter as "java.lang.int", which cannot be correct.   Please post the method signature for the ExtractValue.extr...
1827 Aug 2015 @ 01:24 PDTConnectivityHow to use the Teradata JDBC Driver with teradataRThis blog entry by Andreas illustrates how to call JDBC API methods directly. https://developer.teradata.com/blog/amarek/2013/12/how-to-avoid-duplicate-jdbc-connection-created-by-rjdbc-dbconnect ...
1720 Jul 2015 @ 02:58 PDTConnectivitySpeed up your JDBC/ODBC applicationsError 9128, and its remedies, was discussed in another thread: https://forums.teradata.com/forum/database/failure-9128-the-transaction-exceeded-the-maximum-number-of-rowhash-locks-allowed   ...
1609 Jul 2015 @ 06:42 PDTConnectivityUsing SQuirrel SQL Client with TeradataThe Teradata JDBC Driver supports the DatabaseMetaData.getColumns method.  
1511 Jun 2015 @ 06:28 PDTtomnolan's blogJDBC ResultSet PaginationThe application-specified fetch size is respected beginning with Teradata JDBC Driver 13.10.00.25 and Teradata Database 13.10. (Fetch size is ignored/unused in older versions.)
1428 Jan 2015 @ 09:54 PSTtomnolan's blogThe Teradata JDBC Driver's COP Discovery, LCC, Logon, and moreYou were correct regarding the missing scenario in Step 1, so I revised Step 1 to say "If COP Discovery fails to discover any cop-suffixed hostnames, or if COP Discovery is turned off wit...
1326 Jan 2015 @ 10:32 PSTtomnolan's blogThe Teradata JDBC Driver's COP Discovery, LCC, Logon, and more can we say that COP discovery is not a mandatory step for a JDBC connection?   COP Discovery is not mandatory for a JDBC connection. However, whether or not COP Discovery is needed depe...
1230 Sep 2014 @ 01:33 PDTConnectivitySpeed up your JDBC/ODBC applicationsThis article is primarily about Java and JDBC. You are unlikely to receive Visual Basic help by posting here. I recommend that you repost your question in the Connectivity forum.
1122 Aug 2014 @ 06:33 PDTConnectivityUsing SQuirrel SQL Client with TeradataThat is a very old version of the Teradata JDBC Driver. You need to upgrade to a newer version. http://downloads.teradata.com/download/connectivity/jdbc-driver
1024 Mar 2014 @ 06:41 PDTToolsTeradata Studio Express 14.10 now availableNo, not a bug in the Teradata JDBC Driver. That error is from the Teradata Database. It refers to the Teradata Database composing the ResultSet row of data on the server side before it is even tran...
907 Feb 2014 @ 10:05 PSTConnectivitySpeed up your JDBC/ODBC applicationsTYPE=FASTLOAD instructs the Teradata JDBC Driver to use the FastLoad protocol for INSERT statements that are compatible with FastLoad. A regular SQL INSERT will be performed for INSERT statements t...
804 Dec 2013 @ 09:00 PSTConnectivitySpeed up your JDBC/ODBC applicationsmingtotti, the Teradata ODBC Driver and Teradata .NET Data Provider do not support FastLoad or FastExport at the present time.    aimam, Teradata Database error 5966 applies to Pre...
726 Nov 2013 @ 08:12 PSTamarek's blogHow to use JDBC PreparedStatement batch INSERT with RThere is a problem currently with Developer Exchange that prevents posting certain SQL statements. Posting code as an image is a temporary workaround.   After the Developer Exchange problem ...
609 Jun 2012 @ 09:42 PDTConnectivitySpeed up your JDBC/ODBC applicationsThat's incorrect. In fact, JDBC FastLoad *must* be used with a PreparedStatement batch. Please refer to the Teradata JDBC Driver Reference section about JDBC FastLoad. http://developer.teradata.c...
523 Feb 2011 @ 06:32 PSTConnectivityUsing Teradata JDBC driver with WebSphere Application ServerIn the document above, please refer to Section 4.2.1 -- "DataSource. getConnection() vs. DataSource.getConnection(username,password)" It discusses the error you received, and the solutions.
414 Jan 2011 @ 08:33 PSTConnectivityUsing Teradata JDBC driver with WebSphere Application Server> Does it mean that when I close my connection with con.close(); method , the session is always alive (or idle) in Teradata ? Yes, exactly. > what's the benefit of the pool connection ? ...
313 Dec 2010 @ 09:26 PSTConnectivitySpeed up your JDBC/ODBC applications>>> Can a statement like this be useful for Prepared Statement? sel * ..... WHERE cast(CollectTimeStamp as timestamp) > cast('?') That's not the right syntax. sel * ..... WHERE cast(CollectTi...
202 Sep 2010 @ 11:24 PDTToolsSQL Assistant Java EditionWhen you create the volatile table, if you specify the clause ON COMMIT PRESERVE ROWS, then the volatile table's contents will persist across transaction boundaries.
117 Mar 2010 @ 09:38 PDTConnectivitySpeed up your JDBC/ODBC applicationsYes, the Teradata Database's statement cache will typically be used.