Update item in DynamoDB using Java

Question

I want to update specific Item(Only One data from row),

How can I update item in DynamoDB.?

login_id is my primary key. I pass login_id and other boolean value. I want to set boolean value true according to that login-id.

How can I do that?

I tried this code.

LinkedHashMap inputHashMap = (LinkedHashMap) input;

        login_id = (String) inputHashMap.get("login_id");
        isUserVerified = (Boolean) inputHashMap.get("isUserVerified");

        DynamoDB dynamoDB = new DynamoDB(new AmazonDynamoDBClient());

        Table tableUserDetails = dynamoDB.getTable(USER_DETAILS_TABLE);
        Table tableOtpStatus = dynamoDB.getTable(OTP_DETAILS_TABLE);

        UpdateItemSpec updateItemSpec = new UpdateItemSpec().withPrimaryKey("login_id", login_id);

        try{

            UpdateItemOutcome outcome = tableUserDetails.updateItem(updateItemSpec);
            System.out.println("UpdateItem succeeded:\n" + outcome.getItem().toJSONPretty());
        }catch(Exception e){
            System.err.println(e.getMessage());
        }

While executing above code I got below exception.

The provided key element does not match the schema (Service: AmazonDynamoDBv2; Status Code: 400; Error Code: ValidationException;

Chirag Savsani · Accepted Answer · 2016-05-12 04:13:01Z

8

Looks like you're missing the update expression. Assuming isUserVerified is part of the primary key, it should be something like:

UpdateItemSpec updateItemSpec = new UpdateItemSpec()
      .withPrimaryKey("login_id", login_id)
      .withUpdateExpression("set isUserVerified = :val")
      .withValueMap(new ValueMap()
         .withBoolean(":val", true));

If isUserVerified not part of the key then just remove it from the .withPrimaryKey() statement.

You can find more here.

edited May 12, 2016 at 4:13

Chirag Savsani

6,1504 gold badges44 silver badges79 bronze badges

answered May 11, 2016 at 13:08

Benny Bauer

1,0651 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Chirag Savsani Over a year ago

Thanks for answer. I already solved problem same as this way. Thanks for information.

Chirag Savsani Over a year ago

Hey can you give me example, If I want to update more than one value based on login_id (Primary Key).

Neal Over a year ago

@ChiragSavsani may I know from which library I can get UpdateItemSpec?

Collectives™ on Stack Overflow

Update item in DynamoDB using Java

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest