Records failing to save because of faulty SQL

Classic Servoy
1 
2012-11-13 10:55:41,297 ERROR [pool-5-thread-1] com.servoy.j2db.util.Debug - Error executing sql: update assignment_classification_types assigment_classification_types set assigment_classification_types.updated_by=?, assigment_classification_types.updated_at=?, assigment_classification_types.reserve_candidates=?, assigment_classification_types.custom_heading=? where assigment_classification_types.id = ? with params: [2 ,type: java.lang.Integer, 2012-11-13 10:55:41.294 ,type: java.sql.Timestamp, 1 ,type: java.lang.Long, 'Short' ,type: java.lang.String, 1670 ,type: java.lang.Integer] [E6C05FFF-00E5-4599-9AB7-72D3368D47EE MBS_6]
org.postgresql.util.PSQLException: ERROR: column "assigment_classification_types" of relation "assignment_classification_types" does not exist
  Position: 75

This is in 6.1.2 developer on Mac OS X 10.8.2
Java Web Start 10.9.2.05
Using JRE version 1.7.0_09-b05 Java HotSpot™ 64-Bit Server VM

Records are failing to save because Servoy is generating faulty SQL:
Why does the table name ‘assignment_classification_types’ appear two times?
It should be

update assignment_classification_types set assigment_classification_types.updated_by=?, assigment_classification_types.updated_at=?, assigment_classification_types.reserve_candidates=?, assigment_classification_types.custom_heading=? where assigment_classification_types.id = ?

no?

2

I hav just switched back to 1.6.0v37 and I see the same error…

3

I believe I have found the reason for my issue:

Servoy 6.1.2 may not like table names longer than 25 characters or whatever that limit for some database is.
I renamed my table from

“assignment_classification_types”

to

“research_list_headings”

and the record now saves fine.

4

Christian,

This is a known issue https://support.servoy.com/browse/SVY-3035
It is fixed in upcoming release 6.1.3.

Rob