#DateForumTypeThreadPost
11908 Jun 2012 @ 06:27 PDTConnectivityReply[TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33 The Teradata JDBC Driver does not yet support WITH clauses and summary values. That feature request is covered by JDBC RFC 85621. Omit the WITH clause from your query in order to e...
11801 Jun 2012 @ 10:30 PDTConnectivityReplyNo more room in database All. When working with LOBs, the Teradata Database can return a misleading Database Error 2644 "No more room in database All." This may indicate that your Teradata Database userid doesn...
11730 May 2012 @ 01:27 PDTConnectivityReplyWhy is TeraData JDBC complaining about these parameters? Yes, you should consider the use of SET QUERY_BAND FOR TRANSACTION, which was designed for use cases like yours -- servlet requests, Web Service requests, etc.
11630 May 2012 @ 09:48 PDTConnectivityReplyWhy is TeraData JDBC complaining about these parameters? SET QUERY_BAND FOR SESSION is a DDL command, so a question-mark parameter marker is not permitted. In contrast, SET QUERY_BAND FOR TRANSACTION is a DML command, so a question-mark parameter ...
11529 May 2012 @ 08:48 PDTGeneralReplyJDBC + JPA operations throwing exception for 2 phase commit You are correct that the Teradata Database does not support XA. Which JPA implementation are you using? EclipseLink, Hibernate, ... ?
11425 May 2012 @ 06:52 PDTConnectivityReplyUsing fastload from java application The Teradata JDBC Driver Reference, with documentation and sample programs, is available here on Developer Exchange. JDBC FastLoad (non-CSV) http://developer.teradata.com/doc/connectivity/jd...
11324 May 2012 @ 09:48 PDTConnectivityReplyWhy is TeraData JDBC complaining about these parameters? As Carlos said, the argument for the ST_Geometry constructor is a character literal. Question marks in a character literal are simply question mark characters. Question marks in a character ...
11204 May 2012 @ 09:53 PDTConnectivityReplyTeradata JDBC driver behavior different than other drivers using Eclipse and Servoy The Teradata Plug-in for Eclipse is Teradata's recommended and supported solution for accessing the Teradata Database from within the Eclipse IDE. It is freely available for download her...
11129 Mar 2012 @ 10:33 PDTConnectivityReply[Teradata Database] [TeraJDBC 14.00.00.12] [Error 6760] [SQLState HY000] Invalid timestamp. I just tested binding java.sql.Timestamp values to the question-mark parameter markers in a BETWEEN ? AND ? condition, using Teradata Database V2R06.02.02.67, and it worked successfully. The...
11028 Mar 2012 @ 09:58 PDTDatabaseReplyhow to troubleshoot the pooled connection failure Your issues appear to be with c3p0, not the Teradata JDBC Driver. We recommend studying information available for c3p0. Fo example, the following forum thread describes a symptom similar to ...
10928 Mar 2012 @ 06:50 PDTDatabaseReplyhow to troubleshoot the pooled connection failure You appear to be using c3p0 connection pooling. Please provide your configuration, e.g. c3p0.properties file, if that's what you're using.  
10826 Mar 2012 @ 08:41 PDTConnectivityReplyJDBC DatabaseMetadata.getColumns Seems Slow If your application only needs to obtain column information for a single table or view, then the prepare select * technique can be an alternative. DatabaseMetaData.getColumns can obtain...
10723 Mar 2012 @ 08:38 PDTConnectivityReplyJDBC DatabaseMetadata.getColumns Seems Slow I should have mentioned a Step zero - make sure you're using the latest version of the Teradata JDBC Driver that's available here on Developer Exchange. http://downloads.teradata.com...
10622 Mar 2012 @ 12:30 PDTConnectivityReplyJDBC DatabaseMetadata.getColumns Seems Slow Step 1. Are you using X-views? Some organizations require the use of X-views; however, they are slower than non-X-views. We mention this issue in the Teradata JDBC Driver Reference. http://d...
10521 Mar 2012 @ 02:08 PDTToolsReplyExport large data set to CSV files Teradata Database 14.0 has a built-in function to format data as CSV for export. With TD 13.10 and earlier versions, you can format the data yourself in the select statement, e.g. select...
10419 Mar 2012 @ 02:44 PDTConnectivityReplyJDBC Encryption >>> So I basically just have to "trust" that the encryption is working? I agree that it ought to work better. I expect this to improve in a future version. Some c...
10319 Mar 2012 @ 02:33 PDTConnectivityReplyJDBC driver pagination support To help answer your question, I wrote this blog entry: http://developer.teradata.com/blog/tomnolan/2012/03/jdbc-resultset-pagination  
10219 Mar 2012 @ 12:20 PDTConnectivityReplyJDBC Encryption The connection parameter is actually ENCRYPTDATA=ON http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#URL_ENCRYPTDATA Sorry, No, there is no way...
10129 Feb 2012 @ 09:48 PSTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums! You are using a very old version of the Teradata JDBC Driver. You may have encountered a known problem in that old version -- JDBC DR 147087. Please upgrade to the newest version of the Tera...
10023 Feb 2012 @ 06:53 PSTDatabaseReplyDatabase command execution There are at least a couple of ways to do this, but they are not officially supported. If you are a customer or a partner, then you should open an incident with Customer Support and we can work ...
9903 Feb 2012 @ 08:26 PSTConnectivityReply[SQLState 22003] A character string failed conversion to a numeric value. You found a bug in the Teradata Database. Here are my testing results: TD 12.00.03.28 - correct - getParameterCount=2 TD 13.00.01.13 - incorrect - getParameterCount=4 TD 13.10.01...
9803 Feb 2012 @ 10:07 PSTConnectivityReply[SQLState 22003] A character string failed conversion to a numeric value. You have encountered a limitation with the Teradata Database. For the question-mark parameter marker in the expression "CASE WHEN 'All' = ?", the Teradata Database is makin...
9702 Feb 2012 @ 09:57 PSTConnectivityReply[SQLState 22003] A character string failed conversion to a numeric value. More information would be needed in order to determine the problem. Please post your Java code that binds values to the parameter markers, and please post the DDL for the "LOV" obj...
9617 Jan 2012 @ 09:38 PSTDatabaseReplyFaled to invoke PreparedStatement executeUpdate method Teradata JDBC Driver version 13.00.00.25 is a rather old version. You should consider upgrading to a newer version. You should modify your application to walk the SQLException chain usi...
9513 Jan 2012 @ 09:43 PSTDatabaseReplyTeradata JDBC trace log location? The Teradata JDBC Driver logs to System.out. The Teradata JDBC Driver doesn't create a log file. Please refer to each application's documentation and/or support for how the appl...

Pages