All Forums Teradata Studio
MadMac 14 posts Joined 10/04
10 Dec 2013
Eclipse Plugin installation fails looking for: org.eclipse.jst.ws.axis.consumption.core

Any help? Installation Fails under just about any scenario, local or remote.
Under: Version: Kepler Service Release 1, Build id: 20130919-0819

Cannot complete the install because one or more required items could not be found.

Software currently installed: Teradata Plug-in for Eclipse 14.10.1.201310281651 (com.teradata.datatools.pluginFeature.feature.group 14.10.1.201310281651)

Missing requirement: Teradata Stored Procedure Java Bean Wrapper Wizard 14.10.0.201310281651 (com.teradata.datatools.javabean 14.10.0.201310281651) requires 'bundle org.eclipse.jst.ws.axis.consumption.core 1.0.306' but it could not be found

Cannot satisfy dependency:

From: Teradata Java Development Feature 14.10.0.201310281651 (com.teradata.datatools.javadevelopmentFeature.feature .group 14.10.0.201310281651)

To: com.teradata.datatools.javabean [14.10.0.201310281651]

Cannot satisfy dependency:

From: Teradata Plug-in for Eclipse 14.10.1.201310281651 (com.teradata.datatools.pluginFeature.feature.group 14.10.1.201310281651)

To: com.teradata.datatools.javadevelopmentFeature.feature. group [14.10.0.201310281651]

fgrimmer 553 posts Joined 04/09
10 Dec 2013

It looks like something is missing from Eclipse install. For Teradata Plugin for Eclipse, we require either the Eclipse JEE bundle or the following Eclipse packages for Kepler (4.3) release: Eclipse, DTP 1.11, WTP 3.4, EMF 3.9, GEF 3.9

MadMac 14 posts Joined 10/04
10 Dec 2013

It's something in EMF/GEF that's dependent. The install completed after EMF/GEF installation. Thanks. 

Z084107 9 posts Joined 06/14
04 Jun 2014

 I am trying to download the Teradata plug-in for Eclipse and the install is failing because the Teradata DTP support feature can't be found? Any ideas of what I need to do to fix it?

fgrimmer 553 posts Joined 04/09
04 Jun 2014

Zach, We recommend that you use the Eclipse JEE download becuase it includes all the required Eclipse plugins needed by Teradata Plugin for Eclipse. But if you already have Juno (Eclipse 4.2.2) or Kepler (Eclipse 4.3) releases, you can add the other required pieces, such as: EMF, GEF, and DTP.  If you are also planning to use the Web Service Wizards, then you will also need WTP. You can find these plugins via the Kepler or Juno update sites. DTP is under the Database Development feature.

Z084107 9 posts Joined 06/14
10 Jun 2014

Thanks! I got it working! My next question which I put in another blog post is how to pass through multiple parameters in the webservice.
I want to pass through for example department ID and date but the wizard creates a service for each of those independently.
In addition, for inputs that generate multiple results, I am getting an error as follows:
Exception: java.rmi.RemoteException: Expected one result (or null) to be returned by selectOne(), but found: 160 Message: java.rmi.RemoteException: Expected one result (or null) to be returned by selectOne(), but found: 160
Any thoughts on how to correct this?! Thanks again

fgrimmer 553 posts Joined 04/09
11 Jun 2014

Zach, Which wizard are you running? Did you start from a Teradata table, right click and choose 'Create CRUD iBatis SQL Map' and check the box to create a Web Service or enter a SQL statement in the SQL Editor and invoke the wizard that way? Are you following any of the articles on Developer Exchange regarding this topic?

Z084107 9 posts Joined 06/14
11 Jun 2014

I started from a Teradata table, right clicked and chose "Create CRUD iBatis SQL Map" and checked the box to create the wizard. I am unaware of how to invoke the wizard via the SQL editor? Can you share how to do that?
I've read your previous article and have seen you youtube video on the topic but I don't know how to invoke the wizard via a custom SQL statement?

fgrimmer 553 posts Joined 04/09
11 Jun 2014

Zach, Open a Teradata SQL Editor for a Teradata Connection profile. Inside the editor, enter your SQL select statement: such as SELECT * FROM <database>.<table>;. Then right click in the SQL Editor and choose the same option about 'Create an iBatis(MyBatis) SQL Map... menu option about 2/3 down the list. In this case, it will use the select statement as method for the web service and result set returned. You should be able to pass multiple parameters or question marks into the query.

Z084107 9 posts Joined 06/14
12 Jun 2014

Thanks for the follow up. One question I do have is where within the SQL statement do I define which parameters I want to pass through? For example- There are 3 columns in my table (date, id, percent) and I want to build a service such that if I input date and id, it will send back the percent.
I don't want to predefine the inputs in the select SQL statement with a specific date or id but allow the user to input him or herself.
Example: Select percent from <db>.<table> where id = "?" and date = "?"
Maybe my snytax is off? I just know where I am supposed to define my parameters?

Z084107 9 posts Joined 06/14
12 Jun 2014

don't know** ^

fgrimmer 553 posts Joined 04/09
12 Jun 2014

Zach, You would create your SQL query just like you would for a parameterized query, so as you suggested but without the double quotes: SELECT percent from <db>.<table> where id=? and date=?; The parser understands the question marks as a parameters for the query. Run the query in the SQL Editor to make sure it is what you want. In Studio, it will bring up the Configure Parameters dialog for you to enter the id and date values.

Z084107 9 posts Joined 06/14
12 Jun 2014

Thanks for all of your help and timely responses!
I'm able to create the service with one parameter following the syntax you recommended. When I go back and use another SQL statement only adding the second condition, I can get all the way up to the "iBatis (MyBatis)DAO with Web Services Wizard" but I'm unable to select the checkbox in WSDL to "use in WSDL". It is showing an error message on top saying that the "WSDL cannot be created because no DAO methods have been selected" but again it won't let me select it? 
It works perfectly with only one parameter but I'm running into this issue when I have multiple parameters. Any ideas?

fgrimmer 553 posts Joined 04/09
13 Jun 2014

Zach, Hmm. Not sure. We'll look into the problem.

Z084107 9 posts Joined 06/14
16 Jun 2014

Francine, I was able to figure it out! If anyone else has this same problem, you should refer them to the following article http://developer.teradata.com/tools/articles/create-an-ibatis-sql-map-with-teradata-plug-in-for-eclipse
"This Wizard page also allows you to configure parameters for the SQL map. You can change the name of parameters used with the SQL query and enter a data value if the query requires it to generate the result Meta data. Note: If the SQL query has more than one parameter, a “java.util.Map” will be mapped to the parameters."
The following was also very helpful from the Teradata Education Network:
http://developer.teradata.com/tools/training/from-sql-to-web-service-without-ever-leaving-your-desk
Thanks again for all of your help:)

Z084107 9 posts Joined 06/14
30 Jun 2014

Francine, 
Is there any way to create a RESTful webservice as opposed to the defaulted SOAP service?!
Thanks, 
Zach 

fgrimmer 553 posts Joined 04/09
30 Jun 2014

Zach, Yes it is possible. Here is a link from Java EE that might help (http://docs.oracle.com/javaee/6/tutorial/doc/gijqy.html), or using Spring (https://spring.io/guides/gs/rest-service/).

You must sign in to leave a comment.