Posted 09 Mar 2016
Every so often, the Teradata JDBC Driver Engineering team is asked about Teradata Database Error 5766 "The Locator is invalid because the response spool has been dropped."
Why does it happen? How can it be avoided?
|
Posted 22 Jan 2015
The Teradata JDBC Driver Engineering team receives a lot of questions about what happens when a JDBC connection is created. Let's clarify the concepts Laddered Concurrent Connect (LCC) versus COP Discovery versus logon, and review what the Teradata JDBC Driver does to create a JDBC connection.
First, some definitions... "COP" stands for Communications Processor, and is a term originating from Teradata's earliest database appliances in the 1980s. In modern usage, a "COP" is a Teradata Database node that is running a Teradata Database Gateway process. |
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 tur...
|
Posted 15 May 2013
Oracle (Sun) JDK 6.0 and JDK 7.0 include the Apache Derby database, which is implemented in 100% Java. This article is not about the Apache Derby database; instead, this is about a command-line interactive SQL tool that is included with Apache Derby. The Apache Derby "ij" interactive SQL tool is quite useful. It is a command-line SQL tool similar to BTEQ, and it works with any JDBC Driver and any database, not just the Apache Derby database. The following instructions show how to use the ij tool with the Teradata JDBC Driver. |
Posted 19 Mar 2012
"Pagination" refers to the technique commonly used by web applications to display a section of a larger query result, and let the user jump backwards and forwards to particular sections. Google, for example, uses this technique to display search results. This article assumes that your queries routinely return more row data than can fit into a single 1 MB response message sent from the Teradata Database to the Teradata JDBC Driver. |
Posted 10 Mar 2012
Question We can establish a JDBC Connection with URL that specifies a database name, e.g. jdbc:teradata://<some host>/DATABASE=<some database> After the Connection is opened, is there any way to determine what database is in use? And is there any way to switch to a different database? Answer |
Posted 16 Jan 2012
A "parameterized" SQL request is when you specify a question-mark parameter marker in place of an expression within the SQL request text. Parameter markers are recommended over SQL literals for a couple of reasons.
|
Posted 12 Jan 2012
The Teradata JDBC Driver provides both forward-only and scrollable result sets. With a forward-only result set, an application can only fetch rows in the forward direction, using the Since a scrollable result set offers significantly more functionality than a forward-only result set, application developers may wonder whether there is a performance penalty for using a scrollable result set. |