3.1_6.1

New 3.1 version is out. This release is compatible with Servoy 6.1. (not 6.1.1 at this moment there seems to be a problem with the conversion methods on 6.1.1. )

*** warning ***
If you are coming from a version pre 3.0.1b_6.0.6 you will have to install that version first and run the conversion method to get the layout and toolbar records. See: viewtopic.php?f=57&t=17959. This is the same case for developer and server. You don’t need todo this step on your server if you copy your framework data from your developer.


The sampleuse_navigation file includes all the modules and contains data, this is best for new installs. The svy_framework file includes all the modules, but no data, this one is for updating your existing installation.

We went from servoy sequence pk(integer) to UUID pk(text), this to make the framework compatible with the new metadata functions in 6.1, and give you the option to start using meta data. At the moment the conversion is only working if you use one framework database called “svy_framework”. Because of this change you will have to start your developer as a server to run the post import conversions on your data. The reason for this is that the maintenance plugin is used to make the changes to the data model.
IMPORTANT : This update includes a big data conversion. Be sure to make backups of your framework data and solutions first.

Dialog module
The way that continuations work in the webclient is changed in 6.1. Because we had to rewrite our dialog module to support this, we decided it was a good moment to start using the mod_dialog of servoyforge instead and no longer have two code bases for dialogs in the webclient.

If you use the dialogs module in your own code, you will have to change the calls to the module, you can do this by doing a find and replace in your entire workspace (Ctrl+H).

globals.svy_mod_closeForm > globals.svy_nav_closeForm
globals.svy_mod_dialogs_global_showCustomDialog > globals.DIALOGS.showFormInModalDialog
globals.svy_mod_dialogs_global_showErrorDialog > globals.DIALOGS.showErrorDialog
globals.svy_mod_dialogs_global_showInfoDialog > globals.DIALOGS.showInfoDialog
globals.svy_mod_dialogs_global_showInputDialog > globals.DIALOGS.showInputDialog
globals.svy_mod_dialogs_global_showQuestionDialog > globals.DIALOGS.showQuestionDialog
globals.svy_mod_dialogs_global_showSelectDialog > globals.DIALOGS.showSelectDialog
globals.svy_mod_dialogs_global_showWarningDialog > globals.DIALOGS.showWarningDialog
globals.svy_mod_showFormInDialog > globals.DIALOGS.showFormInModalDialog

Fixed from Jira, in Jira you can see more details (if you don’t have rights for this project, contact us):
SVYFRMWK-36 Disable first/back button if on first record, next/last if on last record
SVYFRMWK-58 flag mobile on menu
SVYFRMWK-65 onPreShow no longer fired for a program
SVYFRMWK-67 pre enter positions splitters of layouts
SVYFRMWK-73 Property to control whether dc_new creates records on top or bottom of foundset
SVYFRMWK-78 Coloring the fields when going to add/edit mode or back is very slow when having multiple tab panels
SVYFRMWK-83 Die Konvertierung von “UNKNOWN” in “UNKNOWN” wird nicht unterstützt on Startup
SVYFRMWK-84 Wrong globals.owner_id
SVYFRMWK-87 Buttons with more than one mode are not enabled at first
SVYFRMWK-89 onChangeOrganization
SVYFRMWK-91 Controller of multiple used sub forms is not reset
SVYFRMWK-92 Related data is saved for the wrong layout
SVYFRMWK-96 Problem in ordenation field in functions
SVYFRMWK-98 Make posible delete all field in the properties of each program
SVYFRMWK-100 Callback method is not executed after inserting and selecting a record in the lookup window
SVYFRMWK-102 Icons in the tree do not show
SVYFRMWK-108 Make svy_globals a module
SVYFRMWK-109 Search does not work with dates, concatenation of query misses a blank
SVYFRMWK-111 globals.svy_sec_hasKey only checks for the ID of a key, not the name
SVYFRMWK-112 svy_sea_restoreAdvancedSearch does not fire onPostSearch
SVYFRMWK-113 Tabs without text in framework’s layouts
SVYFRMWK-115 Global upload method
SVYFRMWK-117 The method “svy_sea_search” call "databaseManager.saveData()
SVYFRMWK-118 When I switch between two programs, automatically the selected record is lost.
SVYFRMWK-119 Add sourcefield parameter to svy_nav_showLookup, so the lookups can return a different column instead of only the pk
SVYFRMWK-120 When duplicating a program, the toolbars are not duplicated
SVYFRMWK-122 The success = databaseManager.acquireLock(foundset, -1) doesn’t work very well.
SVYFRMWK-123 Disable the edit button in lookupWindow
SVYFRMWK-124 Deleting root menu items with children crashes the client
SVYFRMWK-131 Errors when trying to run the framework on 6.1
SVYFRMWK-136 Error while save data (with database Event)
SVYFRMWK-139 Replace the use of background images through stylesheets
SVYFRMWK-143 set and get user properties
SVYFRMWK-145 on the ipad the login button has to be clicked 4 times to login
SVYFRMWK-149 Some computers can not write to the properties file, save in database instead
SVYFRMWK-152 Toolbar items that are anchored right flicker in the WC when you go to the next record.
SVYFRMWK-154 Logout with deeplink
SVYFRMWK-155 Enter security for navigation from the security module
SVYFRMWK-160 Use mod_dialog instead of svy_mod_dialogs
SVYFRMWK-161 Menu permissions not working
SVYFRMWK-163 The method “dc_export” exports ony 200 records, and not all records in the foundset.
SVYFRMWK-165 Framework Lookup
SVYFRMWK-174 Show background image also in menu item tree
SVYFRMWK-175 Framework tables have to use UUID and metadata
SVYFRMWK-185 worng type declaration in form svy_doc_revision_reason_dlg
SVYFRMWK-190 navigation buttons in pv menus
SVYFRMWK-194 Give nav_program a id - UUID and related tables
SVYFRMWK-202 Wrong Value on new Record (whith program filter)

How to update:

  1. (this step is only necessary if you use the bundled postgres database)
    Go to the ‘application_server’ folder of your Servoy installation.
    Open your servoy_server.bat in a text editor.
    Change the line:
    rem To start postgres add this to the next line:postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt
    To:
    rem To start postgres add this to the next line:
    postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt

  2. (this step will run the conversion code to update the framework data and the data model)
    Start the servoy server from your developer folder by running servoy_server.bat
    Goto you admin page http://localhost:8080/servoy-admin and go to the solutions page where you can import the solution.
    After the solution is imported succesfuly the data is converted.
    Shut the server down

  3. (this step is to get the new solutions in your workspace)
    Open the developer and do the import how you would normally.

After the import there might be some errors, maybe some help columns were not removed. You can right click in the problem tab on the errors and choose quick fix. Then choose for ‘Delete column from DB table because it has no column information associated’. (Help columns are columns that and on ‘2’.)

If you want assistance with this update, please let us know.

Warning: there is a new release, use that one instead: viewtopic.php?f=57&t=18750
[attachment=4]svy_framework.servoy[/attachment]
[attachment=1]sampleuse_navigation.servoy[/attachment]

[attachment=3]Document_management.pdf[/attachment]
[attachment=2]Security.pdf[/attachment]
Navigation documentation: http://servoy.com/resources/fw/Navigation.pdf

=======================================
Patch 01

To solve the next 2 cases there is a patch. Replace all the methods in your solution with the ones in the patch.
[attachment=0]Patch_01.txt[/attachment]

This wil solve the cases:

SVYFRMWK-214 After cancel new record message ‘There are edited related records, do you want to save them?’
SVYFRMWK-215 Tab filter is still working on programname

Patch_01.txt (8.54 KB)

sampleuse_navigation.servoy (1.92 MB)

Security.pdf (1000 KB)

Document_management.pdf (101 KB)

svy_framework.servoy (1.54 MB)

Thanks !

Hello!
I made the clean installation and when i try to login with ALT + L it respond

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

Hi Andrej,

probably the User table is empty: try to verify if it is true.

I see that at the moment there is no sample data for the framework database in the export file. I think this is because I tried to use meta data, I will try to find a solution for this.

Added the navigation documentation: http://servoy.com/resources/fw/Navigation.pdf

I replaced the sampleuse_navigation.servoy file. It has now meta data for the svy_framework tables included.

Thanks! Now it works perfectly!

Thanks for the new version. I have done a new installation because I had a lot of problem with the update. Now it works but I have a problem with the security for toolbars. I have a lot of security keys but after choosing them for a toolbar (Configurator–>Program–>Toolbars) I get the following error:

Setting dataprovider with name ‘security_key_id’, type ‘TEXT’ with value of wrong type ‘Toolbar_button_no_access’

java.lang.IllegalArgumentException: Setting dataprovider with name ‘security_key_id’, type ‘TEXT’ with value of wrong type ‘Toolbar_button_no_access’.

briese-it:
Setting dataprovider with name ‘security_key_id’, type ‘TEXT’ with value of wrong type ‘Toolbar_button_no_access’

java.lang.IllegalArgumentException: Setting dataprovider with name ‘security_key_id’, type ‘TEXT’ with value of wrong type ‘Toolbar_button_no_access’.

I tried this but I don’t have problems. You can also set security on menu items from the side of the security key now. Open security configurator → goto keys → Tab rights → tab program toolbar item → new button to add security.

Do you have the same errors here?

Hi Sanneke, thanks for your info and the nice function. Regarding my error: I have changed the Type-Ahead field in configurator–>Program–>Toolbars to a Combo Field and now it works. Really strange but anyway, it works.

See patch 01 on the original post.

Warning: at this moment there seems to be a problem with the conversion methods on 6.1.1.

I’m having problems importing sampleuse_navigation.servoy into 6.1.0 on Mac OS X 10.5.8. It’s currently running but with CSS errors.

  1. Deleted servoy and servoy_workspace folders.
  2. Restarted computer.
  3. Installed 6.1.0, created svy_framework database connection.
  4. Quit servoy then restarted.
  5. Imported most recent sampleuse_navigation.servoy (after ALT+L problem reported on forum).
  6. Import hung on import window. If tried to close, error message in attached window #1 appeared.
    [attachment=2]window #1.jpg[/attachment]
  7. Forced servoy quit then restarted.
  8. Started smart client, message in attached window #2 appeared but login window came up over it blank, pressed ALT+L, nothing happened, wouldn’t proceed.
    [attachment=1]window #2.jpg[/attachment]
  9. Quit servoy, message in window #3 appeared.
    [attachment=0]window #3.jpg[/attachment]
  10. Restarted servoy, message appeared concerning CSS problems, didn’t save window.
  11. Re-imported solution, over-wrote everything, another CSS error window appeared but import appeared to finish.
  12. Started smart client, login window appeared blank, pressed ALT+L, logged in.
  13. Closed smart client, quit from Servoy, message in win #3.

fredc:
I’m having problems importing sampleuse_navigation.servoy into 6.1.0 on Mac OS X 10.5.8. It’s currently running but with CSS errors.

Its seems like an eclipse issue. Could you make a case in the servoy system http://www.servoy.com/s on the servoy project and also attache your log file from eclipse (Servoy\servoy_workspace.metadata.log)?

I have a big problem with 6.1.1 and the new framework. In the developer everything is running normal but I can’t get it running on the application server. First of all I can’t export with meta-data. I get an errormessage without text. Only “x” and I can click on ok. Admin-Log:

Category: com.servoy.j2db.persistence.XMLExporter
Message: java.io.UTFDataFormatException

Export without meta-data is running normal. I have testet to export with metadata and without the framework-modules and thats ok.

Import on the application.server is ok and login is working, too. When I click on a menu button on the application-server I get the following error:

TypeError: Cannot read property “elements” from undefined (layoutShow#40)

No error on the AdminPage.
Please note: Developer and ApplicationServer are using the same database svy_framework.

Clicking Strg+1 has the error:

Data exception: invalid character value for cast

and opens normal after clicking ok. The main-menu page is blank after closing the Configurator. The data exception gives the following error on the admin page:

java.sql.SQLException: data exception: invalid character value for cast
at org.hsqldb.jdbc.Util.throwError(Util.java:81)
at org.hsqldb.jdbc.JDBCPreparedStatement.setParameter(JDBCPreparedStatement.java:4268)
at org.hsqldb.jdbc.JDBCPreparedStatement.setObject(JDBCPreparedStatement.java:1055)
at org.hsqldb.jdbc.JDBCPreparedStatement.setObject(JDBCPreparedStatement.java:1002)
at sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.datasource.Zg.invoke(Zg.java:17)
at $Proxy0.setObject(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:125)
at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:1392)
at com.servoy.j2db.dataprocessing.Zv.performUpdates(Zv.java:1364)
at com.servoy.j2db.dataprocessing.Zv.insertDataSet(Zv.java:1306)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Because of that it’s not possible to test the modules on the server.
It’s really urgent because our clients have to test the solution !!! Please help !!!

This version of the framework seems to be not compatible with Servoy 6.1.1.
I discovered it yesterday…

I am a bit disappointed for this problem. I can understand why passing from 6.1.0 to 6.1.1 not to 7.x or 6.2 can be problems on conversion methods…Two releases in less then 10 days from the same company…One like me that need the two new version because they contain new options and some corrected bugs has to wait for another upgrade of the framework…

It seems that every update of Servoy or of the framework is always a “leap in the dark”.

We are looking forward hopeful

We are sorry that there are problems in 6.1.1 but at the time that we released 6.1.1 was not out yet. We are working to get those problems solved.

Hi,

is it possible to use the old style with the new framework? I followed the instructions as per the previous beta release but the login form does not even show up (attached is the screenshot).

Thanks in advance.

Never mind, I solved the mistery, the login solution had the wrong login form/first form set.