#DateForumTypeThreadPost
1926 May 2010 @ 01:35 PDTExtensibilityReplyExternal Store procedure to read a local client file>>> There must be something hidden in ODBC/BTEQ/JDBC implementing the client side file read and send bytes to server side socket which can be reached via the store procedure. BTEQ and the Terada...
1820 Apr 2010 @ 10:37 PDTConnectivityReplyError with JDBC on SUN One Web: 08S01 804 : I/O Error, Socket closed.The list of application servers supported by the Teradata JDBC Driver is available at: http://www.teradata.com/DownloadCenter/Topic9391-98-1.aspx Please note that the Sun ONE Web Server is not ...
1715 Apr 2010 @ 10:20 PDTDatabaseReply[Error 8505] [SQLState HY000] LOB ID could not be generatedError 8505 is a Teradata Database error. Here is what the Teradata Database documentation says about this error. 8505 LOB ID could not be generated Explanation: A unique LOB identifier cou...
1614 Jan 2010 @ 01:24 PSTConnectivityReplyError selecting Date when using jdbcTeradata JDBC Driver version 13.00.00.07 and earlier versions of the Teradata JDBC Driver do not support the implicit data type conversion of calling ResultSet.getTimestamp for a DATE column value....
1511 Jan 2010 @ 01:53 PSTConnectivityReplyany limitations with large number (10,000) parameters to sql SELECT via JDBC?The Teradata Database imposes a limit of 1 MB for SQL request text.Also, I suspect that you would hit a Teradata Database parser limit for too many question-mark parameter markers.From a performanc...
1408 Jan 2010 @ 09:42 PSTConnectivityReplyODBC driver for OS XI know of a couple of ODBC-to-JDBC bridge drivers: from OpenLink - http://uda.openlinksw.com/odbc/st/odbc-jdbc-bridge-st/ from EasySoft - http://www.easysoft.com/products/data_access/odbc_jdb...
1302 Dec 2009 @ 01:56 PSTConnectivityReplyTeradata JNDI connectivityYour URL is not correct. It has 2 problems.stag/url=jdbc:teradata://10.20.26.212:1025/dbcThe first problem is the colon and port number. Do not put a colon and port number after the Teradata Databa...
1213 Oct 2009 @ 10:07 PDTConnectivityReplyTeradata and JDBC connection .But problem with table namesYour "SocketException: Connection reset" error is probably due to a networking-related problem. The Teradata JDBC Driver does not impose any limits on the number of concurrent connections. Th...
1106 Oct 2009 @ 10:00 PDTDatabaseReplyselect * from database_name.table_nameThe Teradata Database does not provide synonyms as Oracle does; however, you can create a view in your default database that selects all the columns of the table in a different database.
1006 Oct 2009 @ 09:57 PDTConnectivityReplyTeradata and JDBC connection .But problem with table namesIn order to access tables by table name only, unqualified by database name, you need to have your Connection's default database set to the database containing the tables. You can only have one d...
905 Oct 2009 @ 05:27 PDTConnectivityReplyQuery about SESSIONS parm for JDBC DriverThe SESSIONS connection parameter only applies to JDBC FastLoad and JDBC FastExport connections.The SESSIONS connection parameter is not applicable to a regular SQL connection.When you are using a ...
822 Jul 2009 @ 02:57 PDTConnectivityReplyJDBC and ORacle Data IntegratorWe have many Sample Programs available to demonstrate features of the Teradata JDBC Driver. The Sample programs are listed on this page: http://www.teradata.com/DownloadCenter/Topic9361-99-1.aspx ...
725 Jun 2009 @ 01:30 PDTConnectivityReplyPreparedIndicProtocol incompatible with PreparedIndicMultiPartProtocolThis issue is resolved by JDBC RFC 99487 ("enable use of PreparedStatement batch update when LOB_SUPPORT=off"), which is available in Teradata JDBC Driver 13.00.00.04 and later.
608 May 2009 @ 02:19 PDTConnectivityReplyTeradata JDBC fastload hangs after approximately 50 batch insertYou can submit a request for support for this issue with Teradata Express, if you haven't done so already.Go to the Teradata Express page: http://www.teradata.com/expressThen click the link for "Cu...
522 Apr 2009 @ 01:56 PDTConnectivityReplyTeradata JDBC fastload hangs after approximately 50 batch insertPlease note that FastLoad cannot load duplicate rows, even into a MULTISET table.Because the same column values are used on each pass through the loop, your example program will attempt to load tho...
402 Apr 2009 @ 12:14 PDTConnectivityReplyError selecting Date when using jdbcPlease post the stack trace for the exception that you got.Thanks,--Tom
330 Dec 2008 @ 03:04 PSTConnectivityReplyJDBC v12 and DBC.TablesXThis is a known issue -- JDBC DR 108938 ("Change DatabaseMetaData.getColumns to use the current USEXVIEWS setting").The current plan is for JDBC DR 108938 to ship to Teradata JDBC Driver Efix versi...
231 Jan 2008 @ 11:50 PSTConnectivityReplyJDBC driver (java.sql.Driver impl., version 03.03.00.04) does not handle correct the connect's "Properties" instanceIn case it wasn't clear, this RFC was just created and has not yet been scheduled for a particular Teradata JDBC Driver release.
130 Jan 2008 @ 01:33 PSTConnectivityReplyJDBC driver (java.sql.Driver impl., version 03.03.00.04) does not handle correct the connect's "Properties" instanceThis issue corresponds to JDBC RFC DR 119654 -- support default Properties with DriverManager.getConnection(url, Properties)

Pages