All Forums

Covers all topics related to Teradata database connectivity, including the use of client technologies such JDBC, ODBC, .NET Provider etc. For articles, blogs and more, see the Connectivity section of this site.

You must login to post to the forums.
Create UDF Topic by srikant9099 16 May 2008

Hi All,Can anybody tell me, How to create and execute the UDF with simple example.RegardsSrikant

17516 views
3 replies, 2 years ago
Laddered Concurrent Connect (LCC) Topic by vincent91 08 Aug 2012 lcc

Thank you Darrick S, vhari, steveg for your article on Laddered Concurrent Connect (LCC): Client Performance Improvements
http://developer.teradata.com/connectivity/articles/laddered-concurrent-connect-lcc-client-performance-improvements

I didn't quite catch your explanation :"Once the first successful connect is recognized, any remaining occupied sockets are released (closed). A down node will no longer force the client interface to pause until the wait time interval has expired before it attempts to connect to another node."

3501 views
3 replies, 2 years ago
TERADATA SQL ERROR 3945: Invalid data length for VarChar, VarByte, orVARGRAPHIC while using JDBC connection Topic by Achieng 29 Jun 2011 database connectivity

We are getting this exception when running a query in a web application which coonects to Java API through a web service. The jar being used is terajdbc4.jar and the version of JDBC being used is TeraJDBC 13.00.00.22. I have run the query using bot ANSI mode and Teradata mode both using CLI,ODBC and Terardata.NET;no such error has been seen.

5924 views
4 replies, 2 years ago
08024 All virtual circuits are currently in use. Topic by spring-box 07 Aug 2012

Hello 

Now we use Tedradata Express 14.
We encountered the following errors and stoped this system. 
 08024 All virtual circuits are currently in use.

Please teach anyone how to resolve this issue?

Best regards,
 spring-box

3559 views
2 replies, 2 years ago
Where is the download URL for latest TeraGSS_suselinux-x8664 and TeraGSS_redhatinux-x8664 Topic by ericsun2 30 Jul 2012

I can't find it in the download center...

 

Please advise.

2912 views
1 reply, 2 years ago
Entity Framework, fluent api and trouble when mapping Boolean type to byteint Teradata database type Topic by extern 18 Jul 2012 entity framework fluent api boolean type

How can I map Boolean type using Entity Framework, Fluent Api?

I found this in Teradata type mapping documentation

"

Teradata does not natively support a Boolean type.

SSDL must be manually modified to enable Teradata ByteInt to Boolean Type mapping. Precision Facet must be set 1 as shown below:
Boolean Entity Type Mapping     Copy Code

3926 views
1 reply, 2 years ago
Not able to create/connect to new Database Topic by javed080787 18 Jul 2012

Hi,

 

I am new to Teradata, I have installed Teradata 13.0.

When i opened the SQL Assistant and try to connect or create a new database I am getting error

 

"160 specified driver could not be loaded due to system error 126 (teradata)"

 

Please let me know what is the resolution for this.

 

Thanks in advance.

 

3176 views
1 reply, 2 years ago
Problem with Teradata Express V13.0 Topic by learning_td 25 Jul 2012

Hi, I trying to install Teradata Express v13.0 in a Windows 2008 server machine, the installation finished succesfully, but when I click "Start Teradata" on Teradata Service Control, fails to display the message "Teradata is running", the last message display is "PDE state is RUN/READY".

Can someone help me?

Thanks. 

2703 views
0 replies
Unable Able to Run Access Update Query Topic by DRossmann 16 Mar 2012 odbc, update, ms access
6431 views
4 replies, 2 years ago
Query retry on deadlock in JDBC Topic by Duri83 17 Jul 2012 jdbc, deadlock, retryable errors

Hello,

I have gone through JDBC documentation, but I have not found a property or any other way, how to tell jdbc to retry a query that was aborted due to a deadlock.

We are running a lot of concurrent jobs and we get sometimes a deadlock - not because of actual deadlock, but because of lock table being full on an AMP.

4377 views
2 replies, 2 years ago
Entity Provider for Teradata Topic by vincent.yao 18 Mar 2011 entity framework

Hi,

Does anyone know roughly when the support for Entity Framework 4 and the Visual Studio 2010 integration is going to come? I know the current TDNETDP 13.10, which came out last Nov, supports Entity Framework 3.51 and Visual Studio 2008. Knowing this piece of information will help me with the implementation assessment of my project, which will use EF 4 on VS 2010.

Thanks.

6610 views
12 replies, 2 years ago
NullPointerException in TdgssConfigApi Topic by jai 20 Jan 2006

Hi, We are using Teradata driver with JBoss-3.2.3 application server. We have a datasource deployed on the server. We are seeing the following exception when getConnection is invoked on the datasource:Caused by: java.lang.NullPointerException at com.ncr.teradata.jtdgss.TdgssConfigApi.InquirePropertiesForMech(DashoA13*..) at com.ncr.teradata.TeraEncrypt.getClientDefaultMech(TeraEncrypt.java:687) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:77) at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:113) at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.(TeraLocalConnection.java:128) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:211) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:150)This exception occurs very frequently. Does anyone know the reason/solution for the same?Thank you.

25495 views
3 replies, 2 years ago
JDK 1.3 and JDBC 3.03 Topic by Natalia 06 Apr 2006

Hello!I have a system development on JDK 1.3 and I need to use JDBC 3.03 to connect to Teradata V2R6.1.I try but I couldn't and the documentation says that I need JDK 1.4.Do you know if it is possible? I can't change JDK.Thanks a lot.

15791 views
1 reply, 2 years ago
Connect to Teradata database from web application using JDBC Topic by Jaguar 10 May 2006

Hi , can anyone provide me the jdbc settings (to be given in unix environment) that are required to connect to Teradata database from a web application.Also is there any way in which i can invoke teradata scripts within oracle pl-sql scripts.can anyone pls provide me with details of the settings?any info. provided would be appreciated.Thnx

21782 views
2 replies, 2 years ago
Inserting strings in UTF-8 Teradata using JDBC Topic by Vesoni 23 Jun 2006

Hi,How can insert UTF-8 bytes in Teradata in java using Teradata JDBC drivers?When I try with setBytes(int index, bytes[]) methodI get Conversion bteween BYTE data and other types is illegal.Any help?Veso

20199 views
2 replies, 2 years ago
teradata data source connection on Websphere on Windows Topic by Paulo 18 Aug 2006

I am trying to set a Websphere 5 application server data source to connect to a teradata db elsewhere. I can use jdbc/odbc connections fine in this server to connect to that same db. But when I try using the data source connection I get:"E SRVE0026E: [Servlet Error]-[Can't find library terajni 'terajni.dll' in java.library.path".The configuration I am using works in another box. A UNIX based Websphere application server. My computer has Windows XP and I tried type-2 and type-4 drivers with similar results. Last download was TeraJDBC.03.02.00.03.zip. Does anyone know the solution for this issue? Any clues?

15536 views
1 reply, 2 years ago
FastLoad from Java Topic by c3800s 15 Nov 2006

Hello,I want to connect a Java application to a Teradata DB (via JDBC) and insert about one million records in a table, but I need the fastest way to do it.I've tried to insert using the executeUpdate method of the PreparedStatement interface, but the insert ratio was 20 records per second.The last JDBC driver includes a package with the classes that make possible to execute FastLoad from Java which would be the solution I need.The problem is that there is no documentation for this way of insertion from a Java application (at least, I couldn't find it) and I want to know how to do it.I've tried this code, but I've got an error:---------TeraDriver tdDriver = (TeraDriver)Class.forName("com.ncr.teradata.TeraDriver").newInstance();DriverManager.registerDriver(tdDriver);//With the PARTITION parameter I specify I'll use FastLoad and the DriverManager will return a FastLoadConnectionConnection con = DriverManager.getConnection("jdbc:teradata://servername/PARTITION=FASTLOAD", "user", "pwd");con.setAutoCommit(false);//The FastLoadConnection will return a FastLoadPreparedStatementPreparedStatement stmt = con.prepareStatement( "INSERT INTO TABLE (" + "FIELD1, " + "FIELD2, " + "FIELD3, " + "FIELD4" + ") " + "VALUES (?, ?, ?, ?)");//Iterates over a collectionwhile(it.hasNext()) { o = it.next(); stmt.setString(1, o.getField1()); stmt.setString(2, o.getField2()); stmt.setDouble(3, o.getField3()); stmt.setDate(4, new Date(o.getField4().getTime())); stmt.addBatch();}//Finally, I execute FastLoadint [] numInserts = stmt.executeBatch();----------------------The executeBath throws an Exception:[NCR] [Teradata DBMS] : The DBS restarted between FastLoad or MLoad requests.Please help!Thanks a lot.PD: Sorry for my English

15042 views
1 reply, 2 years ago
JDBC driver for WAS 6.1 Topic by sassman 14 Mar 2007

Any idea on when the JDBC driver will be certified for WAS 6.1? Is the certification process underway?Thanks!

13502 views
1 reply, 2 years ago
Is it possible to do connection pooling and recognize the user at the same time? Topic by Allan Pomeroy 07 May 2007

We want to use connection pooling in Teradata JDBC, but also to set the user context for each SQL statement to reflect the individual user on behalf of whom the application is making the individual request, in a way that can be recognized by our database views so they can use the individual userid to enforce row-level security. Is this possible in Teradata? If so, how do we accomplish it?I searched the Archives and read the JDBC user manual. Unfortuantely I didn't see an answer in either of those sources. I'd appreciate any help you can offer.ThanksAllan Pomeroy

14580 views
1 reply, 2 years ago
JDBC error: Error tdgss-stack-trace-begin Topic by jsergey 19 Jul 2007

I really don't know how to fix this problem because I don't know, what is the problem???Caused by: java.sql.SQLException: [NCR] [Teradata JDBC Driver] : TeraEncrypt: Error tdgss-stack-trace-begin>>> java.lang.NullPointerExceptionat com.ncr.teradata.jtdgss.TdgssConfigApi.GetInforForOID(DashoA14*..)at com.ncr.teradata.jgssp2td2.Td2Context.GetTrailerBytes(DashoA14*..)at com.ncr.teradata.jgssp2td2.Td2Context.BuildInitMsg(DashoA14*..)at com.ncr.teradata.jgssp2td2.Td2Context.initSecContext(DashoA14*..)at com.ncr.teradata.jtdgss.TdgssContext.initSecContext(DashoA14*..)at com.ncr.teradata.TeraEncrypt.initSecContext(TeraEncrypt.java:422)....................................................................<< at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:126)at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:106)at com.ncr.teradata.TeraEncrypt.transformException(TeraEncrypt.java:92)at com.ncr.teradata.TeraEncrypt.initSecContext(TeraEncrypt.java:425)at com.ncr.teradata.jdbc_4.statemachine.AssignState.action(AssignState.java:91)at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:121)at com.ncr.teradata.jdbc_4.TDSession.(TDSession.java:148)at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.(TeraLocalConnection.java:89)at com.ncr.teradata.TeraDataSource.getConnection(TeraDataSource.java:821).........................................................................................Some additional information:Jdbc Driver: TeraJDBC.03.03.00.04Websphere 6.1JVM 1.5

21212 views
2 replies, 2 years ago
Problem while connectiong Teradata from Java Topic by madhuramesh 03 Oct 2007

Hi, I am trying to connect Teradata from java using Teradata JDBC Driver. I am using RAD 6.0 IDE. I am getting following exception , can anyone help me please? Exception :[10/3/07 11:15:20:581 PDT] 0000003e FreePool E J2CA0046E: Method createManagedConnectionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/TDDataSource, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: [NCR][Teradata JDBC Driver]:TeraConnection: getHoldability: function not supported in this version. with SQL State : HY000 SQL Code : 779 at com.ncr.teradata.ComUtil.ThrowExcp(ComUtil.java:1770) at com.ncr.teradata.TeraConnection.getHoldability(TeraConnection.java:804) at com.ncr.teradata.TeraLogicalConnection.getHoldability(TeraLogicalConnection.java:468) at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getHoldability(InternalGenericDataStoreHelper.java:362) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.(WSRdbManagedConnectionImpl.java:646) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:941) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1502) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1294) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:2000) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:769) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:569) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:328) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:297) at com.covansys.ebiz.ti.db.TeraDataConnectionPool.getConnection(TeraDataConnectionPool.java:59) at com.covansys.ebiz.ti.db.DatabaseConnectionManager.getConnection(DatabaseConnectionManager.java:63) at com.covansys.ebiz.ti.db.dao.DataAccessObject.getConnection(DataAccessObject.java:276) at com.covansys.ebiz.ti.db.dao.DataAccessObject.prepareDynamicStatement(DataAccessObject.java:320) at com.covansys.ebiz.ti.db.dao.DataAccessObject.readDynamic(DataAccessObject.java:395) at com.gap.size.dao.StyleResultsTDDAO.getResultsForStyleColor(StyleResultsTDDAO.java:77) at com.gap.size.dao.StyleResultsTDDAO.getStyleColorResults(StyleResultsTDDAO.java:46) at com.gap.size.model.POListingController.getUpdatedTerraData(POListingController.java:2109) at com.gap.size.model.POListingController.consolidatePOListing(POListingController.java:157) at com.gap.size.formaction.POLoadAction.populatePOs(POLoadAction.java:1480) at com.gap.size.formaction.POLoadAction.postProcess(POLoadAction.java:1085) at com.covansys.ebiz.query.QueryAction.executeSecure(QueryAction.java:286) at com.gap.size.formaction.POLoadAction.executeSecure(POLoadAction.java:1129) at com.covansys.ebiz.struts.SecureAction.execute(SecureAction.java:55) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2837) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220) at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))Additional information :IDE : RAD 6.0Driver verson : Tera Data JDBC Driver 03.01.00Any help appreciated.-Ramesh

18092 views
1 reply, 2 years ago
Incorrect characters returned in UTF8 session Topic by yulian 17 Mar 2008

When using JDBC to retrieve characters from a char column in UTF8 charset session, we get a character string of double the size of the column length. Does anyone know why and how to workaound it?For example: 1. connect to the database in UTF8 sessionjdbc:teradata://td/CHARSET=UTF82. create table and insert dataCREATE TABLE employee (empName CHAR(10));INSERT INTO empolyee values('a');3. SELECT empName from employeeThe length of empName is 20. (Wrong!)4. connect to the database in default charset sessionjdbc:teradata://td5. SELECT empName from employeeThe length of empName is 10. (Correct!)I'm using JDBC Driver 12.0.0.1 and the database is V2R6.

14189 views
1 reply, 2 years ago
JDBC v3.03.00.00 not passing props, including DSName Topic by dkarr-5910 05 Apr 2008

I'm helping to diagnose some issues with using the Teradata JDBC driver v3.03.00.00 from WebLogic 9.2. I believe I discovered that this version of the driver ignores the Properties object passed into the getConnection() method. Can anyone confirm that?Assuming that's true, since our WebLogic ConnectionPool setting was attempting to set the DSName property, what would be the possible impacts if that property was not set? It seems redundant to me, as our connection string is using an IP address, and the value we were attempting to set for DSName was the same IP address.I now know that the workaround for it not using the Properties is simply to append each property setting at the end of the URL (comma-separate), I'm just trying to understand what the impact would have been if the property wasn't set.

13206 views
1 reply, 2 years ago
JDBC not doing cop discovery - unknown host Topic by rs131112 28 Mar 2008

I'm accessing 2 different Linux servers, same JDBC (3.02). I am not the server administrator. Using server1, I can successfully connect to the database using the "hostname", and JDBC does the "cop discovery" just like it is supposed to. On the server2, if I just use the hostname, I get an "unknown host" error message. If I specify a specific "cop" name, then I can get connected.

18393 views
2 replies, 2 years ago
Does JDBC driver v3.3.0.0 silently ignore batch mode? Topic by dkarr-5910 07 Apr 2008

While searching various sites yesterday, I thought I read that the TeraData JDBC driver (at some version) has a bug that causes it to ignore "batch mode", such that multiple statements submitted in the same transaction would be sent to the database separately, instead of in a batch (batching would make it more efficient).

17145 views
2 replies, 2 years ago

Pages