Servoy 2020.03.1_LTS

Servoy announcements

Servoy 2020.03.1_LTS

Postby jcompagner » Fri Jul 24, 2020 5:16 pm

We are pleased to announce the availability of Servoy 2020.03.1_LTS (release number 3563)

This version is available through the the download site

or through the update site URL: http://download.servoy.com/developer/lts (this wil only work if you come from a 2020.3 or lower release, you can't "update" from 2020.06)
If you want to use the LTS release enable the above lts update site and disable the 'latest' update site so you only update to lts updates.

This includes a bunch of fixes that are also already in 2020.06 and a few more, see 2020.03.1_lts_fixes

this does replace the 2019.03.2 lts release.

For solutions that are already in production it is a good idea to stick to this version if you don't need to newer features right now.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 2020.03.1_LTS

Postby huber » Tue Aug 04, 2020 2:32 pm

Thanks for this new Servoy Developer release, very nice. I installed it without problems on macOS 10.14.6. Only annoyance I found so far is when starting the Developer, I get a Servoy Login window where I have to enter Email and Password. I was assuming this is a one time step, but it's appearing at every Developer startup. Is there a way to avoid this?

Best regards,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby jcompagner » Tue Aug 04, 2020 3:00 pm

Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 2020.03.1_LTS

Postby huber » Wed Aug 05, 2020 8:49 am

Thanks, Johan, that solved the problem.

Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby huber » Thu Aug 06, 2020 11:28 am

Using this Developer (2020.03.1._LTS), creating and deploying/importing a context (WAR file) and a solution (.servoy file) works fine.

Starting the application (with Java Web Start) leads to following error which blocks the application start:

Code: Select all
Java Web Start 11.221.2.11 x86_64
Using JRE version 1.8.0_221-b11 Java HotSpot(TM) 64-Bit Server VM
User home directory = /Users/admin
----------------------------------------------------
c:   clear console window
f:   finalize objects on finalization queue
g:   garbage collect
h:   display this help message
m:   print memory usage
o:   trigger logging
p:   reload proxy configuration
q:   hide console
r:   reload policy configuration
s:   dump system and deployment properties
t:   dump thread list
v:   dump thread stack
0-5: set trace level to <n>
----------------------------------------------------
CacheEntry[http://localhost:8080/7r/servoy-client/Hades/Hades.jnlp]: updateAvailable=true,lastModified=Thu Aug 06 10:54:54 CEST 2020,length=-1
CacheEntry[http://localhost:8080/7r/servoy-client/Hades/Hades.jnlp]: updateAvailable=false,lastModified=Thu Aug 06 11:22:01 CEST 2020,length=-1
#### Java Web Start Error:
#### Unable to load resource: (http://localhost:8080/7r/lib/log4j.jar?version-id=ERROR_1596704097387&current-version-id=1593770090000, ERROR_1596704097387)


Any hint how to correct this log4j.jar problem?

Regards,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby jcompagner » Thu Aug 06, 2020 11:36 am

there is no log4j.jar in our lib (already for quite some time, because we moved to the new log4j 2.x)

So it seems you have a plugin installed with its own jnlp file that still points to that lib/log4j that plugin needs to be updated.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 2020.03.1_LTS

Postby huber » Thu Aug 13, 2020 8:24 am

We finally solved it by updating all of the plugins and it seems, key point was to clear all of the Java cache. Now we are on Servoy Developer 202003.1 LTS :-) Very nice.

Thanks for your help and best regards,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby huber » Thu Aug 13, 2020 11:01 am

In the Whats new > Features section of the Servoy Wiki (https://wiki.servoy.com/display/DOCS/2020.03+Whats+new), it is stated:

Databases who are supporting this (for now only postgresql) will use the ANY (?) instead of IN (?,?,?) when possible for queries.


I am not sure about how to read this. The ANY keyword needs a preceding operator like =, >, … so the equivalent for the "IN" is "= ANY". Is my assumption correct that IN is replaced by "= ANY"?

Furthermore, how to read the Postgres part: For example, SQL Anywhere 17 is supporting ANY. Does the ANY support for Postgres mean that support for additional databases like SQL Anywhere will be added successively in the future?

Thanks for clarification.

Regards,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby jcompagner » Thu Aug 13, 2020 11:29 am

yes it is replaced by = ANY

If the database and the jdbc driver do support this would could add more, but for example ms sql doesn't support this.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 2020.03.1_LTS

Postby huber » Wed Aug 19, 2020 12:03 pm

Importing one of our applications as .servoy file leads to the attached warning on solution import. As the creation of the index is done at importing the solution by Servoy, I assume I can't influence this. It's an assumption, as the warning text is not completely clear to me.

Regards,
You do not have the required permissions to view the files attached to this post.
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby jcompagner » Wed Aug 19, 2020 12:36 pm

you also should have an error in the log:

log.error("Failed to create an index on the messages table", e);

It could be that there is already an index like that.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 2020.03.1_LTS

Postby huber » Wed Aug 19, 2020 3:28 pm

Found this entry in the Servoy_log.text file. There is a pk index on this table, so I assume the warning references with a high probability a primary key index.

Regards,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby jcompagner » Wed Aug 19, 2020 5:30 pm

this is not about the pk
this is just an index that we try to create on the message_key column
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 2020.03.1_LTS

Postby huber » Thu Aug 20, 2020 8:27 am

There is no index on the column message_key. So don't know why the import process is not able to create an index for column message_key.
Of course I could create an index on this column manually, but don't know if that is useful, as then it would conflict with the import process trying to create an index for this column.

jcompagner wrote:this is not about the pk
this is just an index that we try to create on the message_key column
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Re: Servoy 2020.03.1_LTS

Postby jcompagner » Thu Aug 20, 2020 9:23 am

why it fails should be reported in the log as i said before..
we also log the error: log.error("Failed to create an index on the messages table", e);
(besides reporting it to the import channel that you show above)
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Next

Return to Announcements

Who is online

Users browsing this forum: No registered users and 25 guests