At this point you should already be familiar with Eclipse. But if you are not, Eclipse is the de facto integrated development environment (IDE) for developing Java applications. It provides comprehensive support for Java technologies, as well as a platform for plug-in tools to extend its capabilities. Teradata Plug-in for Eclipse extends the Eclipse IDE with plug-ins that support Teradata application developers. It provides dialogs and wizards to ease the techincal and operational challenges when creating database objects, such as databases (or schemas), tables, stored procedures, user-defined functions, etc. Teradata Plug-in for Eclipse is targeted at improving the productivity of Java oriented developers by bringing more of their activities into a single Eclipse based IDE.

Supported Platforms

The computer where the Teradata Plug-in for Eclipse will be installed must be running one of the following operating systems:

Operating Systems

Platforms

Windows 7
  • Mircrosoft Windows 7 (32-bit and 64-bit)
Windows 8
  • Mircrosoft Windows 8 (32-bit and 64-bit)
Windows Vista
  • Microsoft Windows Vista, running on Intel x86 (32-bit)
Windows Server 2003
  • Microsoft Windows Server 2003 Enterprise and Standard Editions, with SP2, running on Intel x86 (32-bit)
  • Microsoft Windows Server 2003 Enterprise and Standard Editions, with SP2, running on Intel Itanium (32-bit)
Windows 2000
  • Microsoft Windows 2000 Professional Server and Advanced Server, with sp4, running on Intel x86
     

Apple Mac OSX

  • Apple Mac OSX 10.6, 10.7, 10.8, 10.9, and 10.10

 

Installation

Before we can start using the Teradata Plug-in, we need to create our Eclipse DTP environment. The first step is to download the required software: Java Runtime Environment (JRE), Eclipse, and DTP software.

The following packages need to be installed:

Teradata Plug-in for Eclipse requires Eclipse (Mars) version 4.5.2

Eclipse has bundled the required packages (Eclipse SDK, EMF, SDO, GEF, DTP, and WTP) into a single download, Eclipse IDE for Java EE Developers.

Simply unzip the zip files or, in the case of the JRE, run the execution file.

Start Eclipse

Next, bring up Eclipse by double clicking on eclipse/eclipse.exe. Eclipse will prompt you for a Workspace folder that it uses to maintain the metatdata for your Eclipse session. You can browse your directory for an existing workspace folder or enter the name for your new workspace. It is recommended that you enter a name relavent to your developement, for example 'JXSP_workspace' for your Java external stored procedure development.

Next a Welcome screen will appear. Click the ‘X’ at the top left hand corner to close the 'Welcome' tab.

Install Teradata Plug-in

NOTE: Mars JEE Eclipse bundle is missing the EMF Client Platform (ECP) 1.9.0 packages. Before installing the Teradata Plug-in, you must:
     -  Install the EMF Client Platform 1.9.0 by going to the Eclipse Help menu, selecting Install New Software... and entering the EMF ECP 1.9.x Update Site: http://download.eclipse.org/ecp/releases/releases_19/.

Note: If you have the previous version of EMF ECP installed, you want to remove it from Eclipse before installing the new version.

To install the new version:

     -  Press the Add... button to add the location of the EMF ECP 1.9.0 Update Site (see image below).

     -  Choose this site and install the "ECP SDK 3.x" in the "All SDKs" category. Press Next to install EMF ECP.

                                 
    

     -  Before letting Eclipse restart to finish the installation, remove the file

            plugins\org.eclipse.emf.ecp.view.swt.layout_versionNumber.jar

     - To remove this plugin, locate your Eclipse directory, and delete plugins
               \org.eclipse.emf.ecp.view.swt.layout_<versionNumber>.jar

     -  Restart Eclipse, File>Restart

     -  Install Teradata Plug-in for Eclipse

Install Teradata Plug-in from the Teradata Datatools Update Site. Within Eclipse, go to the Help menu and click the Install New Software... option. From the Available Software screen, click the Add button to add the Teradata Update Site.

In the Add Site pop up window, enter the Teradata Update Site URL in the Location field (http://downloads.teradata.com/download/cdn/tools/tdide/tdide-15.12.00.00/update/site.xml). Click OK. You should notice that the Teradata update site is displayed in the 'Work with:' window and the Teradata Plug-in for Eclipse category is displayed in the Name/Version list. If the update site is not in the Available Software list, go to the top of the list and select --All Available Sites--. This should display the full list of update sites it knows about. You should find the site in the list and check the box.

 

The Teradata Plug-in for Eclipse is divided into seven features: Teradata Basic Functionality, Teradata DTP Enhancements, Teradata DTP Refactor, Teradata DTP Support, Teradata Java Development, Teradata Plug-in for Eclipse, and Teradata XML Services. Select the top level category, Teradata Plug-in for Eclipse, to include all of the Teradata Plug-in features. Note: Uncheck the 'Contact all update sites during install to find required software' to avoid unnecessary searching of Eclipse update sites. Click Next to verify the Install Details and License Agreement. Click Finish. After the install, Eclipse will prompt you to restart Eclipse. Click Yes.

Create a Connection Profile

The next task is to create a connection profile for your Teradata Database. Make sure that the Eclipse Data Source Explorer View is opened. Eclipse Views provide an alternative presentation of the data, as well as an additional way to navigate information in the Eclipse workbench. The Data Source Explorer View provides a tree view of the database objects and tools for running routines and viewing results.

To open the Data Source Explorer View, click the Window>Show View>Other... option in the top-level menu. Double click on the Data Management>Data Source Explorer item. You will notice the Data Source Explorer (DSE) tab in the workspace. Drag the tab over to the left hand pane for more space to browse the databases and their associated database objects, such as tables, columns, stored procedures, macros, user-defined functions, user-defined types, indexes, and views.

To create a Teradata, Aster, or Hadoop connection profile, right click on the Database Connections folder in the Data Source Explorer and select the New… option. The New Connection Profile wizard will display the list of Connection Profile Types. Choose the Teradata Database, Aster Database, or Hadoop System type and enter a name for your profile. Click Next to launch the New Teradata Connection Profile, New Aster Connection Profile, or New Hadoop Connection Profile wizard. If this is your first time installing the Teradata Plug-in you will need to click on the New Driver Definition icon,, and select the Teradata Embedded JDBC Driver or Aster Embedded JDBC Driver. Otherwise, the Teradata or Aster Embedded JDBC Driver template has been selected for you depending on which type you have selected.

Next, enter the Database Server Name, User Name, Password and Database values. The Authentication Mechanism allows you to choose an advanced logon mechanism such as LDAP or Kerberos or select the default, PASSWORD_PROTECTED, mechanism. If you wish to save your Password to disk, check the Save Password box. Otherwise, the password is stored in the profile and only active throught the Eclipse session. When Eclipse is closed, the unsaved password is removed before the profile is written to disk, and you will be prompted for the password the next time you connect to that profile.

You can also add or modify JDBC properties for your connection. Click the Add button. This will bring up another dialog for you to select the JDBC property and its value and add it to the list. Or to remove an attribute, select it from the list and click the Remove button.

The Save Properties button will save the JDBC properties to an external file in the workspace. The external file is called jdbcConnectionProperties.properties and located in the workspace .metadata/Teradata directory. The jdbcConnectionProperties.properties file allows you to share a set of JDBC properties with other Teradata Plug-in users. If the file exists when creating a new Teradata connection profile, it will load those property values into the list of JDBC connection properties. If the file exists but it is empty, the connection wizard will assume that no JDBC properties are specified and the Teradata JDBC driver will use the default settings.

Another option is to Cache the Schemas (or databases) for the connection. This feature allows you to cache the schema metadata to disk, saving time when loading the objects in the Data Source Explorer. Click on the Cache Properties button to bring up the Cache Schema dialog.

  

Optionally, you can click the Test Connection button to verify that your connection profile definition is correct. Click Finish to return to the DSE and connect to your Teradata Database.

To provide a different Teradata or Aster JDBC driver, click the New Driver Definition icon, , to the right of the drop-down list. Select the Teradata or Aster External JDBC Driver template from the list of available driver templates. Next, click the Jar List tab to enter the Jar list for the JDBC driver. Click the Add JAR/Zip button to select your Teradata JDBC driver Jars. Click OK to return to the New Teradata Connection Profile wizard.

 

For Hadoop, enter the WebHDFS Hostname, WebHDFS Port number, and System Username. The Hadoop connection uses the WebHCat interface to gather information about the Hadoop system.

                                                    

You now have a Teradata or Aster Database, or Hadoop System connection profile that you can use to browse the databases and their database objects or invoke the ‘Create’ actions (Teradataand Aster only) to create new database objects, such as Users, Databases, Tables, Macros, Views, or Stored Procedures. By right clicking an entry in the Data Source Explorer tree, the Teradata, Aster, or Hadoop menu option will appear. Open this option to find the appropriate actions for the system selected.

Administering Objects: Navigator View, Filter View, and Object List Viewer

The Navigator View allows you to select the connection profile for administering objects.

The Filter View allows you to filter the objects displayed in the Object List Viewer.

The Object List Viewer provides a list of the objects and 'Open' actions to view more detailed information about the objects. The Object List Viewer toolbar and menus include actions to create and administer database objects.The Object List Viewer displays the list of objects and options to 'Open' an object to display more detailed information about the database object. Select a connection and category from the Navigator View. You can expand the Databases category in the Navigator or drill into the list within the Object List Viewer.

Double-click on a database (or schema) in the Navigator to display the list of tables. Choose the toolbar or menu action to show other objects for a database or schema.

Another option for browsing information about the Teradata Database objects is the ‘Open in Property Form’ option. This option will open the property forms and display more detailed information for the objects that are selected in the Data Source Explorer. In the example below, the ‘copy_db’ database has been selected in the DSE and the ‘Open in Property Form’ option was selected.

Create a Teradata Project

A Teradata Project is an extension of a Java Project in Eclipse. It provides project preferences to help the developer when building Teradata Java objects, such as Java stored procedures, Java user-defined functions, JavaBeans, and Spring DAOs. The preferences include a standard folder layout for placing your project source and test code, libraries, as well as configuration and resource files. Also included in the Teradata Project is a set of Teradata libraries. These libraries include the Java Function library (javFnc.jar), Teradata Commons Access library (tdcommons-access.jar), and Teradata Commons Context library (tdcommons-context.jar). These libraries are often accessed from Java stored procedures or JavaBeans. The Java stored procedure, JavaBean, and Spring iBatis Wizards have been enhanced to take advantage of the new functionality from the Teradata libraries.

Teradata Project Wizard

To create a new Teradata Project, select the File>New>Other... option from the main toolbar. Open the Teradata Wizards folder and select Teradata Project and click Next. The Teradata Project wizard will create a new Eclipse project using the folder names as specified in the Teradata Project Preferences.

NOTE: If you are creating Java stored procedures or user-defined function, make sure the JRE environment for your Teradata Project is set to JRE 1.5.

Enter a project name and click Next to view your project options. Click Finish to create your Teradata Project.

Configuration Options for Java Stored Procedures and Java User Defined Functions

Teradata SQLJ

If you are creating a Java stored procedure, make sure that you have selected a system that has Teradata Database version 12.0 or greater. If you are creating a Java user-defined function, make sure that you have selected a system that has Teradata Database version 13.0 or greater. Along with the correct version of Teradata, you must also have the SQLJ feature installed. SQLJ can only be installed on 64-bit server machines. For smaller, laptop configurations, Teradata Express Edition also supports SQLJ features. Teradata Express can be found on the Teradata Download Center.

SQLJ contains stored procedures and views used to manage the JARs used by Java stored procedures and Java user-defined functions. A JAR or Java Archive is used for aggregating many Java class files into one. It is used to deploy the Java classes on the Teradata Database. If you click on the SQLJ schema and open the Stored Procedures folder, you should see several stored procedures, such as install_jar, replace_jar, remove_jar, and alter_java_path. You must also have ‘Execute Procedure’ permissions granted on the SQLJ database.

SQLJ is installed by running the SQLJ Database Initialization Program (DIP) script called DIPSQLJ. DIP is a series of executable script files packaged with Teradata Database. Refer to the Teradata Utilities documentation for more detailed information on running DIP.

Java Compliance Level

If you are using Java Runtime Environment version 1.6 (jre6), your compiler must have the compliance level set to 1.5 when creating Java stored procedures or Java user-defined functions on Teradata. The reason for this is that the JRE version used by Teradata is 1.5 and classes compiled with JRE 1.6 are not compatible. In order to set the compliance level, select the Window>Preferences option from the top-level menu. This will bring up the Preferences popup dialog. Open the Java>Compiler preference and change the 'Compiler compliance level' to '1.5' from the drop down list. Click the Apply, then OK button to close the preferences dialog.

 Online Help

Additional information on using Teradata Plug-in for Eclipse is provided in the form of online Help. To open the Help content, click Help>Help Contents from the main toolbar.

What's Next?

You are now ready to browse your Teradata database systems or create new database objects. The Teradata Plug-in for Eclipse provides the following easy to use features:

Each of these functions simplifies the effort required to develop active applications using Java and Eclipse.

To ask questions or discuss issues, refer to the Teradata Studio Forum and post your question.

Discussion
forpartha 2 comments Joined 06/10
07 Jun 2010

Hello, really nice and informative article. I have downloaded Teradata 13.0 Express for Windows and this was the first exercise which actually let me browse the database objects. I also want to run some ad-hoc SQL queries so wondering if this plugin might be of help, since you mention about an "Ad hoc SQL Editor" and facilities for "SQL Editor Templates...".

Would be so kind as to inform how to locate and use these? I have not found any other tools/interface with TD 13.0 Express for ad-hoc SQL processing.

Regards,

Parthasarathi Dutta Sharma

fgrimmer 660 comments Joined 04/09
07 Jun 2010

Ad-hoc SQL queries are entered into a SQL file. You can create a new SQL file either by clicking on the 'Open scrapbook' icon in the Data Source Explorer (upper right hand toolbar within the Data Source Explorer) or by clicking on the File>SQL File in the top main toolbar. Before you create your SQL file, you will want to create a new Project for your SQL files.

To create a new Project:
From the top main toolbar, click on File>New Project. The New Project dialog will appear. Choose the General>Project menu option. Next, enter a Project name. Leave the Use default location box checked. Click Finish. Open the Project Explorer View to browse your projects. You can open the Project Explorer View by clicking the Window>Show View>Others... option from the top main toolbar. In the Show View dialog, choose the General>Project Explorer option and click OK. Now that you have a project for your SQL files, right click on your project and select New>SQL File.

In the Create SQL File dialog, enter a File name and select the Database server type for your version of Teradata Database. Then select your Connection profile name that you create to Browse your Teradata Database.

Within the SQL Editor, you can begin typing your ad-hoc SQL statement. To use the SQL Templates, at the beginning of the SQL statement hit the CTRL SPACE keys. A pop up list of keywords and templates will appear. Scroll down to the bottom for the list of SQL templates. Once you have selected a template, you can use the TAB key to move from value to value for the template.

Once you have entered your query, right click in the SQL Editor window and a menu will appear for options to execute your query.

Also note that there are help pages available for Teradata Plug-in for Eclipse. Click the Help>Help Contents option from the top main toolbar.

I hope this is helpful.

kerr.ding 1 comment Joined 06/11
07 Jun 2011

excellent.

logc 3 comments Joined 09/05
16 Jun 2011

Is is possible to use the plug-in to generate fastload/fastexport scripts? I have found that I can fastload data from my desktop but don't see the script or an option to view it. The history only shows something like: FastLoad of: "databaseName"."tableName". Also, how do you find more detailed error messages? In the history window when a fastload fails, I see something like: Failed [ Elapsed time = 00:00:01.219 ] STATEMENT 1: FASTLOAD failed.

Thanks!

fgrimmer 660 comments Joined 04/09
16 Jun 2011

Currently, it does not generate scripts for these operations. Fastload and Fastexport are using the JDBC FASTLOAD or FASTEXPORT option. In the case of FastLoad, it builds an INSERT statement that is runs using a JDBC prepared statement.

To see the complete error trace, look in the Note column of the SQL History entry.

logc 3 comments Joined 09/05
17 Jun 2011

Thanks.

sundaramt 1 comment Joined 04/10
27 Jul 2011

I downloaded Teradata plugin for Eclipse and installed it. I'm able to connect to Teradata database. But when I try to use XML services, I'm getting the error 'could not generate XSD.
com.teradata.jdbc.jdbc_4.util.JDBCException[TeraJDBC 13.10.00.20]
[Error 7504][SQLState HY000] in UDF/XSP/UDM SYSXML.GEN_QUERY_
CANONICAL_SCHEMA_U:SQLSTATE U0027: Failed to create a CLI connector'. Pls help

JeffSmith 2 comments Joined 07/11
27 Jul 2011

Hello, I am getting the following error when creating a connection --
Error loading new wizard in "com.teradata.datatools.dtp.connectivity.db.teradata"!
Plug-in com.teradata.datatools.dtp.connectivity.db.teradata was unable to load class com.teradata.datatools.dtp.connectivity.db.teradata.NewTeradataConnectionProfileWizard.
Bad version number in .class file

JeffSmith 2 comments Joined 07/11
27 Jul 2011

I was able to resolve this ... after looking at the error message I realized I was launching Eclipse with Java 1.5 and not 1.6.

tr185028 1 comment Joined 10/10
13 Dec 2011

An excellent and detailed article

fgrimmer 660 comments Joined 04/09
16 Mar 2012

There was a bug in Eclipse with overloading functions that we have recently fixed. The fix will be available in our upcoming release of Teradata Plugin for Eclipse that is due out mid June.

ChWaqas 1 comment Joined 02/12
22 Mar 2012

Thanks for your reply. Is it just a problem of eclipse plugin or is it an overall problem with overloading functions as I tried to do it manually but I am getting error of Function already exists. here is how I am trying to create functions

CREATE FUNCTION myFunction("number" BIGINT, "limit" INTEGER)
RETURNS BIGINT
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(long, int) returns long';

CREATE FUNCTION myFunction("number" VARCHAR(256), "limit" INTEGER)
RETURNS VARCHAR(256)
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(String, int) returns String';

Can you please guide me what am I doing wrong?

js185064 48 comments Joined 03/09
22 Mar 2012

You need to use a specific name (See below).

CREATE FUNCTION myFunction("number" BIGINT, "limit" INTEGER)
RETURNS BIGINT
SPECIFIC myFunction1
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(long, int) returns long';

CREATE FUNCTION myFunction("number" VARCHAR(256), "limit" INTEGER)
RETURNS VARCHAR(256)
SPECIFIC myFunction2
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(String, int) returns String';

textures21 1 comment Joined 01/05
26 Apr 2012

When will OSX support be introduced?

fgrimmer 660 comments Joined 04/09
27 Apr 2012

We currently do no have plans to add support for OSX.

borlanges 3 comments Joined 10/09
14 Jun 2012

I'm able to connect to Teradata database. But when I try to use XML services, I'm getting the error 'could not generate XSD.
com.teradata.jdbc.jdbc_4.util.JDBCException[TeraJDBC 13.10.00.20]
[Error 7504][SQLState HY000] in UDF/XSP/UDM SYSXML.GEN_QUERY_
CANONICAL_SCHEMA_U:SQLSTATE U0027: Failed to create a CLI connector'. Pls help
.

fgrimmer 660 comments Joined 04/09
14 Jun 2012

@borlanges: The error indicates that the UDF failed. From looking at past notes that I had on Teradata XML Services, it could be a CLI problem. In my case, the tester was using Teradata 12.0 system and had to reinstall CLIv2 version 12.0. Then restart Teradata.

borlanges 3 comments Joined 10/09
14 Jun 2012

@fgrimmer ..I was able to sucessfull work till last friday..Am using XML services since 2009.Saturday we had a upgrade to 13.10 so where problem had started.

Note : I was able to query the tables sucessfully.Am not able to create XSLT using eclipse.
I was able to query the tables using SQA and not able to run few XML related procedures.Ex:
CALL Failed. 7504: in UDF/XSP/UDM SYSXML.GEN_DB_CANONICAL_SCHEMA: SQLSTATE U0027: Can't connect to db

fgrimmer 660 comments Joined 04/09
15 Jun 2012

@borlanges Can you provide more information on which version on Teradata XML Services you are using. Which version of CLIv2? Also was it Teradata Plugin 13.10? Which version of Teradata are you connecting to? thanks.

borlanges 3 comments Joined 10/09
20 Jun 2012

Database :
RELEASE 13.10.03.03
VERSION 13.10.03.06

XML Services
TeradataXML_LINUX_v13.10.00.01

Teradata Plugin
Teradata Plug-in for Eclipse 14.01.00.00

Teradata JDBC :
TeraJDBC__indep_indep.13.10.00.31

CLIv2 13.10.0.3 -- Client Version. Not sure yet database end

Thankyou.

wjm7605 1 comment Joined 07/12
26 Jul 2012

When I click on Cache Selected Schemas I get the an error when it is trying to create a connection:
Error trying to create connection:
comm.teradata.jkbc.TeraDriver
Resolve connection error(s) and try again
Test Connection works fine and I can query the databases.

Also, when copy and pasting form the result set view, is there a way to copy the column headers as well? I am only getting the data.

Chuckbert 37 comments Joined 07/09
27 Jul 2012

@wjm7605 When you get the Connection Error message, what appears in the message box between the "Error trying to create connection:" and "Resolve connection error(s) and try again"?

Chuckbert 37 comments Joined 07/09
27 Jul 2012

@wjm7605 The Copy Cells action of the Result Set view copies the selected cell values. The column names aren't really cell values so they are not included in the copied data.

Is it possible to use one of the Save/Export formats for what you need? Those operations save the full results (not just the selection) with the columns' names.

inah 2 comments Joined 09/12
11 Sep 2012

Hi, can we include SELECT statements inside a UDF/JUDF? Thanks.

js185064 48 comments Joined 03/09
12 Sep 2012

You cannot run SQL in a Java UDF. However, you can with a C UDF but it may have performance issues.

txasmst 3 comments Joined 11/12
19 Nov 2012

@fgrimmer: I dowloaded Teradata Express and Studio Express. How can I make connection with either existing database: tdadmin or tduser? Or how I create a new database to start using the studio express tool? Thanks.

txasmst 3 comments Joined 11/12
20 Nov 2012

@fgrimmer:I figured out to connect to tduser database from Studio Express. Thanks any way.

fgrimmer 660 comments Joined 04/09
21 Nov 2012

@txasmst, Glad you got your connection working. Teradata Studio provides dialogs to help you create Schemas and Users. There is also Help available to assist you with using the dialogs, as well as SQL Templates available in the SQL Editor.

To use the SQL Templates, open a SQL Editor from your connection profile and enter Cntrl+Space. You should see a pop up list of possible words or SQL templates (scroll down). Select CREATE SCHEMA or CREATE USER to display the SQL for creating a database/schema or user.

Alex543 2 comments Joined 07/12
11 Dec 2012

Is there an option to display databases hierarchically, like in Teradata Administrator?

fgrimmer 660 comments Joined 04/09
12 Dec 2012

Database hierarchies are represented in the Teradata View when displaying the list of Schemas (showing the parent and child relationship). We are looking into adding database hierarchies to the Data Source Explorer.

thomandl 1 comment Joined 05/12
13 Dec 2012

HI Francine,
i'm a newbie at teradata and start with the eclipse plugin, works great. But one thing i'm missing. The code assist for colums doesn't work if i use aliases for tables as well as i not qualify the schema name(at the select oder where clause for each column). I'm confused about that, somebody told me that my conclusion is correct and that doesn' work. See also http://forums.teradata.com/forum/tools/eclipse-teradata-studio-express-code-assist

Have you more information about that?

Best regards JOhannes

me.quinn2 1 comment Joined 10/12
21 Feb 2013

Will the Teradata plugin for Eclipse version 14.02 work with Eclipse Indigo 3.7.2?

fgrimmer 660 comments Joined 04/09
21 Feb 2013

Yes, But you should also update the version of DTP to 1.10.1, as there have been some bugs fixed that were affecting our release.

12 Mar 2013

Install of version 14.02 has failed. This in in a clean downloaded instance of eclipse-jee-juno-win32-x86_64, which opens fine when fresh, and then hangs forever on the eclipse splash screen.  Do you know the problem, or can you help me un-install the plugin so that I can recover and begin using again my formely working eclipse install, with many plugin etc, that I have been running without problems for a while now?
Thanks
Aaron

swatisvl 6 comments Joined 01/13
13 Mar 2013

Dear Grimmer,
I installed Teradata Studio Express. While creating the new connection, Selected "Teradata Database" in connection profile type and named it as "testServer". After this. I gave the details as below
driver type : Teradata Embeded JDBC Driver
Database Server Name : testServer
UserName : testUser
password : DBC
then tried test conncetion. i am getting ping failed. the exception i am getting was as below
 

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Wed Mar 13 09:39:48 PDT 2013 socket orig=testServer cid=180b845 sess=0 java.net.UnknownHostException: testServer   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)   at java.net.InetAddress.getAddressesFromNameService(Unknown Source)   at java.net.InetAddress.getAllByName0(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:183)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:282)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:131)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:117)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:585)   at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:214)   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:34)   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:293)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121)   at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)   at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)   at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)   at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)   at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)   at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)   at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)   at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)  

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206)

at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:138)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:117)

at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:585)

at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95)

at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:214)

at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:34)

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)

at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)

at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)

at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:293)

at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121)

at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)

at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)

at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: java.net.UnknownHostException: testServer

at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)

at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)

at java.net.InetAddress.getAddressesFromNameService(Unknown Source)

at java.net.InetAddress.getAllByName0(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:183)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:282)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:131)

... 21 more

 

Please help me out in Establishing the new connection and work with TD sqls.

fgrimmer 660 comments Joined 04/09
13 Mar 2013

I'm not sure how the Teradata plugins could cause Eclipse to hang? We have installed in Juno with no problem. Can you delete your workspace and try to restart Eclipse? You could try to manually remove the Teradata plugins and features from the Eclipse /plugins and /features directory, but I am not sure if there is other information stored. I would also delete the workspace as well.

fgrimmer 660 comments Joined 04/09
13 Mar 2013

@swatisvl, It looks like from the error message that you do not have a Teradata system called 'testServer'. The connection profile needs to refer to your Teradata system. If you DO have a Teradata system called testServer, verify that you have it defined in your host file. You can also enter an IP address of your Teradata system.

swatisvl 6 comments Joined 01/13
13 Mar 2013

Hi Grimmer,
 
Where do i need to check for the Teradata System Please let me knwo i am totally new to this...

swatisvl 6 comments Joined 01/13
13 Mar 2013

if i install only teradata studio express wont tat suffice to work with teradata databse ? what do i need to install more so that i will have teradat system

fgrimmer 660 comments Joined 04/09
13 Mar 2013

@swatisvl, Teradata Plugin for Eclipse will enable your current Eclipse system to connect to a Teradata Database system, browse the database objects, and execute queries. If you are not a current Eclipse users, it may be easier to use Teradata Studio Express or Teradata Studio to browse your Teradata Database or execute queries. Refer to the following article to show a comparison of the Teradata Studio tools: http://developer.teradata.com/tools/articles/teradata-studio-products-choosing-the-right-client-tool
You can open a Command window (DOS) and 'ping' the Teradata Database system name or IP address  to verify that the system is up and the name is correct. If you do not have a Teradata Database System, you can install Teradata Express.

fgrimmer 660 comments Joined 04/09
13 Mar 2013

Yes, Studio Express will connect to a Teradata Database System. Do you have the name or IP address of your Teradata Database system?

swatisvl 6 comments Joined 01/13
13 Mar 2013

I installed TD-TTU-13.0 and created one ODBC DSN. there i gave the ip address as the result of ipconfig i.e    IPv4 Address. . . . . . . . . . . : 49.204.1.68. here is the result please have a look
C:\Users\Swathi>ipconfig
 

 

Windows IP Configuration

 

 

Wireless LAN adapter Wireless Network Connection:

 

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

 

Ethernet adapter Local Area Connection:

 

   Connection-specific DNS Suffix  . :

   Link-local IPv6 Address . . . . . : fe80::48e5:f125:3ef0:d0f6%11

   IPv4 Address. . . . . . . . . . . : 49.204.1.68

   Subnet Mask . . . . . . . . . . . : 255.255.192.0

   Default Gateway . . . . . . . . . : 49.204.0.1

 

Tunnel adapter isatap.Belkin:

 

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

 

Tunnel adapter Local Area Connection* 9:

 

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

 

now i tried to connect first from TD SQL assistant.  the error i got is 10061:10061 WSA E ConnRefused. The Teradata Server is not ccepting the conncetion.

swatisvl 6 comments Joined 01/13
13 Mar 2013

Dear Grimmer,
 
Can i contact you in this regard? can i get your number ? Please do let me know.

fgrimmer 660 comments Joined 04/09
13 Mar 2013

@swatisvl, I will try to email you.

bs520147 12 comments Joined 04/12
11 Apr 2013

Hello, I have a problem with the installation of Eclipse + Teradata Plug-in. I get to start Eclipse, I get to install Teradata Plug-in but when I try to create a Connection File I cannot select Teradata as a Connection Profile. If I try to install again Teradata Plug-in, I get a message that tell me that the software is already installed. Please could you help me? 

bs520147 12 comments Joined 04/12
11 Apr 2013

Hello, I try to create a new driver definition but I cannot see the 'Teradata Embedded JDBC Driver'.
 

fgrimmer 660 comments Joined 04/09
11 Apr 2013

Did you reboot Eclipse after the install? What version of Eclipse are you using?

bs520147 12 comments Joined 04/12
11 Apr 2013

Yes. I reboot Eclipse, I reboot my laptop. This is the version of Eclipse:
        Eclipse Java EE IDE for Web Developers.
        Version: Juno Service Release 2

fgrimmer 660 comments Joined 04/09
12 Apr 2013

We have not release support for Juno SR2. We currently only support Juno SR1. 

bs520147 12 comments Joined 04/12
13 Apr 2013

Ok. Thank you. I will install Juno SR1.

mersenne127 3 comments Joined 10/09
27 May 2013

Any upcoming release plans for support on Juno SR2?

fgrimmer 660 comments Joined 04/09
28 May 2013

Yes, planned release for Q3 2013.

jb999999 4 comments Joined 09/10
06 Jun 2013

Unfortunately I'm hitting an issue when deploying a Jar using the Eclipse plugin. Using Juno SR1 and Teradata Plug-in for Eclipse 14.2.0.201302060115, essentially the latest available as of today.
This has worked okay previously in the project and none of the code or settings have changed, definitely using jdk1.5, I think there is something incorrect about the "Container" field value or UI field component on the jar files page:

java.lang.StringIndexOutOfBoundsException: String index out of range: -2

at java.lang.String.substring(Unknown Source)

at com.teradata.datatools.jxsp.JXSPJavaUtil.getRootFromContainerName(JXSPJavaUtil.java:695)

at com.teradata.datatools.jxsp.JXSPJavaUtil.createJar(JXSPJavaUtil.java:157)

at com.teradata.datatools.jxsp.editors.JXSPJarFilePage.createJar(JXSPJarFilePage.java:474)

at com.teradata.datatools.jxsp.editors.JXSPJarFilePage.installJar(JXSPJarFilePage.java:236)

at com.teradata.datatools.jxsp.editors.JXSPJarFilePage.access$1(JXSPJarFilePage.java:220)

at com.teradata.datatools.jxsp.editors.JXSPJarFilePage$2.run(JXSPJarFilePage.java:212)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

....

 

 

js185064 48 comments Joined 03/09
06 Jun 2013

It would be helpful if you could give me the container name, JAR name and JAR id of your JAR specifications.

js185064 48 comments Joined 03/09
06 Jun 2013

 
 
Your workspace project maybe out of sync, please try refreshing your project from the Project explorer and try redeploying your JAR.

jb999999 4 comments Joined 09/10
07 Jun 2013

The details from the JAR specification screen for Java Stored Procedure Multi-page Editor is as below:
Container: /teradata_jxsp3
JAR Name: DynamicProcCallerJarFile.jar
JAR ID: DynamicProcCallerJarId
I have tried refreshing the project, restarting Eclipse and unfortunately I get the same error. I can zip up the Eclipse project and send through to an email address.

js185064 48 comments Joined 03/09
07 Jun 2013

I need the following information to help debug your problem:
What operating system are you running on?
Is there any errors in your Project?
Did you refactor anything in your project?
Do you have read write privileges to your Eclipse project? Also check privileges outside of Eclipse.
Did you just upgrade to 14.02 Teradata Plug-in for Eclipse?

jb999999 4 comments Joined 09/10
10 Jun 2013

OS is Windows 7, there are no errors in my project, I didn't refactor anything, I have read and write privileges in and out of eclipse, I installed a new version of eclipse (Juno SR1) and installed the Teradata plug-in for the first time in the IDE.
The very strange thing is that the Jar has deployed successfully, I didn't change any code / project settings, then it stopped working unfortunately.
I can zip up the Eclipse project and send through to an email address?

js185064 48 comments Joined 03/09
10 Jun 2013

 
If you want to send your Eclipse project, you will need to go through Teradata support.
I do have some more things you could check.
What JDK do you have installed on your PC?
Did the Teradata Log have any errors? (The release definition has directions on how to access your log).
You can try an automated Ant build. You can create an automated build on the last page of your Java Stored Procedure Multi-Page editor. (The following article has more details on the Ant build:
http://developer.teradata.com/tools/articles/automating-a-build-for-java-stored-procedures-using-the-teradata-plug-in-for-eclipse). When your run your Ant script, you should use the -v option for the verbose mode.  This may help you debug your problem.

maustin 2 comments Joined 09/13
12 Sep 2013

I have installed Teradata Studio but thinking that I should have installed the Teradata Plug-in for Eclipse to write Java stored procedures and leverage the other Eclipse coding support ... is this true?

fgrimmer 660 comments Joined 04/09
12 Sep 2013

Yes, the Java code support is not provided with Teradata Studio and the Teradata Plugin for Eclipse provides the Teradata Project and Java Stored Procedure, Java UDF, and Web Services Wizards. As you can see above in the article, there are several articles regarding these Java wizards.

maustin 2 comments Joined 09/13
19 Sep 2013

thanks much fgrimmer!

kittudar 2 comments Joined 01/14
24 Jan 2014

Can you please let me know how to create new connection profile for Teradata 14.0 express studio......
 

fgrimmer 660 comments Joined 04/09
26 Jan 2014

Follow the same steps above, Creating a Connection Profile, for Studio Express.

rkbinani 1 comment Joined 05/13
19 Feb 2014

Hi Grimmer
 
Am new to Eclipse and TD. I've followed the steps narrated in the article and tried to install TD Plugin using the site
http://d289lrf5tw1zls.cloudfront.net/tools/tdide/tdide-14.10.01.00/update/site.xml
However, the list of TD Plugins are not displayed. Instead it shows 'Could not find http://d289lrf5tw1zls.cloudfront.net/tools/tdide/tdide-14.10.01.00/update/site.xml on the Name list. While trying to 'Reload' using the 'Available Software Sites' for this link, the following message appears
Unknown Host: http://d289lrf5tw1zls.cloudfront.net/tools/tdide/tdide-14.10.01.00/update/site.xml/content.xml
Unknown Host: http://d289lrf5tw1zls.cloudfront.net/tools/tdide/tdide-14.10.01.00/update/site.xml/content.xml
d289lrf5tw1zls.cloudfront.net
Is there anything am missing? Pls guide.

Raj

fgrimmer 660 comments Joined 04/09
19 Feb 2014

Can you try to download the zip of the plugins and install from local directory? The zip is located on the Teradata Download site, choose Teradata Plug-in for Eclipse.

fgrimmer 660 comments Joined 04/09
21 Feb 2014

@rkbinani, The URL for the Teradata Plugin for Eclipse update site is: http://downloads.teradata.com/download/cdn/tools/tdide/tdide-14.10.01.00/update/site.xml

KSanyal 6 comments Joined 11/14
17 Nov 2014

Hi Team,
I have installed Teradata Studio Express Version 15.00.00.201404081510.
I have installed the HortonWorks Sandbox 2.1. Its working fine and I can access the HDP Sandbox from any browser.
I have also installed the latest Teradata Connector for Hadopp on the Sandbox. It installed fine.
Now when I opened the Studio Express, I am not seeing the "Hadoop System Connection Type" when I click on the Database Connection ->Right Click -> New
Since thats not available, I can't create the Connection Profile for Hadoop where I have to provide WebHDFS details. Bit confused.
Can somebody throw some light ?
Thanks in advance.
Regards
KSunny

fgrimmer 660 comments Joined 04/09
17 Nov 2014

KSunny, You need to download Studio (http://downloads.teradata.com/download/tools/teradata-studio) instead of Studio Express. Hadoop functionality is part of Studio.

KSanyal 6 comments Joined 11/14
18 Nov 2014

Figured that out last night :-) Now I have the ability to create a profile. But now my error nessage is different when I try to connect to Hortonworks Hadoop using my connection profile "My Hadoop System"-
Could not connect to My Hadoop System.
Error creating SQL Model Connection connection to My Hadoop System. (Error: Hadoop not configured to run jobs by this application.)
Hadoop not configured to run jobs by this application.
Error creating Hadoop System Connection Factory connection to My Hadoop System. (Error: Hadoop not configured to run jobs by this application.)
Hadoop not configured to run jobs by this application.
What configuration needs to be done on the Hadoop side ? Any documentation ?
 
Thanks in advance.
Regards
 

fgrimmer 660 comments Joined 04/09
18 Nov 2014

KSunny, Did You follow the Readme instructions on the download page for running the ConfigureOozie script on the Hadoop system? There is also an article, Smart Loader for Hadoop http://developer.teradata.com/tools/articles/smart-loader-for-hadoop. Also check out the Studio Forum on comments that have been posted regarding connecting to Hadoop. There is an issue mentioned about the Hadoop Sandbox.
You need to edit your client host file to include the IP of the sandbox and sandbox.hortonworks.com.
The Windows host file is here: C:\Windows\System32\Drivers\etc\hosts
And an example addition for my sandbox (your IP will be different) is:  192.168.67.132        sandbox.hortonworks.com

KSanyal 6 comments Joined 11/14
18 Nov 2014

Installed all the latest versions - Eclipse Kepler SR2 + Teradata Plug-in version 15.0.0.201404081046
On the Hadoop side I am running Horton works 2.1. Installed the TDCH rpm as prescribed. Ran configureOozie.sh with proper NameNode (which is exactly same as webHDFS).
The Web UI of HDP is available on the browser. But the hadoop connection profile simply refuses to work.
This is the error I am getting.
java.lang.Exception: Hadoop not configured to run jobs by this application.
 at com.teradata.datatools.hadoop.connectivity.HadoopConnection.open(HadoopConnection.java:126)
 at com.teradata.datatools.hadoop.connectivity.HadoopConnectionFactory.createConnection(HadoopConnectionFactory.java:30)
 at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
 at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
 at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
 at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

 
Bhy the way I have also changed the host file and included the ip for the sandbox when I installed it the first time, as you suggested.
No idea if at all it works !!!

fgrimmer 660 comments Joined 04/09
18 Nov 2014

KSunny, For HDP 2.1 support, you need to install Teradata Plugin for Eclipse 15.00.01 or greater. Please go to the download page and get the latest version of the Teradat Plugin for Eclipse.

KSanyal 6 comments Joined 11/14
19 Nov 2014

Thanks fgrimmer ! It worked. What I did to solve the problem -
1)De-install the Eclipse Kepler SR2
2)Then Install Teradata Studio
Essentially it ended up being a problem right version of plugin. If you use Eclipse Kepler SR2, then go for the right plugin version 15.0.0.1 or >
 

KSanyal 6 comments Joined 11/14
19 Nov 2014

I can now see the hadoop tables from Teradata Studio. I created another data source for a Teradata 15 instance. And then following the "Smart Load for Hadoop" document tried to export a TD table to Hadoop and import a table from Hadoop to Teradata. In both cases I got this error -
 
11/19 05:19:07  INFO Configuration: mapred.input.dir is deprecated. Instead, use mapreduce.input.fileinputformat.inputdir
11/19 05:19:10  INFO HiveUtils: Using hive-site.xml: hdfs://sandbox.hortonworks.com:8020/teradata/hadoop/lib/hive-site.xml
11/19 05:19:11  INFO HiveMetaStoreClient: Trying to connect to metastore with URI thrift://sandbox.hortonworks.com:9083
11/19 05:19:11  INFO HiveMetaStoreClient: Connected to metastore.
11/19 05:19:12  INFO TeradataOutputProcessor: output preprocessor com.teradata.connector.teradata.processor.TeradataBatchInsertProcessor starts at:  1416403152904
11/19 05:19:14  INFO TeradataOutputProcessor: output postprocessor com.teradata.connector.teradata.processor.TeradataBatchInsertProcessor starts at:  1416403154406
11/19 05:19:14  INFO TeradataOutputProcessor: output postprocessor com.teradata.connector.teradata.processor.TeradataBatchInsertProcessor ends at:  1416403154406
11/19 05:19:14  INFO TeradataOutputProcessor: the total elapsed time of output postprocessor com.teradata.connector.teradata.processor.TeradataBatchInsertProcessor is: 0s
11/19 05:19:14  INFO ConnectorExportTool: com.teradata.connector.common.exception.ConnectorException: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1000] [SQLState 08S01] Login failure for Connection to SLES11SP1 Wed Nov 19 05:19:14 PST 2014 socket orig=SLES11SP1 cid=408bb8f3 sess=0 java.net.UnknownHostException: SLES11SP1  at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)  at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901)  at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293)  at java.net.InetAddress.getAllByName0(InetAddress.java:1246)  at java.net.InetAddress.getAllByName(InetAddress.java:1162)  at java.net.InetAddress.getAllByName(InetAddress.java:1098)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:199)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:299)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:147)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:133)  at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:113)  at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)  at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205)  at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)  at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)  at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)  at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)  at java.sql.DriverManager.getConnection(DriverManager.java:571)  at java.sql.DriverManager.getConnection(DriverManager.java:215)  at com.teradata.connector.teradata.db.TeradataConnection.connect(TeradataConnection.java:386)  at com.teradata.connector.teradata.utils.TeradataUtils.openOutputConnection(TeradataUtils.java:86)  at com.teradata.connector.teradata.processor.TeradataOutputProcessor.outputPreProcessor(TeradataOutputProcessor.java:34)  at com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:95)  at com.teradata.connector.common.tool.ConnectorExportTool.run(ConnectorExportTool.java:59)  at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)  at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)  at com.teradata.connector.common.tool.ConnectorExportTool.main(ConnectorExportTool.java:720)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:606)  at org.apache.oozie.action.hadoop.JavaMain.run(JavaMain.java:55)  at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:38)  at org.apache.oozie.action.hadoop.JavaMain.main(JavaMain.java:36)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:606)  at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:225)  at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)  at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430)  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:342)  at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:167)  at java.security.AccessController.doPrivileged(Native Method)  at javax.security.auth.Subject.doAs(Subject.java:415)  at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1557)  at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)
 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94)
 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:69)
 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:207)
 at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:154)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:133)
 at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:113)
 at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)
 at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205)
 at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)
 at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)
 at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)
 at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)
 at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)
 at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)
 at java.sql.DriverManager.getConnection(DriverManager.java:571)
 at java.sql.DriverManager.getConnection(DriverManager.java:215)
 at com.teradata.connector.teradata.db.TeradataConnection.connect(TeradataConnection.java:386)
 at com.teradata.connector.teradata.utils.TeradataUtils.openOutputConnection(TeradataUtils.java:86)
 at com.teradata.connector.teradata.processor.TeradataOutputProcessor.outputPreProcessor(TeradataOutputProcessor.java:34)
 at com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:95)
 at com.teradata.connector.common.tool.ConnectorExportTool.run(ConnectorExportTool.java:59)
 at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
 at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)
 at com.teradata.connector.common.tool.ConnectorExportTool.main(ConnectorExportTool.java:720)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:606)
 at org.apache.oozie.action.hadoop.JavaMain.run(JavaMain.java:55)
 at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:38)
 at org.apache.oozie.action.hadoop.JavaMain.main(JavaMain.java:36)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:606)
 at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:225)
 at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
 at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:342)
 at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:167)
 at java.security.AccessController.doPrivileged(Native Method)
 at javax.security.auth.Subject.doAs(Subject.java:415)
 at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1557)
 at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)
Caused by: java.net.UnknownHostException: SLES11SP1
 at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)
 at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901)
 at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293)
 at java.net.InetAddress.getAllByName0(InetAddress.java:1246)
 at java.net.InetAddress.getAllByName(InetAddress.java:1162)
 at java.net.InetAddress.getAllByName(InetAddress.java:1098)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:199)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:299)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:147)
 ... 40 more
 at com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:111)
 at com.teradata.connector.common.tool.ConnectorExportTool.run(ConnectorExportTool.java:59)
 at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
 at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)
 at com.teradata.connector.common.tool.ConnectorExportTool.main(ConnectorExportTool.java:720)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:606)
 at org.apache.oozie.action.hadoop.JavaMain.run(JavaMain.java:55)
 at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:38)
 at org.apache.oozie.action.hadoop.JavaMain.main(JavaMain.java:36)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:606)
 at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:225)
 at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
 at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:342)
 at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:167)
 at java.security.AccessController.doPrivileged(Native Method)
 at javax.security.auth.Subject.doAs(Subject.java:415)
 at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1557)
 at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)
11/19 05:19:14  INFO ConnectorExportTool: job completed with exit code 10000
11/19 05:19:14  INFO ZlibFactory: Successfully loaded & initialized native-zlib library
11/19 05:19:14  INFO CodecPool: Got brand-new compressor [.deflate]
11/19 05:19:14  INFO Task: Task:attempt_1416390979742_0004_m_000000_0 is done. And is in the process of committing
11/19 05:19:14  INFO Task: Task attempt_1416390979742_0004_m_000000_0 is allowed to commit now
11/19 05:19:14  INFO FileOutputCommitter: Saved output of task 'attempt_1416390979742_0004_m_000000_0' to hdfs://sandbox.hortonworks.com:8020/user/hue/oozie-oozi/0000010-141119015631264-oozie-oozi-W/java-node--java/output/_temporary/1/task_1416390979742_0004_m_000000
11/19 05:19:14  INFO Task: Task 'attempt_1416390979742_0004_m_000000_0' done.
11/19 05:19:15  INFO MetricsSystemImpl: Stopping MapTask metrics system...
11/19 05:19:15  INFO MetricsSinkAdapter: ganglia thread interrupted.
11/19 05:19:15  INFO MetricsSystemImpl: MapTask metrics system stopped.
11/19 05:19:15  INFO MetricsSystemImpl: MapTask metrics system shutdown complete.
 
Strangely it is facing a problem with the connection to Teradata. I have export and import xml files for Teradata in tdch/lib/conf as well as in etc/hadoop/conf. Also made the changes suggested to mapred-site.xml. Also checked the IP addresses in windows hosts file.
Any suggestion will be appreciated

fgrimmer 660 comments Joined 04/09
19 Nov 2014

KSunny, Yes, it looks like the Unknown Host is the problem java.net.UnknownHostException: SLES11SP1. It sounds like the Hadoop system cant connect back to the Teradata system. Can you try using the IP address of the Teradata system instead of the Host Name in your connection profile Database Server Name?

haunties 3 comments Joined 04/15
15 Apr 2015

Hi I want to use a Teradata datasource for build report with BIRT.
So I install the Teradata Eclipse Plugins like in your tutorial. But when I try to connect with my database I have an error
"com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.36] [Error 1277] [SQLState 08S01] Login timeout for Connection to ibifte0u.srv-ib.ibp Wed Apr 15 17:21:26 CEST 2015 socket orig=ibifte0u.srv-ib.ibp cid=17ea8e5 sess=0 java.net.SocketTimeoutException: Connect timed out   at java.net.SocksSocketImpl.readSocksReply(Unknown Source)   at java.net.SocksSocketImpl.connect(Unknown Source)   at java.net.Socket.connect(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968) 
 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)
 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206)
 at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116)
 at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580)
 at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95)
 at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209)
 at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30)
 at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)
 at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)
 at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)
 at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220)
 at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153)
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:276)
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121)
 at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
 at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
 at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
 at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)
 at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
 at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
 at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
 at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: java.net.SocketTimeoutException: Connect timed out
 at java.net.SocksSocketImpl.readSocksReply(Unknown Source)
 at java.net.SocksSocketImpl.connect(Unknown Source)
 at java.net.Socket.connect(Unknown Source)
 at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968)"
I use Teradata V14.00 that the source of my problem or not ? I try all solution that I know.

I'm a new user of Birt/Eclipse.

Thank you if you can help me !

fgrimmer 660 comments Joined 04/09
15 Apr 2015

@haunties, It looks like from the exception that you are not getting a response from your Teradata Server. Can you try using the IP address of the Teradata database server (ibifte0u.srv-ib.ibp) and see if that works?

haunties 3 comments Joined 04/15
16 Apr 2015

Thank for repply fgrimmer.

But that don't work. I writte the IP address the "ping" command gave to me. And that don't work..
I have ever the "login timeout". I try to take the driver teradata V14.10 too..

fgrimmer 660 comments Joined 04/09
16 Apr 2015

@haunties, Is it possible that your Teradata Database server is down?

haunties 3 comments Joined 04/15
16 Apr 2015

No, I find the solution. It was something in preference > network connection everything work well now.
Thank for your help !

12 Nov 2015

Hi Francine,
I installed Eclipse and the Teradata Plugin today and when I try to create a new Teradata Project I get the following error:
 

The selected wizard could not be started.

Plug-in "com.teradata.datatools.teradataproject" was unable to instantiate class "com.teradata.datatools.teradataproject.wizards.TeradataProjectNewWizard".

com/teradata/datatools/dtp/sqltools/ui/TeradataSQLToolsUIPlugin

 

Please, could you help me figure out what the problem is?

 

I am using Windows 7 Ultimate, Service Pack 1, 64 Bit and jre1.8.0_65

 

I do not get any error if I select new udaSQL Project.

 

Thanks in advance.

 

Best regards,

Oscar Mendoza

fgrimmer 660 comments Joined 04/09
12 Nov 2015

Oscar, What verison of Eclipse are you installing the Teradata Plugin for Eclipse? Did you select all of the Features when presented the list (as shown above) during the install?

12 Nov 2015

Hi Francine,
 
thanks a lot for your prompt response.
The installed version is: 

Eclipse Java EE IDE for Web Developers.

Version: Mars.1 Release (4.5.1)

Build id: 20150924-1200

 

Yes, I did select all the features during the installation.

 

Thanks again 

fgrimmer 660 comments Joined 04/09
12 Nov 2015

OK, we will try to recreate your problem.
Regards

12 Nov 2015

Hi Francine,
I have good news!!!! 
I selected the menu HELP->CHECK FOR UPDATES, run all the updates and restarted Eclipse. Now I can create the project without problems.
Thanks a lot for your help and support!
Best regards,
Oscar Mendoza

TeradataTony 3 comments Joined 11/15
25 Nov 2015

Hi - and first of all thanks for this great plug-in and the clear set-up instructions. Worked perfectly for me.
I'd just like to ask about the "Progress Bar" when executing a query. It's there but apparently not functioning. Is this something for a future release or do I need to change some settings/configure something for it to work?
Best Regards,
Tony

fgrimmer 660 comments Joined 04/09
27 Nov 2015

Tony, The query progress bar indicates that the query is active and an icon to cancel the query. You can open the Progess Monitor view to see any active jobs running in Eclipse. 

TeradataTony 3 comments Joined 11/15
30 Nov 2015

Francine, thanks for the reply!
Just to clarify, is it so that the bar is *not* intended to fill-up with a colour progressively from left->right between start->end of the execution time?
All the best,

Tony

fgrimmer 660 comments Joined 04/09
30 Nov 2015

Tony, Correct, the bar in the 'SQL Statement execution' windowdoes not move. There is another status bar in the lower left hand margin that does move, reflecting the active progress.

TeradataTony 3 comments Joined 11/15
01 Dec 2015

OK, thanks!
 

fgrimmer 660 comments Joined 04/09
05 Jan 2016

Tony, It is hard to tell what happened without a stacktrace of the error.  Maybe something to do with changing workspaces?

asifontheline 1 comment Joined 07/13
10 Jan 2016

Hi,
Getting below while installing plug-in. And installation aborts.
 
For me
=====
Cannot complete the install because one or more required items could not be found.
Software currently installed: Teradata Java Development Feature 15.10.10.201511041752 (com.teradata.datatools.javadevelopmentFeature.feature.group 15.10.10.201511041752)
Missing requirement: Teradata Stored Procedure Java Bean Wrapper Wizard 15.10.10.201511041752 (com.teradata.datatools.javabean 15.10.10.201511041752) requires 'bundle org.eclipse.jst.ws 1.0.407' but it could not be found
Cannot satisfy dependency:
From: Teradata Java Development Feature 15.10.10.201511041752 (com.teradata.datatools.javadevelopmentFeature.feature.group 15.10.10.201511041752)
To: com.teradata.datatools.javabean [15.10.10.201511041752]
 
For my colleague
=============
Cannot complete the install because one or more required items could not be found.
Software currently installed: Teradata Plug-in for Eclipse 15.10.10.201511041752 (com.teradata.datatools.pluginFeature.feature.group 15.10.10.201511041752)
Missing requirement: Views 15.10.10.201511041752 (com.teradata.datatools.admin.teradata.models.views 15.10.10.201511041752) requires 'bundle org.eclipse.ui 3.106.0' but it could not be found
Cannot satisfy dependency:
From: Teradata DTP Enhancements Feature 15.10.10.201511041752 (com.teradata.datatools.enhancementsFeature.feature.group 15.10.10.201511041752)
To: com.teradata.datatools.admin.teradata.models.views [15.10.10.201511041752]
Cannot satisfy dependency:
From: Teradata Plug-in for Eclipse 15.10.10.201511041752 (com.teradata.datatools.pluginFeature.feature.group 15.10.10.201511041752)
To: com.teradata.datatools.enhancementsFeature.feature.group [15.10.10.201511041752]
 
We have jre 1.8
 
Appreciate your help.

fgrimmer 660 comments Joined 04/09
11 Jan 2016

@asifontheline, It looks like something is missing from your Eclipse installation. Teradata Plugin for Eclipse recommends installing the Eclipse Mars JEE bundle, but you can also install the Eclipse components separately. Be user you have installed the WTP package.

vic.miranda 2 comments Joined 10/10
18 Jan 2016

Hi Francine,
 
I am trying to do a LOB migration SP in JAVA. The SP works with the embedded teradata jdbc driver.
However, the moment i start using our external jdbc drivers for my source and/or target connection my SP started issuing a "7827 : The locator is invalid because it has been changed".
Is it because the embedded jdbc driver is 15.0 (looking at my eclipse driver definition window) and my jdbc driver is 15.10.00.14?
How can I use our embedded driver instead of our external drivers?
Thank you very much in advance :)
 
Vic Miranda
 
 

fgrimmer 660 comments Joined 04/09
15 Feb 2016

Jakub, It looks like from the stack trace that something is missing:
Caused by: java.lang.ClassNotFoundException: An error occurred while automatically activating bundle com.teradata.datatools.dtp.sqltools.ui
Can you verify that all of the Teradata Plugin for Eclipse packages are installed?
thanks,

raywonqa 1 comment Joined 03/16
04 Mar 2016

After installing the teradata plugin in Eclipse 4.5 Mars.1, the workspace launcher no longer appears when one starts eclipse.  Eclipse always defaults to the default workspace. The Eclipse startup option, window>preferences>general>startup and shutdown>workspaces, is ignored.
Starting eclipse wih the -clean switch from a command prompts does not fix the problem either. I tried all the solutions resulting from the search "eclipse stuartup launcher not displayed" - none of them work.
The teradata plugin works properly, and I can connect to our server and work with databases.
Removing the Terdata plugin solves the workspace launcher problem:
  delete eclipse\plugins\com.terdata.*
  delete all directories starting with com.teradata
Of course, then one can't use the teradata plugin and experiment with mybatis.
 

jlux33 1 comment Joined 07/16
30 Jul 2016

I insalled the Teradata plug-in for Eclipse Neon and I am able to browse the database in Data Source Explorer.  I would like to know how to set up a Data Source in Data Explorer to use the Teradata database for reports in BIRT.
I add a Data Source, go to Manager Drivers add the terajdbc4.jar file and then have com.teradata.jdbc.TeraDriver available.  I select it, enter jdbc:teradata://192.9.220.33:1025/Database=PROD_DWVM and username / password.  When I click Test Connection, I get the error below.  Doesn't make sense since Data Source Explorer works.

org.eclipse.datatools.connectivity.oda.OdaException: Failed to create a connection. Please verify the connection properties.

at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$TestInProcessDialog$TestConnectionJob$1.run(JDBCSelectionPageHelper.java:218)

at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)

at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:182)

at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4024)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3700)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)

at org.eclipse.jface.window.Window.open(Window.java:794)

at org.eclipse.jface.dialogs.MessageDialog.open(MessageDialog.java:396)

at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:1036)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4248)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1501)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1524)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1509)

at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1313)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4072)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3698)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)

at org.eclipse.jface.window.Window.open(Window.java:794)

at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:117)

at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSourceNodeProvider.performEdit(EditableDataSourceNodeProvider.java:73)

at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472)

at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:85)

at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)

at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214)

at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:833)

at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)

at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50)

at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:173)

at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:830)

at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1470)

at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1264)

at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:252)

at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:249)

at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:311)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4248)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1501)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1524)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1509)

at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1313)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4072)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3698)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1121)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1022)

at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:150)

at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:687)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:604)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)

at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:138)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610)

at org.eclipse.equinox.launcher.Main.run(Main.java:1519)

 

You must sign in to leave a comment.