Deleting more than 1 row from a DB table.

In my understanding, the nature of a primary key is that it is unique, and there is only a single row for one key ever.

How do you use that code snippet?

In my understanding, the nature of a primary key is that it is unique, and there is only a single row for one key ever.

How do you use that code snippet?

My apologies, it's a composite key table. So 2 columns make up the PK but the second key isn't the concern. I need everything that matches the first key to be deleted as it's referencing the parent object I'm trying to delete.

First, I would try to simplify that code to

a!entityDataIdentifiers(
  entity: cons!CTI_ENTITY_MRCM,
  identifiers: pv!CTI_mnthlyrevene_cntrctmnths.ctmnthlyrvCntrctmnthRcrdd
)

Then, I am interested in the output.

I copied that code and got the following error:

• An error occurred while trying to delete data. No data was deleted. Details: javax.persistence.PersistenceException: org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row count: 4; expected: 1 [entity name=CTI_mnthlyrevene_cntrctmnths, id=353]

Sorry, I would like to see the output of the a!entityDataIdentifiers() call.

There is no output configured for that node, that or I'm not sure how to locate what you are looking for.

I understand. Somehow we need to debug this. And to understand what is going on, we need a few things.

1. What exactly is going into that node?

2. How is the CDT configured?

3. How is the database table set up?

Without that, it is just guesswork.