#DateForumTypeThreadPost
24418 Oct 2013 @ 06:47 PDTExtensibilityReplyJava UDF and Socket (TCP/UDP) ConnectionsI am not aware of any limit imposed on outgoing TCP or UDP connections from Java UDFs to remote systems.
24318 Oct 2013 @ 06:43 PDTConnectivityReplyTeradata JDBC Exception "Incomplete LAN message header: read 0 bytes" is a different problem than the classpath problem originally reported in this forum thread. In the future, please create a new forum thread ...
24218 Oct 2013 @ 06:37 PDTConnectivityReplyF5 versus DNS>>> Are there any issues with large data volumns going through an F5 as opposed to the DNS   I have not heard that before. F5's marketing literature emphasizes their support for...
24117 Oct 2013 @ 06:47 PDTConnectivityReplyUnable to create a connection using the jdbc:teradata://10.65.140.250/DATABASE=rts_devIs your Java program running on a Linux machine? If so, then you may have encountered the "Slow Logon on Linux" problem. The problem, and workarounds, are documented in the Teradata JDBC ...
24017 Oct 2013 @ 06:45 PDTExtensibilityReplyCalling Web ServicesThe Teradata Database supports Java Stored Procedures. You can create a Java Stored Procedure that calls a web service.
23917 Oct 2013 @ 06:43 PDTConnectivityReplyJDBC Bug with exact batch sizesNo, this is not a bug in the Teradata JDBC Driver.   If an application calls the executeBatch method without having called the addBatch method, then the Teradata JDBC Driver will throw ...
23816 Oct 2013 @ 06:53 PDTConnectivityReplyF5 versus DNSThe F5 load balancer is "smarter" than a typical DNS server, because the F5 keeps track of which database nodes are online vs offline, whereas a DNS server doesn't keep track of that ...
23715 Oct 2013 @ 06:50 PDTExtensibilityReplyJava UDF and Socket (TCP/UDP) ConnectionsWhat kind of Java UDF did you make? Is it a table function?   A table function is executed on each AMP, once per AMP. So if your system has 2 AMPs, then your table function wo...
23608 Oct 2013 @ 06:51 PDTConnectivityReplyDoubt in connectivity with Java and TDSince you haven't provided any details about the application, it is difficult to offer help.   The Teradata JDBC Driver provides connection parameters to enable the Teradata Session Reco...
23507 Oct 2013 @ 06:40 PDTDatabaseReplyJava App to restart with TDYou post contains no details. Is this a standalone Java application, or does it run in an application server? Which application server, and what version?   And why is this a concern in the f...
23407 Oct 2013 @ 06:40 PDTConnectivityReplyDoubt in connectivity with Java and TDYou post contains no details. Is this a standalone Java application, or does it run in an application server? Which application server, and what version?   And why is this a concern in the f...
23302 Oct 2013 @ 10:08 PDTConnectivityReplyJDBC Driver 14.10.00.17 - INSERT into TeraData tables shows SELECT from DBC.TABLES and HELP StatementsFirst, USEXVIEWS=ON will slow down DatabaseMetaData queries, so do not specify that to improve performance.   Second, for INSERT operations, the Teradata JDBC Driver does not execute any que...
23227 Sep 2013 @ 10:30 PDTDatabaseReplySelect statements to get metadataPK/FK relationships are stored in the Teradata Database's Data Dictionary.   The Teradata JDBC Driver implements standard JDBC API methods to return that information: DatabaseMetaData.ge...
23127 Sep 2013 @ 10:08 PDTDatabaseReplySelect statements to get metadataRegarding this question: >>> How to perform a select with the equivilent of "skip 100, take 50" which returns rows 101 - 150 of a given select.   The Teradata Database pr...
23024 Sep 2013 @ 11:02 PDTConnectivityReplyNo suitable driver found for jdbc issue even after downloading the teradata v 14 jdbc drivers@sirisha.sindiri   First question: Does your Teradata environment actually use LDAP authentication? You should only specify LOGMECH=LDAP if your Teradata environment is configured to support...
22919 Sep 2013 @ 06:35 PDTConnectivityReplyNo suitable driver found for jdbc issue even after downloading the teradata v 14 jdbc driversThe Teradata JDBC Driver URL Connection syntax is documented in the Teradata JDBC Driver Reference here on Developer Exchange. Here is a direct link to the relevant section: http://developer.terada...
22819 Sep 2013 @ 06:28 PDTExtensibilityReplyDYNAMIC RESULT SETS and Teradata versions>>> Do you have an idea if installing JDBC 13.0.0.6 driver on TeraData R12 could help?   No, it will not.
22718 Sep 2013 @ 06:36 PDTExtensibilityReplyDYNAMIC RESULT SETS and Teradata versionsDynamic result sets for SQL stored procedures are a Teradata Database 12.0 feature.   Dynamic result sets for Java stored procedures are a Teradata Database 13.0 feature.   The "...
22617 Sep 2013 @ 06:43 PDTDatabaseReplyHow to get the name of a table from an Insert, Update or Delete SQL without parsingTable name is available for SELECT query results from the ResultSetMetaData.getTableName method. But there is no easy way (and no JDBC API method) to obtain a table name for an INSERT, UPDATE,...
22517 Sep 2013 @ 06:31 PDTConnectivityReplyNo suitable driver found for jdbc issue even after downloading the teradata v 14 jdbc driversYou must have both terajdbc4.jar and tdgssconfig.jar listed on your classpath.   The most likely cause for the exception you received is that you are missing terajdbc4.jar on your classpath.
22410 Sep 2013 @ 06:37 PDTConnectivityReplyJDBC updateRow error - No value has been set for parameter 3@farhanhafeez, please do not reuse old forum threads. Please start a new thread for a new question.   And when you post your question to a new thread, please provide some details, such as th...
22315 Aug 2013 @ 08:13 PDTConnectivityReplySocket Error 804Yes, thank you for posting to a new thread. Please do not reuse old threads.   I replied to your new post: http://forums.teradata.com/forum/connectivity/connection-timeout-problem-driver-ver...
22215 Aug 2013 @ 06:55 PDTConnectivityReplyConnection timeout problem Driver version 13.10According to the stack trace you posted, you are using Teradata JDBC Driver 13.10.00.31.   You should upgrade to a newer version of the Teradata JDBC Driver; for example, Teradata JDBC Drive...
22112 Aug 2013 @ 06:37 PDTToolsReplyFastLoadThe Teradata JDBC Driver supports the FastLoad and FastExport wire protocols, but not the MultiLoad wire protocol. http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chap...
22007 Aug 2013 @ 09:18 PDTThird Party SoftwareReplyPassing NULL values to a TERADATA sp, using Teradata .NET provider 1.0Let's assume you have an Object with a null value in your application:   Object obj = null ;   The error message is indicating that your application cannot use the PreparedStateme...

Pages