Announcement

**claudiobosticco** · 24 Sep 2018, 04:59

Hello, did you manage to reproduce the problem?
Please let me know if you need other details.

**Isomorphic** · 24 Sep 2018, 11:32

We haven�t gotten to it yet, but it is assigned.

Isolating it further would of course help speed resolution.

**claudiobosticco** · 25 Sep 2018, 05:42

Hello, after some more tests, the problem seems to be related to the fact that I'm invoking the update operation in a DMI where I call dsRequest.setValues(squadra), and 'squadra' is a Map (received from client), where I set the new values for the 'LOGO_IMG*' fields, ie:

Code:

                squadra.put("LOGO_IMG", inputStream);
                squadra.put("LOGO_IMG_FILENAME", fileName);
                squadra.put("LOGO_IMG_FILESIZE", size);
                squadra.put("LOGO_IMG_DATE_CREATED", new Date());

but, if those attributes were already present (valued), there are also the 'LOGO_IMG_FIELD*' attributes.
So the dsRequest.setValues is called with a parameter like this:

Code:

0 = {java.util.HashMap$Entry@15979} "LOGO_IMG_FIELD_FILENAME" -> "MN.png"
1 = {java.util.HashMap$Entry@15980} "ID_REC" -> "975393"
2 = {java.util.HashMap$Entry@15981} "LOGO_URL_SUFFIX" -> ".png"
3 = {java.util.HashMap$Entry@15982} "LOGO_IMG_FIELD" ->
4 = {java.util.HashMap$Entry@15983} "LOGO_IMG_FIELD_DATE_CREATED" -> "2018-09-14 15:46:24.0"
5 = {java.util.HashMap$Entry@15984} "LOGO_IMG_DATE_CREATED" -> "Tue Sep 25 15:02:04 CEST 2018"
6 = {java.util.HashMap$Entry@15985} "LOGO_IMG_FIELD_FILESIZE" -> "8595"
7 = {java.util.HashMap$Entry@15986} "LOGO_URL_PREFIX" -> "https://serverURL/loghi_squadre/"
8 = {java.util.HashMap$Entry@15987} "LOGO_IMG" ->
9 = {java.util.HashMap$Entry@15988} "SERVER_PATH" -> "smb://serverPath/loghi_squadre/"
10 = {java.util.HashMap$Entry@15989} "FK_REGIONE" -> "22"
11 = {java.util.HashMap$Entry@15990} "DESCRIZIONE" -> "AS Monaco FC"
12 = {java.util.HashMap$Entry@15991} "CODICE_SQUADRA" -> "MN"
13 = {java.util.HashMap$Entry@15992} "LOGO_IMG_FILESIZE" -> "8595"
14 = {java.util.HashMap$Entry@15993} "LOGO_IMG_FILENAME" -> "MN.png"

the SmartClient server seems to ignore the LOGO_IMG_FIELD* fields as per the log from post #1:

Code:

2018-09-14 12:11:57,532 INFO SQLValuesClause [builtinApplication.null] Ignoring value for LOGO_IMG_FIELD since it has a customSelectExpression or customSQLExpression but no customUpdateExpression
2018-09-14 12:11:57,532 INFO SQLValuesClause [builtinApplication.null] Ignoring value for LOGO_IMG_FIELD_DATE_CREATED since it has a customSelectExpression or customSQLExpression but no customUpdateExpression
2018-09-14 12:11:57,532 INFO SQLValuesClause [builtinApplication.null] Ignoring value for LOGO_IMG_FIELD_FILENAME since it has a customSelectExpression or customSQLExpression but no customUpdateExpression
2018-09-14 12:11:57,532 INFO SQLValuesClause [builtinApplication.null] Ignoring value for LOGO_IMG_FIELD_FILESIZE since it has a customSelectExpression or customSQLExpression but no customUpdateExpression

but then the 'Invalid column index' error is raised.

So, I've tried to remove those attributes:

Code:

                squadra.remove("LOGO_IMG_FIELD");
                squadra.remove("LOGO_IMG_FIELD_FILENAME");
                squadra.remove("LOGO_IMG_FIELD_FILESIZE");
                squadra.remove("LOGO_IMG_FIELD_DATE_CREATED");

and now it's working.

anyway, I think it's a bug, correct? Or is it invalid usage?

**Isomorphic** · 26 Sep 2018, 03:26

Yes it is a bug. It is fixed now and will be available for download in nightly builds since Sep 27 (tomorrow).

Announcement

SQLDataSource: Invalid column index while updating a blob column

Comment

Comment

Comment

Comment