#DateForumTypeThreadPost
4404 Jan 2011 @ 10:14 PSTConnectivityReplyConnection.createStatement fails to use ResultSet type informationTeradata JDBC Driver version 12.00.00.110 *does* support scrollable result sets. There are a couple of situations in which the Teradata JDBC Driver must "downgrade" your request for a Statement ...
4320 Dec 2010 @ 08:55 PSTConnectivityReplyTeradata JDBC driver 1013 errorThe most likely reason to get that exception message is if your application attempted to submit a SQL request whose SQL request text length is greater than 1048500 bytes long, after the Java String...
4203 Dec 2010 @ 09:58 PSTGeneralReplyProblem with Java Driver>>> When i run it with the SQL Assistant it does work just fine SQL Assistant uses the Teradata ODBC Driver, which parses your SQL request and rewrites it. The Teradata ODBC Driver implements th...
4116 Nov 2010 @ 09:51 PSTGeneralReplyExecuting Fastload through Java Hang in unixThere are at least a couple of problems with your program. First, you are using the shell IO redirect operators in your command. Those are only implemented by the shell. If you want to use them,...
4009 Nov 2010 @ 12:55 PSTConnectivityReplyProblem with TimeStamp and Foreign keyYes, the database problem is present regardless of whether a PreparedStatement batch or single-insert is used. For reference, the DR number for this problem is DBS DR 146606. Unfortunately, p...
3905 Nov 2010 @ 10:10 PDTConnectivityReplyResponse Limit ExceededPlease refer to the Troubleshooting section in the Teradata JDBC Driver User Guide about this topic. The Teradata JDBC Driver User Guide can be found here in the Download Center: http://www.t...
3805 Nov 2010 @ 06:28 PDTConnectivityReplyProblem with TimeStamp and Foreign keyThis is a Teradata Database problem; it has been reported to the Engineering team. You can work around the problem by reversing the order of the BACTIVE,PASSRESETDATE columns in the INSERT state...
3704 Nov 2010 @ 11:56 PDTToolsReplyERROR ~ [Teradata DBMS] : Response limit exceeded.First, the code posted above is not the right way to use a PreparedStatement. You should not prepare a SQL request over and over again inside a loop. Instead, the SQL request should be prepared ...
3602 Nov 2010 @ 09:51 PDTConnectivityReplyPooled JDBC connection with WebSphere 7If this problem is occurring for a customer Teradata system, then I recommend engaging Teradata Customer Support.
3529 Oct 2010 @ 10:03 PDTConnectivityReplyPooled JDBC connection with WebSphere 7Yes, there's a problem with the images for the WebSphere How-To document that is posted here on Developer Exchange. You can also find the document (with images) in the Teradata JDBC Driver docum...
3426 Oct 2010 @ 10:05 PDTConnectivityReplyVolatile tables and pooledconnections First, please note that TeraConnectionPoolDataSource is not intended for use by applications. It is intended for use by the connection pool feature of an application server such as WebSphere. Th...
3329 Sep 2010 @ 09:04 PDTConnectivityReplyjdbc deployment questionThe Teradata JDBC Driver jar files are copyrighted by Teradata Corporation, with all rights reserved. You cannot redistribute them, unless you have a contract with Teradata Corporation that permits...
3229 Sep 2010 @ 09:00 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"I answered your question about Teradata Database error 5966 in the earlier thread. The answer is that you need to reduce the number of rows of data that your application binds per batch, and *** us...
3121 Sep 2010 @ 10:32 PDTDatabaseReplywhen i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"You cannot change that Teradata Database limit. You need to change your application so that it binds fewer rows of data per batch.
3020 Sep 2010 @ 12:40 PDTDatabaseReplywhen i use jdbc connection Teradata(12.0), i get errors "[TeraJDBC 13.00.00.16] [Error 5966] [SQLState HY000]"The Teradata Database Messages reference says: 5966 Too many data records packed in one USING row. Explanation: User has defined too many data records in one USING row. The limit is 16383. ...
2902 Sep 2010 @ 11:10 PDTDatabaseReplyTIMESTAMP(0) showing .0 at the end>>> However when I am saving it in a text file using JDBC The Teradata JDBC Driver does not save any data in a text file. So your application would be doing the saving to a text file. Please cop...
2802 Sep 2010 @ 10:44 PDTConnectivityReplyConnecting Python to Teradata over ODBCThe important part of the exception message is: java.net.UnknownHostException: localhostcop1 Which tells you that "localhostcop1" is not a defined hostname. If the Teradata Database is running on...
2725 Aug 2010 @ 11:30 PDTDatabaseReplyStrange error while inserting null in character key columnsThe data type of a NULL value is INTEGER. That's why the Teradata Database returns Error 2620 The format or data contains a bad character. For example: select type(null); *** Query co...
2611 Aug 2010 @ 08:55 PDTGeneralReplyTeraJDBC driver not supporting BIGINT DatatypeThe BIGINT data type is supported starting with TTU 8.2 / Teradata JDBC Driver version 3.4.
2522 Jul 2010 @ 02:01 PDTDatabaseReplyDoes teradata jdbc driver support for period data type?The Teradata JDBC Driver does not support Period data types with Teradata Database 13.0. Support for Period data types as java.sql.Struct values is a Teradata Database 13.10 feature.
2421 Jul 2010 @ 01:36 PDTConnectivityReplyQuery banding within a single transactionSET QUERY_BAND ... FOR SESSION is a DDL statement, and must be committed afterward. With the Teradata JDBC Driver, either use auto-commit ON, or call the Connection.commit method after executing...
2304 Jun 2010 @ 10:18 PDTConnectivityReplyDriverManager.getConnection() method error while using Teradatd driverYour stack trace shows the NoClassDefFoundError occurring from a WebLogic class file. I see the WebLogic class file listed in your stack trace, but your stack trace also appears to indicate that...
2201 Jun 2010 @ 01:43 PDTConnectivityReplyDriverManager.getConnection() method error while using Teradatd driverFirst, your connection URL is incorrect. You listed 3 slashes in your URL -- jdbc:teradata:///AMRROCD But you must have only 2 slashes after the second colon in your URL -- it should be jdbc:ter...
2101 Jun 2010 @ 01:43 PDTConnectivityReplyDriverManager.getConnection() method error while using Teradatd driverFirst, your connection URL is incorrect. You listed 3 slashes in your URL -- jdbc:teradata:///AMRROCD But you must have only 2 slashes after the second colon in your URL -- it should be jdbc:ter...
2001 Jun 2010 @ 01:39 PDTConnectivityReplyProblem with Linux TeraJDBC.03.02.00.03 driver.Yes, you need tdgssconfig.jar on your classpath also. That exception is due to tdgssconfig.jar not being available -- either not listed on your classpath, or the file is not present.

Pages