Primary key-field(s) in update statement

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
jannes
Posts: 100
Joined: Tue Jul 02, 2019 12:22 pm

Primary key-field(s) in update statement

Post by jannes »

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
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Primary key-field(s) in update statement

Post by ACDC »

Cassandra is a NoSQL database, I dont think you will get AwareIM to do this
Post Reply