java - 将 uuid(UUID 类型)插入 mysql 时报告键 PRIMARY 的重复条目

Question

代码中，通过UUID post_uuid = uuidGenerator.generate()生成一个UUID，然后插入到mysql中。

   Connection conn = sql2o.beginTransaction();
   UUID postUuid = uuidGenerator.generate();

   conn.createQuery("insert into posts(post_uuid, title, content, publishing_date) values (:post_uuid, :title, :content, :date)")
        .addParameter("post_uuid", postUuid.toString())
        .addParameter("title", title)
        .addParameter("content", content)
        .addParameter("date", new Date())
        .executeUpdate();

   categories.forEach(category -> 
        conn.createQuery("insert into posts_categories(post_uuid, category) VALUES (:post_uuid, :category)")
        .addParameter("post_uuid", postUuid.toString())
        .addParameter("category", category)
        .executeUpdate());

   conn.commit();
   return postUuid;

RandomUuidGenerator 类

     public class RandomUuidGenerator implements UuidGenerator{

     @Override
     public UUID generate() {
        // TODO Auto-generated method stub
        return UUID.randomUUID();
     }

   }

在mysql中，post_uuid字段为CHAR(36)

运行代码报错

错误指向第二次插入sql addParameter("category", category).executeUpdate())

Answer 1

it said that in table posts_categories it has the duplicate entry for key PRIMARY

不要让post_uuid成为posts_categories的主键。
对于集合 categories 中的每个元素，您使用相同的 postUuid 运行 INSERT 语句。