#DateForumTypeThreadPost
16907 Dec 2012 @ 08:32 PSTAnalyticsReplyAll virtual circuits are currently in useError 8024 is from the Teradata Database Gateway. It means that you have reached the session limit of the Teradata Database. By default, a Teradata Database supports 120 sessions per PE. Here is t...
16806 Dec 2012 @ 06:44 PSTToolsReplyExamples of writing prepared statements in CLIv2Please consider using the Teradata ODBC Driver for a C or C++ program that uses prepared statements. Prepared statements are tested extensively with Teradata's industry standard data access AP...
16701 Dec 2012 @ 08:22 PSTConnectivityReplyConnection Pool issue(Connection reset by peer: socket write error) with server in DMZAre you running Tomcat on Linux? If so, then you may be encountering the "Slow Logon on Linux" problem. http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapt...
16630 Nov 2012 @ 11:54 PSTConnectivityReplyTeradata JDBC Exception Please refer to the following troubleshooting information in the Teradata JDBC Driver User Guide: http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5.html#CHDIJJ...
16529 Nov 2012 @ 09:53 PSTConnectivityReplyTeradata JDBC Exception Some connection pool managers, but not all, have a feature to automatically test a connection by executing a simple query before the connection is provided to the application. Enabling a feature l...
16428 Nov 2012 @ 12:11 PSTDatabaseReplyDBQL and LOB'sYes, that behavior is expected. The original SQL query is logged in DBQL. The SELECT ? commands are logged separately, and in addition to, the original query. The SELECT ? commands are from ...
16319 Nov 2012 @ 10:11 PSTToolsReplyTeradata PMon based Java applicationYes, the Teradata JDBC Driver provides Monitor partition connections to enable your application to invoke PM/API commands. The Monitor partition connection support is documented in the Teradata JDB...
16219 Nov 2012 @ 06:55 PSTConnectivityReplyError 8017 - The UserId, Password or Account is invalid The message says that you are using the TD2 authentication mechanism, which means that your LOGMECH=LDAP parameter is missing, or is not specified correctly. As I said before, if you are a cus...
16116 Nov 2012 @ 01:05 PSTConnectivityReplyError 8017 - The UserId, Password or Account is invalidAs a starting point, you can query DBC.LogOnOff to determine the cause of the error. If you continue to have a problem, and you are a customer, then you can open an incident with Customer Supp...
16013 Nov 2012 @ 06:41 PSTConnectivityReplyJDBC DatabaseMetadata.getColumns Seems SlowIf your application does not need all the information provided by DatabaseMetaData.getColumns, then your application can query the Data Dictionary views directly. Regarding support, if you are a T...
15908 Nov 2012 @ 06:46 PSTConnectivityReplyCould not initialize class javax.crypto.SunJCE_bThat JDBC URL is not correct. Beginning with Teradata JDBC Driver version 14.00.00.13, the USER and PASSWORD URL parameters are available, but there are no "uid" or "pwd" URL p...
15807 Nov 2012 @ 06:42 PSTConnectivityReplyCould not initialize class javax.crypto.SunJCE_bGoogling "Could not initialize class javax.crypto.SunJCE_b" returns many results, with different suggestions for how to fix the problem. I recommend that you try some of the suggestions.
15731 Oct 2012 @ 08:34 PDTToolsReplyMulti load through java application.The MultiLoad protocol is not supported by the Teradata JDBC Driver at the present time; however, it is on our product roadmap. As an alternative, we recommend using JDBC FastLoad CSV to load...
15631 Oct 2012 @ 10:36 PDTToolsReplyERROR ~ [Teradata DBMS] : Response limit exceeded.The Teradata JDBC Driver User Guide is now located here on Developer Exchange. Use the link posted below. The Teradata JDBC Driver User Guide's Troubleshooting section documents the common cau...
15516 Oct 2012 @ 08:15 PDTConnectivityReplyJava exception | locked <0x00000007c53633f0> (a com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement)You mentioned an error. What error are you getting? The stack trace that you posted is a stack trace for a running thread. It is not an exception stack trace.
15412 Oct 2012 @ 10:58 PDTConnectivityReplyERROR "Response Limit exceeded" in JDBC DriverDetailed advice is listed in the Teradata JDBC Driver Reference: http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5.html#CHDGCHBB "To solve this issue, ex...
15312 Oct 2012 @ 10:51 PDTConnectivityReply org.hibernate.exception.GenericJDBCException: could not execute queryI think you are missing an equal sign between section and :Section -- it should be: StringBuffer hqlStringBuffer = new StringBuffer("from student where name like :Name and class=:Class and se...
15203 Oct 2012 @ 02:34 PDTConnectivityReplyExecuteUpdate -- -row count return type is intThe activity count is an accurate row count most of the time; however, under certain conditions the actual row count can differ from the activity count. There is feature request (JDBC RFC 121...
15103 Oct 2012 @ 02:14 PDTToolsReplyUsing FastExport with Teradata JDBC DriverJDBC FastExport does not support scrollable result sets. That limitation comes from the Teradata Database, because the FastExport wire protocol does not support scrollable result sets. You did fin...
15025 Sep 2012 @ 08:51 PDTConnectivityReplyProblem Authenticating through JDBC running on Linux.The newInstance method call is not required. There should not be a space between the slash following the IP address and the USER= property. You should specify the COP=OFF property when you specif...
14914 Sep 2012 @ 08:36 PDTConnectivityReplySocket Error 804Teradata JDBC Driver 14.00.00.21 has been released and is now available for download here on Developer Exchange. Teradata JDBC Driver 14.00.00.21 contains the fix for JDBC DR 155367.
14805 Sep 2012 @ 11:49 PDTGeneralReplyWish list for forum development I'd like to see users rated, with an icon next to their name in the forum posting that indicates how reliable their information is, such as a silver star, gold star, or something. Also,...
14705 Sep 2012 @ 06:28 PDTConnectivityReplyCalling a macro via JDBC Ulrich is correct that the execute method must be used for executing a macro, not the executeUpdate or executeQuery method. However, those methods are all overloaded, meaning multiple method...
14630 Aug 2012 @ 10:16 PDTConnectivityReplyProblems in connecting to Teradata from Java on AIX I just successfully tested the Teradata JDBC Driver on an AIX 5.3 machine using the following JVMs. 32-bit JDK 6.0 from 2007: java version "1.6.0" Java(TM) SE Runtime Environ...
14529 Aug 2012 @ 06:43 PDTConnectivityReplyProblems in connecting to Teradata from Java on AIX Teradata JDBC Driver 14.00.00.14 does not include TdgssUserConfigFile.xml. It only includes terajdbc4.jar and tdgssconfig.jar. So your TdgssUserConfigFile.xml may be left over from an old i...

Pages