Documentation

Trace: Technical FAQ

(visionx)

Technical FAQ

This is an old revision of the document!


Firewall setup

VisionX requires http (port 80) and https (port 443) to cloud.sibvisions.com for e.g. solution store, cloud management and other features.

Which database & which platform are you using?

VisionX supports all major database vendors: Oracle, Postgres, MySql/MariaDB, MS Sql, DB2, Hana. We're using Java and support all Java application servers like: Tomcat, Wildfly, Glassfish, etc. You can deploy the created application with VisionX or manually, to the cloud, on premise, or as client/server desktop application.

Is VisionX on premise or a cloud service?

We offer both, but VisionX always runs on your local workstation.

What are the requirements for deployed applications?

A VM/Server with Java 8, a Java application server and one of the supported databases, e.g. CentOS VM, OpenJDK 8, Apache Tomcat, Postgres.

Can we integrate with Active Directory?

Yes, that's possible with Microsoft AD, but it is not included.

Which Vaadin UI version is included?

We use the latest Vaadin UI based on Vaadin 8.1.6. The system requirements for Vaadin 8.1.6 can be found here.

When dragging a table into a screen...Do you query all records

We have lazy loading everywhere and per default we only load the records that you see on the screen and some more to fill a buffer. We usually load records for about 100 milliseconds but at least the visible amount. The scrollbar shows that more rows are there. When you scroll down, more rows are loaded. The speed depends on the database query/performance and network speed.

Is it possible to search based on 2 or more columns (but not all columns)

No problem, just drag another search field from the bottom of the screen. Choose a column and condition (equal, smaller, …) for each field. All of them will be combined with an AND. A search field without specific condition will act as full-text search for “all columns”.

Is it possible to create a drop down based on a query?

For example: select distinct (S_YEAR) from PERSON_LIST

Be careful because distinct queries are usually “slow”, because of the force full table scan at the database level. To use a custom query for a drop down you do the following:

  • Add the table/view as data object in the bottom of the VisionX designer e.g. PERSON_LIST
  • Change the query in the data wizard in the bottom right corner e.g. add the distinct keyword before the query columns
  • Go to your base table where the drop down should be used, define a manual combobox there, and choose PERSON_LIST object from previous step

Additional information:

Views and Storages
Create Dropdown Without Foreign-Key Relation

Out of memory in VisionX

If you get an Out of memory or a Java heap space error, simply increase the memory of VisionX in visionx.bat or visionx.sh:

@ECHO OFF
.\runtime\bin\java -Xmx512M ... -jar lib\visionxloader.jar

Change 512M to e.g. 1G or 1500M. Don't forget to restart VisionX.

Additional JVM start parameters

On Windows, VisionX is usually started with visionx.exe. To define additional JVM parameters, however, visionx.bat or visionx.sh must be used, as any JVM parameters can be set with it, e.g .:

@ECHO OFF
.\runtime\bin\java -Xmx512M -Dfile.encoding=UTF-8 ... -jar lib\visionxloader.jar

In this example, the system parameter file.encoding was set to UTF-8.

However, it is entirely possible to set any JVM parameters when using visionx.exe. Since VisionX uses the open source project launch4j, all features of the library can be used, such as the possibility of entering the JVM parameters in an ini file:

All you have to do is create a file called visionx.l4j.ini in the same directory as visionx.exe. The file can then be filled with the desired parameters:

-Dfile.encoding=UTF-8

How to start VisionX with de_CH language settings

Simply change the start script (visionx.bat, visionx.sh) and add your language settings:

-Duser.country=CH -Duser.language=de_CH -Dtomcat.arguments=-Duser.country=CH;-Duser.language=de_CH

Full script:

visionx_de_CH.bat
@ECHO OFF
.\runtime\bin\java -Duser.country=CH -Duser.language=de_CH -Dtomcat.arguments=-Duser.country=CH;-Duser.language=de_CH -Xmx512M --add-opens=java.base/jdk.internal.loader=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED -jar lib\visionxloader.jar

If you use Windows and start VisionX with visionx.exe, it's also possible to create a file with the name visionx.l4j.ini:

visionx.l4j.ini
-Duser.country=CH
-Duser.language=de_CH
-Dtomcat.arguments=-Duser.country=CH;-Duser.language=de_CH
This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information