Blob loading problem on Oracle

Classic Servoy
1

Hello,

I just noticed a very unpleasant problem: Oracle does not allow field names longer than 30 characters. Since I knew that, I took care of that. When Servoy queries a table that contains blobs, it queries

SELECT 1 AS myBlobColum_SV_BLOB_M

It is very obvious that in this situation the column name is 10 characters longer than the original column name (by the added “_SV_BLOB_M”).

We have a table that stores all button images, that I can’t query now because Oracle complains:

java.sql.SQLException: ORA-00972: identifier is too long

This is really unpleasant! Is there anything that can be done about it?

2

Just also noticed, that long field names are already truncated by Servoy. But not to 30 characters, but 32!

3

Will be fixed in the next releases of Servoy