DynamoDB查询ImageDetail时imageId与imageUrl字段返回null求助

我定义了如下ImageDetail数据类映射DynamoDB表AtcDevDocumentImages：

import com.amazonaws.services.dynamodbv2.datamodeling.DynamoDBAttribute;
import com.amazonaws.services.dynamodbv2.datamodeling.DynamoDBHashKey;
import com.amazonaws.services.dynamodbv2.datamodeling.DynamoDBRangeKey;
import com.amazonaws.services.dynamodbv2.datamodeling.DynamoDBTable;

@DynamoDBTable(tableName = "AtcDevDocumentImages")
public class ImageDetail {

  @DynamoDBHashKey(attributeName = "DocumentId")
  private String documentId;

  @DynamoDBRangeKey(attributeName = "TrackPosition")
  private int trackPosition;

  @DynamoDBAttribute(attributeName = "ImageId")
  private String imageId;

  @DynamoDBAttribute(attributeName = "ImageUrl")
  private String imageUrl;

  @DynamoDBAttribute(attributeName = "ImageName")
  private String imageName;

  @DynamoDBAttribute(attributeName = "Width")
  private double width;

  @DynamoDBAttribute(attributeName = "Height")
  private double height;
// 省略getter/setter和toString方法
}

DynamoDB表中存在对应条目，但通过ImageService的getImagesByDocumentId方法查询时，返回结果里imageId和imageUrl字段为null，同时日志里还显示id='null'、name='image1.png'（类里定义的是imageName）。

查询用的ImageService代码如下：

import com.amazonaws.client.builder.AwsClientBuilder;
import com.amazonaws.services.dynamodbv2.AmazonDynamoDB;
import com.amazonaws.services.dynamodbv2.AmazonDynamoDBClientBuilder;
import com.amazonaws.services.dynamodbv2.datamodeling.DynamoDBMapper;
import com.amazonaws.services.dynamodbv2.datamodeling.DynamoDBMapperConfig;
import com.amazonaws.services.dynamodbv2.datamodeling.DynamoDBQueryExpression;
import com.amazonaws.services.dynamodbv2.datamodeling.PaginatedQueryList;
import java.text.SimpleDateFormat;
import java.util.List;
import java.util.TimeZone;
import org.slf4j.Logger;

public class ImageService {

  private AmazonDynamoDB amazonDynamoDB;
  private DynamoDBMapper mapper;

  private SimpleDateFormat sdf;

  private String tableName;

  public ImageService local() {
    amazonDynamoDB =
        AmazonDynamoDBClientBuilder.standard()
            .withEndpointConfiguration(
                new AwsClientBuilder.EndpointConfiguration("http://localhost:8000", "local"))
            .build();
    mapper = new DynamoDBMapper(amazonDynamoDB);
    return this;
  }

  public ImageService cloud() {
    amazonDynamoDB = AmazonDynamoDBClientBuilder.standard().build();
    mapper = new DynamoDBMapper(amazonDynamoDB);
    this.tableName = System.getenv("IMAGES_TABLE");
    return this;
  }

  public ImageService init() {
    sdf = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSXXX");
    sdf.setTimeZone(TimeZone.getTimeZone("UTC"));
    return this;
  }

  public List<ImageDetail> getImagesByDocumentId(String documentId, Logger logger) {
    DynamoDBMapperConfig mapperConfig =
        DynamoDBMapperConfig.builder()
            .withTableNameOverride(
                DynamoDBMapperConfig.TableNameOverride.withTableNameReplacement(tableName))
            .build();

    ImageDetail imageDetailKey = new ImageDetail();
    imageDetailKey.setDocumentId(documentId);

    DynamoDBQueryExpression<ImageDetail> queryExpression =
        new DynamoDBQueryExpression<ImageDetail>()
            .withHashKeyValues(imageDetailKey)
            .withConsistentRead(false);

    PaginatedQueryList<ImageDetail> query =
        mapper.query(ImageDetail.class, queryExpression, mapperConfig);
    logger.info("results: ");
    logger.info(query.toString());
    return query;
  }
}

查询返回日志：

1703153761850,"2023-12-21 10:16:01 da71511d-f14e-48d2-8f33-ae623818745d INFO  XyzService - ImageDetail{documentId='a0d266bc-85ce-4595-a85d-fe1142c81fdf', id='null', trackPosition=6, imageUrl='null', name='image1.png', width=1920.0, height=938.0}

1. 检查toString()方法的字段映射 #

从日志输出能看到，打印的是id和name，但实体类里定义的是imageId和imageName。这说明ImageDetail类的toString()方法用了错误的字段名，先确认toString()是否正确输出imageId和imageUrl——有可能字段实际已经映射成功，只是日志打印错了。

2. 验证DynamoDB表字段名与注解的一致性 #

DynamoDB字段名大小写敏感，需检查：

• 表中是否存在ImageId和ImageUrl字段，拼写、大小写是否和@DynamoDBAttribute的attributeName完全匹配
• 对比表中实际字段，确认没有写成image_id、ImageURL这类变体

3. 检查实体类的Getter/Setter方法 #

DynamoDBMapper依赖JavaBean规范的Getter/Setter完成映射：

• 确保imageId对应getImageId()和setImageId(String imageId)，imageUrl对应getImageUrl()和setImageUrl(String imageUrl)
• 避免方法名拼写错误（比如写成getId()、setId()，会导致映射到不存在的id字段）

4. 确认Mapper配置的表名正确性 #

在cloud()方法中，通过环境变量IMAGES_TABLE获取表名并覆盖：

• 验证环境变量IMAGES_TABLE的值是否为AtcDevDocumentImages，或是否指向了字段缺失的测试表
• 可临时去掉TableNameOverride，直接使用实体类上@DynamoDBTable指定的表名测试，看是否能正确返回字段

5. 启用DynamoDB调试日志 #

开启com.amazonaws.services.dynamodbv2的DEBUG级日志，查看：

• 实际发送的查询请求
• DynamoDB返回的原始Item数据，确认ImageId和ImageUrl是否存在于返回结果中
  • 若原始返回有这两个字段但映射后为null，说明是实体类映射配置问题；若原始返回没有，说明查询的表或数据有问题

内容的提问来源于stack exchange，提问作者C96