Servoy 7.3

Classic Servoy
1

We are pleased to announce the availability of Servoy 7.3 (releaseNumber 2018).

This version is available through the download option on the Servoy website and auto-update.
Always make a backup of your current Servoy installation (directory and database) before installing/upgrading.
To update a Servoy eclipse open “Check for updates” via help menu.

Thanks to all testers for helping out to get a solid release!

Regular Servoy 7 docs can be found at: (especially look at “New in 7.3”)
http://wiki.servoy.com/display/DOCS/Servoy+7.x.x

Read all about how to install Servoy mobile, run the sample and possibilities at:
https://wiki.servoy.com/display/MDOCS/S … bile+7.x.x

For discussion about the mobile client see the dedicated mobile forum:
viewforum.php?f=67

The issues addressed, since Servoy 7.2 and 6.1.6 releases:

Client changes
[enh] SVY-4281 SolutionModel JSValueList is missing API to retrieve the fallback valuelist.
[fix] SVY-5041 The deferred sorting mechanism of foundsets using foundset.sort(‘column asc’, true) does not work when data is loaded in the foundset using foundset.loadRecords(QBSelect)
[fix] SVY-4958 onRender triggers only once when there is 1 record in the foundset
[fix] SVY-4663 Radio Buttons not working properly
[fix] SVY-4188 Tooltip text not being shown when renderable element is disabled
[fix] SVY-5018 Major behaviour change when stacking labels
[fix] SVY-4959 JSField.text returns always null in Servoy 7.2
[fix] SVY-4926 Duplicate Records onLoadAllRecords
[fix] SVY-4774 onRender does not fire unless selected on List view
[fix] SVY-4671 onAfterFoundsetCreateRecord isn’t fired when duplicating a record
[fix] SVY-1088 Allow databaseManager.saveData(<record_or_foundset_to_save>) to be called from within table events (before/after record is inserted/update/deleted)
[fix] SVY-5277 Setting dataprovider with name ‘valid_to’, type ‘DATETIME’ with value of wrong type

WebClient changes
[enh] SVY-1718 In order to mitigate XSS attacks, the JSESSIONID cookie defined as HttpOnly.
[fix] SVY-5078 In Chrome i see an annoying bar over my search results
[fix] SVY-4990 extra scroll bars
[fix] SVY-4942 forms not loaded in an accordion tab panel
[fix] SVY-4935 Styles defined on combobox are ignored
[fix] SVY-4915 Selecting the option “Remember Me” on the standard login page in Web Client saves the user password in plain text in a cookie
[fix] SVY-4914 Internal Error page when resizing or moving grid columns in Internet Explorer
[fix] SVY-4790 Unable to hide horizontal scrollbar in HTMLArea
[fix] SVY-4039 Setting fgcolor on textfield in table/list view: cannot use color words, only hex values
[fix] SVY-2743 The method getSelectedElements() of MULTISELECT_LISTBOX fields returns incorrect values in the Web Client
[fix] SVY-2003 It would be nice if files like pdf’s could be opened in (a new tab of) the browser instead of downloading them

Mobile client changes
[enh] SVY-4231 Servoy Mobile online mode via plugins.mobile.remoteSearch
:!: Note on SVY-4231: read all about remoteSearch at: https://wiki.servoy.com/display/MDOCS/Online+mobile
[enh] SVY-4674 Debugging does not work for Mobile Client solutions
:!: Note on SVY-4674: read all about mobile (device) debugging at: https://wiki.servoy.com/display/MDOCS/Debugging+mobile
[enh] SVY-4672 Make the JSFoundSet.getRecordIndex(JSRecord) available in Servoy Mobile
[enh] SVY-4258 Support for native apps in case of multi-location on-premise solutions
:!: Note on SVY-4258: to properly support this we added possibility for a custom login form
[enh] SVY-5011 Logout support from mobile solution.
[enh] SVY-4799 Add application.getApplicationType() and add MOBILE_CLIENT to the list of applicationType constants
[enh] SVY-5036 Possibility to use user properties in mobile service solution (being mapped to cookies)
[fix] SVY-4679 Mobile WAR deployment & Safari Private Browsing
[fix] SVY-5271 SolutionModel revertForm broken in mobile
[fix] SVY-5262 Mobile client list element not visible in scripting
[fix] SVY-5092 Datetime fields (and pickers) don’t work well on samsung phones
[enh] SVY-5117 Ability to set and get user properties for mobile client (added for fix SVY-5092)

Developer changes
[enh] SVY-3611 Manage or show the z-index of an element in the property view
[enh] SVY-4734 Ability to deprecate Forms, Relations, ValueLists and Media
[enh] SVY-937 Encapsulation support for ValueLists, Relations and Media
[enh] SVY-5037 toolTipText on tabPanel does not render i18n values or tags
[enh] SVY-4504 add JSDataSet.getColumnNames()
[enh] SVY-4567 Support multiply git repo’s
[fix] SVY-4602 Predefined arguments not cleared when method arguments are removed
[fix] SVY-4424 Unable to suppress buildmarker
[fix] SVY-5071 “INFO: …” in the debug console
[fix] SVY-5046 Clicking on media node results in error: ‘Argument not valid’ and doesn’t show any media
[fix] SVY-5031 servoy object UUID’s in workspace are changing spontaneous
[fix] SVY-5030 Warnings for mobile
[fix] SVY-5024 form event ‘onSort’ set to ‘-none-’ results in error when clicking on table header
[fix] SVY-4713 Cannot run individual unit test methods anymore
[fix] SVY-4582 using numeric type literal on string type column is accepted in relation definition
[fix] SVY-5027 table headers don’t paint correctly

Server changes
[enh] SVY-4991 postrgesql 9 new uuid type column support
[fix] SVY-4995 plugins.rawSQL.executeStoredProcedure fails when passing null arguments
[fix] SVY-5044 Timezones displaying incorrectly
[fix] SVY-4994 The export information for database views contained in .solution files does not match the source .dbi
[fix] SVY-4912 repository_server seems to be missing an important index
[fix] SVY-4714 Java update to V1.7.0_25 causes Manifest warnings in Servoy components
[fix] SVY-3851 Servoy server fails with Out Of Memory error when deployed using WAR in a web container

Plugins changes
[enh] SVY-4754 examples on how to use the JFXPanel in Servoy
[fix] SVY-4848 DBTreeView - Right Click doesn’t work in Webclient
[fix] SVY-4740 plugins.file.showFileOpenDialog

2

especially look at “New in 7.3”

There is no node in the wiki, that says: New in 7.3!

3

There is now

4

It seems that this one is going to be a solid release, perhaps even more solid than 6.1.6.

Congratulations!

5

SV 7.3 looking good so far - but the highlight in Solution Explorer that shows the Form/Code you are working on seems to have disappeared.

Have I missed a new setting?

6

I upgraded a test server from 7.2 to 7.3, and receive this error when I attempt to bring up servoy-admin:

[attachment=0]Screen Shot 2013-10-21 at 11.23.54 AM.png[/attachment]

And when I go to output of the start_servoy_clustered.bat file, this message is displayed:

[attachment=1]Screen Shot 2013-10-21 at 11.17.11 AM.png[/attachment]

I made no changes other than upgrading server and repository server. This is on a Windows Server 08 R2 machine with java 1.6_45.

Thanks,
Peter

Screen Shot 2013-10-21 at 11.23.54 AM.png
Screen Shot 2013-10-21 at 11.23.54 AM.png889×260 12.1 KB

Screen Shot 2013-10-21 at 11.17.11 AM.png
Screen Shot 2013-10-21 at 11.17.11 AM.png668×751 11.6 KB

7

Hi Graham,

Please file a case for this in the support system for this.

Rob

grahamg:
SV 7.3 looking good so far - but the highlight in Solution Explorer that shows the Form/Code you are working on seems to have disappeared.

Have I missed a new setting?

8

peterbliskavka:
I upgraded a test server from 7.2 to 7.3, and receive this error when I attempt to bring up servoy-admin
…
I made no changes other than upgrading server and repository server. This is on a Windows Server 08 R2 machine with java 1.6_45.

Thanks,
Peter

We just retried an 7.2 server upgrade and all works fine.
Questions:
Did you perhaps run the updater while server was running?
Running without clustered does work?
Fastest way out of this situation might be a clean install and reconnect to existing database.

9

Hi Rob

Case filed:

SVP-299 - SV 7.3.0 Solution Explorer highlight missing

Cheers

10

Make sure you don’t combine different Servoy versions within the same Terracotta cluster (so don’t update only some of the servers in a cluster).

11

I shut down both app servers before updating both of them.

I just did a clean install of 7.3. I can connect to the servoy admin page if I launch the servoy app server using “…/application_server/servoy_server.bat”, but I receive the same error as before if I use “…/application_server/terracotta/start_servoy_clustered.bat”.

12

grahamg:
Hi Rob

Case filed:

SVP-299 - SV 7.3.0 Solution Explorer highlight missing

Cheers

Is there a way around while this is missing? For dyslexic people this is an important feature. When this is working, it’s one less thing to look at twice before making up your mind about what you are seeing.

Bob, can you change the priority from minor to ‘major’ or something like that?

Thanks, Carlos

13

peterbliskavka:
I shut down both app servers before (…)

Shut down the Terracotta server as well. What is your persistence setting in tc-config.xml. Is it like this:

      <dso>
        <persistence>
          <mode>temporary-swap-only</mode>
        </persistence>
      </dso>

or did you switch to persistent mode? (cause then I think you need to clear that as well, closing the terracotta server would not be enough)

14

Andrei, you are correct. I didn’t take into account the persistence mode (I set ours to permanent-store). After clearing the Terracotta cache, I was able to launch both servers.

Thank you for your assistance.

15

You are welcome! :wink:

16

Hi

We’re about to upgrade our productive system (Smartclient under Windwos) to Servoy 7.3. But there are some open questions/problems which we definitely have to solve first:

  1. When does a client notice, that a new version of a solution is available? I thought - until now - this is checked every time the client launches the application. But now, we always have to delete the .Servoy Folder.

  2. When loading a foundset with more than 200 records (330) with an SQL query into a form, an aggregates and a controller.sort(…) raises an error.

  3. Did the order of events change or do you no longer raise the record selection event when the new selected index will be same as the old one? We notice a different behaviour when inserting new records: On record selection is triggered during creation of the new record (with all attributes empty) but not after creation, if the new record will be at the same position as the previously selected record.

  4. Console: What does “INFO - Debug - Skipping sort on unrelated column first_name.persons for table xy” mean?

  5. If we use a type ahead in a table view, all records have a blue background. What should the style settings be to only highlight the selected record?

Any help will be appreciated a lot. Thank you and regards
Birgit

17

HI Birgit,

did you file separated (reproducable) cases, for the issues you see?

18

No, I didn’t so far. I hoped, someone could point me to an error we made or to a known error or workaround.
It wouldn’t be so easy for some of the points anyway. And it takes time. Do you know what could bei the problem of the first point? That’s the most frightening one for me.

Thank you and kind regards
Birgit

19

rieder:
Hi

We’re about to upgrade our productive system (Smartclient under Windwos) to Servoy 7.3. But there are some open questions/problems which we definitely have to solve first:

  1. When does a client notice, that a new version of a solution is available? I thought - until now - this is checked every time the client launches the application. But now, we always have to delete the .Servoy Folder.

  2. When loading a foundset with more than 200 records (330) with an SQL query into a form, an aggregates and a controller.sort(…) raises an error.

  3. Did the order of events change or do you no longer raise the record selection event when the new selected index will be same as the old one? We notice a different behaviour when inserting new records: On record selection is triggered during creation of the new record (with all attributes empty) but not after creation, if the new record will be at the same position as the previously selected record.

  4. Console: What does “INFO - Debug - Skipping sort on unrelated column first_name.persons for table xy” mean?

  5. If we use a type ahead in a table view, all records have a blue background. What should the style settings be to only highlight the selected record?

Any help will be appreciated a lot. Thank you and regards
Birgit

Hi Birgit,

ad 1.
It should work as you described, when a smart client is launced it should automatically use the active version from the server.

ad 2.
What is the errorr that you get?

ad 4.
This message is printed if a sort is tried on a column but the relation could not be used for sorting.

20

rieder:
We’re about to upgrade our productive system (Smartclient under Windwos) to Servoy 7.3.

From what Servoy version are you coming?