| 21 | 16 Dec 2015 @ 01:40 PST | Tools | Introducing Teradata Wallet | Many 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... |
| 20 | 30 Nov 2015 @ 09:51 PST | Tools | Introducing Teradata Wallet | We 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 ... |
| 19 | 30 Nov 2015 @ 09:40 PST | Tools | Creating a Simple Java User Defined Function using the Teradata Plug-in for Eclipse | Your 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... |
| 18 | 27 Aug 2015 @ 01:24 PDT | Connectivity | How to use the Teradata JDBC Driver with teradataR | This 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
... |
| 17 | 20 Jul 2015 @ 02:58 PDT | Connectivity | Speed up your JDBC/ODBC applications | Error 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
... |
| 16 | 09 Jul 2015 @ 06:42 PDT | Connectivity | Using SQuirrel SQL Client with Teradata | The Teradata JDBC Driver supports the DatabaseMetaData.getColumns method.
|
| 15 | 11 Jun 2015 @ 06:28 PDT | tomnolan's blog | JDBC ResultSet Pagination | The 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.)
|
| 14 | 28 Jan 2015 @ 09:54 PST | tomnolan's blog | The Teradata JDBC Driver's COP Discovery, LCC, Logon, and more | You 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... |
| 13 | 26 Jan 2015 @ 10:32 PST | tomnolan's blog | The 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... |
| 12 | 30 Sep 2014 @ 01:33 PDT | Connectivity | Speed up your JDBC/ODBC applications | This 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.
|
| 11 | 22 Aug 2014 @ 06:33 PDT | Connectivity | Using SQuirrel SQL Client with Teradata | That 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
|
| 10 | 24 Mar 2014 @ 06:41 PDT | Tools | Teradata Studio Express 14.10 now available | No, 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... |
| 9 | 07 Feb 2014 @ 10:05 PST | Connectivity | Speed up your JDBC/ODBC applications | TYPE=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... |
| 8 | 04 Dec 2013 @ 09:00 PST | Connectivity | Speed up your JDBC/ODBC applications | mingtotti, 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... |
| 7 | 26 Nov 2013 @ 08:12 PST | amarek's blog | How to use JDBC PreparedStatement batch INSERT with R | There 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 ... |
| 6 | 09 Jun 2012 @ 09:42 PDT | Connectivity | Speed up your JDBC/ODBC applications | That'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... |
| 5 | 23 Feb 2011 @ 06:32 PST | Connectivity | Using Teradata JDBC driver with WebSphere Application Server | In 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. |
| 4 | 14 Jan 2011 @ 08:33 PST | Connectivity | Using 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 ?
... |
| 3 | 13 Dec 2010 @ 09:26 PST | Connectivity | Speed 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... |
| 2 | 02 Sep 2010 @ 11:24 PDT | Tools | SQL Assistant Java Edition | When 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. |
| 1 | 17 Mar 2010 @ 09:38 PDT | Connectivity | Speed up your JDBC/ODBC applications | Yes, the Teradata Database's statement cache will typically be used. |