External database : Cassandra DB
The primary key is : bedrijf, soortlid
An update-statement (by AwareIM) tries also to update these primary key fields.
So an error is raised :
The connection '29' query failed to execute query :
UPDATE soortlid
SET bedrijf=?,
omschrijving=?,
soortlid=?
WHERE bedrijf=? AND soortlid=?
he CQL error message is 'PRIMARY KEY part bedrijf found in SET part'..
How to avoid it ?
AwareIM must not update an primary-key-field.
Only field 'omschrijving' must be updated.
= Jannes
Primary key-field(s) in update statement
Re: Primary key-field(s) in update statement
Cassandra is a NoSQL database, I dont think you will get AwareIM to do this