Servoy 8.1.2

Classic Servoy
1

We are pleased to announce the availability of Servoy 8.1.2 (releasenumber 3031)

This version is available through the download at the Servoy website
and through the update site url: http://download.servoy.com/developer/8xx_updates/

This version is exactly the same, it is just a rebuild of: 8.1.2rc

Previous release notes of 8.1.2RC: this page

2

The servoy_updater.jar is also updated so it really updates also “over” beta/rc (if there is a final that has a rc before)
You can now only update this with the old updater if you specify -beta or -intermediate with the version you want

If you take the servoy_updater of 812rc or final and copy that small jar over your existing one then the updates that won’t update should be fixed.

3

Updated from 8.1.1 to 8.1.2 and no data out of SQL-Databases is available anymore on the forms. Seems that records are not loaded into the foundsets.
Tried with the developer and our “test application server”.
Using Microsoft SQL jdbc (sqljdbc42_V6.0.7728.100).

4

can you try different drivers? (don’t think we updated the one we ship in this release, we updated as far as i know only the posgresql driver)

Any errors in the log? Are the tables loaded in the developer (you see them under the database server?)

5

Any exceptions related to that in the application server log file?
I guess you already checked that the records are really there.

Ah Johan beat me to it :).

6

No errors on application server.
Tables are visible in developers database servers and queries with sql editor are loading data. Data is only missing within the started solution.
The sql driver was not updated with 8.1.2

7

now I created a testform. My results:

Datasources on forms have no record
Foundsets have no records
If I create a datasource manually (…getDataSetByQuery… createDatasource…) and push it on a form, the data is loaded

By the way: Are there changes to open the find window in developer? ctrl+shift+l is now opening a preferences window???

8

i have no idea how that is possible, especially if you don’t get any errrors what so ever
Then the database just really doesn’t return anything, without giving any error

What do you mean with datasource filled up with sql data have records?
What is exactly there what you do? foundset.load(byPKSelectQuery) ??
If that works then it is really weird, then plain pk select query (which is nothing more then select pk from table) is not working??

ctrl-shift-l is a very important short cut in eclipse itself, (it shows you and teaches you want the current context all has as short cuts)

https://wiki.servoy.com/display/DOCS/De … +Shortcuts

so we renamed that one to Alt + Shift + K
you can change that back if you want. I think this was already the case in 811

9

Do you see the queries happening on the admin page?

10

If I fill up a datasource with something like this:

var fleetDs = databaseManager.getDataSetByQuery( database,sql, null, -1 );
var fleetClientDs = fleetDs.createDataSource( 'dataSource_formName',
		[ JSColumn.NUMBER, 
		  JSColumn.TEXT,
		  JSColumn.TEXT,
		  JSColumn.TEXT,
		  JSColumn.NUMBER,
		  JSColumn.TEXT,
		  JSColumn.TEXT,
		  JSColumn.TEXT, 
		  JSColumn.TEXT, 
		  JSColumn.TEXT,
		  JSColumn.TEXT, 
		  JSColumn.TEXT,
		  JSColumn.TEXT,
		  JSColumn.TEXT, 
		  JSColumn.TEXT, 
		  JSColumn.TEXT, 
		  JSColumn.TEXT
		  ] 
	);
	vesselClientSearchFrm = solutionModel.getForm( searchform_tbl' );
	vesselClientSearchFrm.dataSource = fleetClientDs;
	
	elementsObj.vesselName = vesselClientSearchFrm.getLabel( 'schiffname' );
	elementsObj.vesselName.dataProviderID = 'schiffname';
	.....

then I get all data.

11

Log when starting a tableview:

[attachment=0]servoy1.PNG[/attachment]

servoy1.PNG
servoy1.PNG1696×588 43.8 KB

12

that datasource by query is then not sql server anymore (thats inmemory)
but i guess the databaseManager.getDataSetByQuery( database,sql, null, -1 );
is to that same sql server? And that returns data?
Because the above i can’t see all the time what it returns but the first one is pks: 0 so that query doesn’t return anything

But if a plain getDataSetByQuery returns something then it could be related to foundset filters (i think even table filters should work for getDataSetByQuery)

But what happens if you just make a sample solution that includes nothing that has no modules no tablefilters only a simple form on 1 of your tables that has data
Then that already does not return anything on the form?
And if you place a button there and you do getDataSetByQuery(“select pk from forms_table”) then that just returns data?

13

I found the bug:

I created a test solution with only one form without filters.

1. Started the solution: Form returns data

2. Added a foundset filter (my tables have a flag for deleted records called “rec_del”:
foundset.addFoundSetFilterParam(“rec_del”,“^||!=”,1,“testFsFilter”);
foundset.loadAllRecords();

Foundset returns no data

3. Added table filter:
databaseManager.addTableFilterParam()…
Tables/foundset returns no data

14

so this tablefilter with this operator: “^||!=” returns data in 811 but doesnt anymore in 812?

15

Yes, Iam using this filter since Servoy 6 and it runs in all versions except 8.1.2

16

please create a case with the above example

17

Created case Jira