I have an issue after I upgrade hibernate in my application from 5.x to 6.x. I am getting the following error “could not execute batch [Cannot insert explicit value for identity column in table ‘EmailMessageTemplate’ when IDENTITY_INSERT is set to OFF.] my application supports 3 databases MySql, MSSQL and Oracle but I am getting the above error only in MSSQL database. Can you all please give suggestion to resolve this issue ?
<code>@Id
@SequenceGenerator(name = "EmailMessageTemplate_SeqGenerator",
sequenceName = "EmailMessageTemplate_Seq")
@GeneratedValue(strategy = GenerationType.AUTO, generator ="EmailMessageTemplate_SeqGenerator")
private int id;
</code>
<code>@Id
@SequenceGenerator(name = "EmailMessageTemplate_SeqGenerator",
sequenceName = "EmailMessageTemplate_Seq")
@GeneratedValue(strategy = GenerationType.AUTO, generator ="EmailMessageTemplate_SeqGenerator")
private int id;
</code>
@Id
@SequenceGenerator(name = "EmailMessageTemplate_SeqGenerator",
sequenceName = "EmailMessageTemplate_Seq")
@GeneratedValue(strategy = GenerationType.AUTO, generator ="EmailMessageTemplate_SeqGenerator")
private int id;