Announcement

**Blama** · 24 Jul 2014, 07:34

Hi Macomi,

seems to be related to the cacheSync after the add:

See this part of the log:

Code:

=== 2014-07-24 16:59:13,194 [2-29] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add] Discovered multiple generated keys via JDBC: {}
=== 2014-07-24 16:59:13,196 [2-29] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] add operation affected 1 rows
=== 2014-07-24 16:59:13,197 [2-29] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] primaryKeys: {}

It seems JDBC can't figure out the newly generated PK. Any idea why this is?
Is

Code:

<field name="ScenariosPool_ScenarioID" primaryKey="true" type="integer" hidden="true" />

really correct? Are other PKs in your .ds.xml defined the same way?

Best regards,
Blama

**Macomi** · 24 Jul 2014, 07:48

Hi Blama,

thanks for your reply.

To complete the information, the primary key consistes of two fields:

1)

Code:

<field name="ScenariosPool_ScenarioID" primaryKey="true" type="integer" hidden="true" />

which, when adding a new row, I set in:

Code:

Map<String, Integer> defaultvalues = new HashMap<String, Integer>();
defaultvalues.put(DBConstants.SCENARIOROWLABEL, scenario);
listGrid.startEditingNew(defaultvalues);

2)

Code:

<field name="EngineerNumber" primaryKey="true" type="integer" title="FSE ID" canEditGridCell="false" />

this one is inputted by the user.

**Blama** · 24 Jul 2014, 08:15

Hi Macomi,

that's one for Isomorphic.
I'd guess that this is a bug. As both your PK fields are integer (no autoincrement/identity or sequence), no lookup for the in the JBDC driver should be necessary. The SQLDriver tries it nevertheless.

As warning: You did not strip out your Password information from the logs.

Best regards,
Blama

**Macomi** · 24 Jul 2014, 08:22

Ahahahah! Thanks :)

It's a development and not production password, but I stripped it out anyway, thanks for the heads up!

**Macomi** · 25 Jul 2014, 05:25

Running the same code, with smargwtpro 3.1 (our previous license), all is fine:

Code:

=== 2014-07-25 15:21:03,764 [8-26] INFO  IDACall - Performing 1 operation(s)
=== 2014-07-25 15:21:03,764 [8-26] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2014-07-25 15:21:03,764 [8-26] DEBUG DeclarativeSecurity - DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
=== 2014-07-25 15:21:03,764 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add] No userTypes defined, allowing anyone access to all operations for this application
=== 2014-07-25 15:21:03,764 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add] No public zero-argument method named '_WFPLANDB_engineers_add' found, performing generic datasource operation
=== 2014-07-25 15:21:03,765 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] Performing add operation with
	criteria: {ScenariosPool_ScenarioID:1017,Plant:"DE93",EngineerNumber:123456,Efficiency:1,AllowCM:true}	values: {ScenariosPool_ScenarioID:1017,Plant:"DE93",EngineerNumber:123456,Efficiency:1.0,AllowCM:true}
=== 2014-07-25 15:21:03,767 [8-26] DEBUG SQLValuesClause - [builtinApplication.WFPLANDB_engineers_add] Sequences: {}
=== 2014-07-25 15:21:03,768 [8-26] DEBUG SQLConnectionManager - [builtinApplication.WFPLANDB_engineers_add] Returning borrowed connection '396717050'
=== 2014-07-25 15:21:03,768 [8-26] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add] About to execute SQL update in 'SQLServer' using connection'396717050'
=== 2014-07-25 15:21:03,769 [8-26] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_add] Executing SQL update on 'SQLServer': INSERT INTO EngineerScenario (AllowCM, Efficiency, EngineerNumber, Plant, ScenariosPool_ScenarioID) VALUES ('true', 1.0, 123456, 'DE93', 1017)
=== 2014-07-25 15:21:03,798 [8-26] DEBUG SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] add operation affected 1 rows
=== 2014-07-25 15:21:03,798 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add] primaryKeys: {EngineerNumber=123456, ScenariosPool_ScenarioID=1017}
=== 2014-07-25 15:21:03,798 [8-26] DEBUG DeclarativeSecurity - [builtinApplication.WFPLANDB_engineers_add] Processing security checks for DataSource null, field null
=== 2014-07-25 15:21:03,798 [8-26] DEBUG DeclarativeSecurity - [builtinApplication.WFPLANDB_engineers_add] DataSource WFPLANDB_engineers is not in the pre-checked list, processing...
=== 2014-07-25 15:21:03,799 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
=== 2014-07-25 15:21:03,799 [8-26] DEBUG AppBase - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
=== 2014-07-25 15:21:03,799 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Performing fetch operation with
	criteria: {EngineerNumber:123456,ScenariosPool_ScenarioID:1017}	values: {EngineerNumber:123456,ScenariosPool_ScenarioID:1017}
=== 2014-07-25 15:21:03,799 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
=== 2014-07-25 15:21:03,799 [8-26] INFO  SQLDataSource - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Executing SQL query on 'SQLServer': SELECT EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE (EngineerScenario.EngineerNumber=123456 AND EngineerScenario.ScenariosPool_ScenarioID=1017)
=== 2014-07-25 15:21:03,799 [8-26] DEBUG SQLDriver - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] About to execute SQL query in 'SQLServer' using connection '396717050'
=== 2014-07-25 15:21:03,799 [8-26] INFO  SQLDriver - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] Executing SQL query on 'SQLServer': SELECT EngineerScenario.AllowCM, EngineerScenario.CompensationInFullWeeks, EngineerScenario.DedicatedFSE, EngineerScenario.District, EngineerScenario.DistrictName, EngineerScenario.Efficiency, EngineerScenario.EngineerName, EngineerScenario.EngineerNumber, EngineerScenario.FTEFieldWork, EngineerScenario.HolidaysInFullWeeks, EngineerScenario.OfHolidays, EngineerScenario.OfSicknessDays, EngineerScenario.OfTimeCompensationInFullWeeks, EngineerScenario.OfTrainingDays_classroomOnly, EngineerScenario.Plant, EngineerScenario.PostalCode, EngineerScenario.ScenariosPool_ScenarioID, EngineerScenario.TrainingDaysInFullWeeks, EngineerScenario.ValidFrom, EngineerScenario.ValidUntil, EngineerScenario.meetingDays FROM EngineerScenario WHERE (EngineerScenario.EngineerNumber=123456 AND EngineerScenario.ScenariosPool_ScenarioID=1017)
=== 2014-07-25 15:21:03,806 [8-26] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_add, builtinApplication.null] DSResponse: List with 1 items
=== 2014-07-25 15:21:03,806 [8-26] DEBUG SQLConnectionManager - [builtinApplication.WFPLANDB_engineers_add] About to close PoolableConnection with hashcode "396717050"
=== 2014-07-25 15:21:03,807 [8-26] INFO  DSResponse - [builtinApplication.WFPLANDB_engineers_add] DSResponse: List with 1 items
=== 2014-07-25 15:21:03,807 [8-26] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2014-07-25 15:21:03,807 [8-26] DEBUG RPCManager - non-DMI response, dropExtraFields: false

Isomorphic?

**Macomi** · 25 Jul 2014, 05:31

By the way, on the 4.1 version, I tried to set sequenceMode="none" on my dataSource and to set a cacheSyncOperation that uses the correct primary keys. That solves the problem of fetching only the added row :)

However, adding is still different on the GUI.
Unlike 3.1, the added row does not stay blue waiting for the insert and resumes it there.
On 4.1, the row just disappears (although it is there if you scroll down).

**Macomi** · 25 Jul 2014, 05:48

Hmmmm, I see that the last point relates to this:

http://forums.smartclient.com/showthread.php?t=29977

http://forums.smartclient.com/showth...666#post121666

So, I should update to a nightly build > 17 July.

I confirmed that all is ok in our deployed app, so those threads apply to me.

So, the solution to the initial problem is to simply to set the dataSource to sequenceMode="none" and make a cacheSyncOperation.

**Blama** · 25 Jul 2014, 06:27

Hi Macomi,

did you try if it is enough just to set the sequenceMode="none"?
Once the PK-discovery works, the built-in default cacheSync should work as expected, shouldn't it?

Best regards,
Blama

**Macomi** · 25 Jul 2014, 06:30

Yes, it does work without the cacheSyncOperation, you are right... I was just blindly following the documentation.

However, I have to say this feels like a workaround. First because it is not needed in 3.1. Second, because in 4.1, it is not needed for updates, only for adds :(

**Blama** · 25 Jul 2014, 07:12

Hi Macomi,

of course it is only needed for add. When updating, the PK is known in all cases. For add, it might be unknown at insert-time (when using a sequence or identity column), but can be discovered after the INSERT.
Your case is a special case I'd say.
Perhaps the setting sequenceMode="none" is new with 4.0/4.1? Did you check the 3.1 docs for it?

For more details, Isomorphic has to jump in.

Best regards,
Blama

**Isomorphic** · 29 Jul 2014, 01:20

You are both right: sequenceMode is new in 4.1, and it is misbehaviing in this case - the workaround of setting sequenceMode="none" should not be necessary.

We have fixed this now - fix will be in nightly 4.1 and 5.0 builds as of tomorrow, July 30.

**Macomi** · 29 Jul 2014, 05:26

Thanks, Isomorphic!

I will reset my datasource files tomorrow then.

**Macomi** · 1 Aug 2014, 01:11

It works, without the sequenceMode=none

Thanks!

Announcement

Listgrif: setCriteria, add, fetch and filter

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment