Forum Discussion

dhavalunalket's avatar
dhavalunalket
New Contributor
9 years ago
Solved

Can we connect to Dynamo database and Amazon Web Service from Ready API?

  • TNeuschwanger's avatar
    TNeuschwanger
    6 years ago

    Hello,

     

    --- Assuming you are on a Windows PC ---

    That error tells me that the AWS JAR file from the SDK is not in the place it is supposed to be (ReadyAPI has not recognized it).  Double check where you put it if you followed my instructions up above.  Here are the most detailed instructions I can give.  

     

    Step 1.  Download AWS Java SDK - it is a zip file found at "https://sdk-for-java.amazonwebservices.com/latest/aws-java-sdk.zip" (note: just in the few days of this thread, AWS has already updated the SDK.  It was version 1.11.428 when we started.  It is now 1.11.431)

    Step 2.  Unzip it to where ever you want, except for anywhere on your path or the SmartBear software installation areas.  A temp/trash/junk folder would be ideal.

    Step 3.  Save anything you need and close all running instances of ReadyAPI/SoapUIPro

    Step 4.  Delete any file that contains the letters 'aws' in the .lib folder of your ReadyAPI installation location (there should only be one or two files to delete).  Mine is located at 'C:\Program Files\SmartBear\ReadyAPI-2.4.0\lib\'.

    Step 5.  There will be a .lib folder contained in the created extract location of your unzip of the downloaded AWS Java SDK zip file. 

          Copy the file named 'aws-java-sdk-1.11.428.jar'

          to the installation .lib folder of your ReadyAPI installation location.  Mine is:

          'C:\Program Files\SmartBear\ReadyAPI-2.4.0\lib'

    Step 6.  Restart ReadyAPI/SoapUI Pro

    Step 7.  Try your groovy test step that contains the code that gave you the error.  The error should be gone if ReadyAPI/SoapUI Pro has recognized the file.

     

    That is all the farther I can take you my friend.  That is how I made my AWS SDK work on my Windows computer running ReadyAPI-2.x.x

     

    Regards

TNeuschwanger's avatar
TNeuschwanger
Champion Level 2

Hello ranujn,

 

answer for: "I am not able to find java example that I can refer. Is something I am missing here?"

The link in my previous response was a tutorial for DynamoDB access using the Java SDK.  The lower right of the bottom of the page contains a Previous|Next link.  The very first press of the 'Next >>' from the link I sent leads to many java examples on subsiquent pages.

 

answer for: "Can't able to find aws-java-sdk-x.xx.xxx.jar for the dynamo DB in SDK. Also, there are so many options (Attached), not able to understand which jar file I need to download."

This link sends you to "AWS SDK for Java" page.  https://aws.amazon.com/sdk-for-java/  The downloads button is to the right on the page.  The current file as of 10-14-2018 is "aws-java-sdk-1.11.428.zip".  When it is unzipped to where ever you choose, you can review the samples contained in extract.  Some of which are stricktly DynamoDB.  The '.lib' folder of the extract contains three JAR files of which you only need to copy the "aws-java-sdk-1.11.428.jar" to the ".lib" folder of where you installed SmartBear ReadyAPI-x.x.x.  There will already be one or two aws-javaxxxxx.jar files in the SmartBear ".lib" that I just deleted in favor of the one I got from Amazon directly.  The dowloaded JAR contains all of the packages needed to use the JDK (including DyanamoDB).

 

 

ranujn's avatar
ranujn
Contributor
6 years ago

Thanks, TNeuschwanger, Its really help me. 

 

One more thing if you can help me here. I am trying to read the data from Dynamo DB so I followed below steps

1). I set both AWS keys in the groovy script and copy below code into Ready API Groovy script and change data related to table

package com.amazonaws.codesamples.gsg; import com.amazonaws.client.builder.AwsClientBuilder; import com.amazonaws.services.dynamodbv2.AmazonDynamoDB; import com.amazonaws.services.dynamodbv2.AmazonDynamoDBClientBuilder; import com.amazonaws.services.dynamodbv2.document.DynamoDB; import com.amazonaws.services.dynamodbv2.document.Item; import com.amazonaws.services.dynamodbv2.document.Table; import com.amazonaws.services.dynamodbv2.document.spec.GetItemSpec; public class MoviesItemOps02 { public static void main(String[] args) throws Exception { AmazonDynamoDB client = AmazonDynamoDBClientBuilder.standard() .withEndpointConfiguration(new AwsClientBuilder.EndpointConfiguration("http://localhost:8000", "us-west-2")) .build(); DynamoDB dynamoDB = new DynamoDB(client); Table table = dynamoDB.getTable("Movies"); int year = 2015; String title = "The Big New Movie"; GetItemSpec spec = new GetItemSpec().withPrimaryKey("year", year, "title", title); try { System.out.println("Attempting to read the item..."); Item outcome = table.getItem(spec); System.out.println("GetItem succeeded: " + outcome); } catch (Exception e) { System.err.println("Unable to read item: " + year + " " + title); System.err.println(e.getMessage()); } } }

2. when I try to run it, its thowing error for the class I am importing.

 

Could you please help me here. I really appreciate your help. :-) 

  • TNeuschwanger's avatar
    TNeuschwanger
    Champion Level 2
    6 years ago

    Hello,

     

    --- Assuming you are on a Windows PC ---

    That error tells me that the AWS JAR file from the SDK is not in the place it is supposed to be (ReadyAPI has not recognized it).  Double check where you put it if you followed my instructions up above.  Here are the most detailed instructions I can give.  

     

    Step 1.  Download AWS Java SDK - it is a zip file found at "https://sdk-for-java.amazonwebservices.com/latest/aws-java-sdk.zip" (note: just in the few days of this thread, AWS has already updated the SDK.  It was version 1.11.428 when we started.  It is now 1.11.431)

    Step 2.  Unzip it to where ever you want, except for anywhere on your path or the SmartBear software installation areas.  A temp/trash/junk folder would be ideal.

    Step 3.  Save anything you need and close all running instances of ReadyAPI/SoapUIPro

    Step 4.  Delete any file that contains the letters 'aws' in the .lib folder of your ReadyAPI installation location (there should only be one or two files to delete).  Mine is located at 'C:\Program Files\SmartBear\ReadyAPI-2.4.0\lib\'.

    Step 5.  There will be a .lib folder contained in the created extract location of your unzip of the downloaded AWS Java SDK zip file. 

          Copy the file named 'aws-java-sdk-1.11.428.jar'

          to the installation .lib folder of your ReadyAPI installation location.  Mine is:

          'C:\Program Files\SmartBear\ReadyAPI-2.4.0\lib'

    Step 6.  Restart ReadyAPI/SoapUI Pro

    Step 7.  Try your groovy test step that contains the code that gave you the error.  The error should be gone if ReadyAPI/SoapUI Pro has recognized the file.

     

    That is all the farther I can take you my friend.  That is how I made my AWS SDK work on my Windows computer running ReadyAPI-2.x.x

     

    Regards

  • TNeuschwanger's avatar
    TNeuschwanger
    Champion Level 2
    6 years ago

    "Just want to ask how do you setup Credential for AWS. Within your code or any config file??"

     

    The following link describes how to set up your credentials file in the location AWS expects:

    https://docs.aws.amazon.com/sdk-for-java/v1/developer-guide/setup-credentials.html

     

    The following link describes local DynamoDB operation with credentials.

    https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.DownloadingAndRunning.html

    Item number 4 says you don't need specific credentials, they just need to be present in appropriate named and located file.

     

    You can use the aws configure command of the AWS CLI to set up credentials. For more information, see Using the CLI.

     

    Regards

  • TNeuschwanger's avatar
    TNeuschwanger
    Champion Level 2
    6 years ago

    Hello,

     

    After completing the pre-requisites, I dropped each code sample from the above tutorial into its own groovy script test step in a sample test case.  I did not encounter any errors during any run of a test step.  It would be very helpful if you indicate what the error was for the class you imported so I might have an idea of how to help since I did not have any class error while trying to reproduce the content of the tutorial. :)

  • ranujn's avatar
    ranujn
    Contributor
    6 years ago

    Hi TNeuschwanger, 

     

    The error I am getting

     

    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    Script2.groovy: 4: unable to resolve class com.amazonaws.services.dynamodbv2.AmazonDynamoDB
    @ line 4, column 1.
    import com.amazonaws.services.dynamodbv2.AmazonDynamoDB;
    ^
    org.codehaus.groovy.syntax.SyntaxException: unable to resolve class com.amazonaws.services.dynamodbv2.AmazonDynamoDB
    @ line 4, column 1.
    at org.codehaus.groovy.ast.ClassCodeVisitorSupport.addError(ClassCodeVisitorSupport.java:149)

  • ranujn's avatar
    ranujn
    Contributor
    6 years ago

    Thank you so much TNeuschwanger. It's very impressive the way you are given instruction.

     

    Here I found what I was doing wrong

    First of all, I have not closed ready API. Even after closing Ready API, It doesn't work for me then I copied SDK file to this folder too  (C:\Program Files\SmartBear\ReadyAPI-2.3.0\bin\ext) as it seems to have all external jars. Now it's working.

     

    Just want to ask how do you setup Credential for AWS. Within your code or any config file??

  • ranujn's avatar
    ranujn
    Contributor
    6 years ago

    Thanks TNeuschwanger, I have found one of the links you provided to set up the keys and its working fine for me. 

     

  • Olga_T's avatar
    Olga_T
    SmartBear Alumni (Retired)
    6 years ago

    Hi all,

     

    TNeuschwanger, thank you so much for those great instructions, wow! That is really impressive! 

    I have marked your reply with the steps as a solution so that other users could refer to it easier in the future, but other your replies are also very good.

    ranujn, feel free to mark any reply that you like as a solution too! It's great to hear that you are all set now!

     

    Have a great day!