Trace:
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
visionx:faq_tech [2021/06/30 10:51] admin |
visionx:faq_tech [2021/09/03 07:13] admin |
||
|---|---|---|---|
| Line 24: | Line 24: | ||
| 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. | 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: | ||
| + | |||
| + | [[visionx:data_modeling_and_representation#views_and_storages|Views and Storages]] \\ | ||
| + | [[visionx:data_modeling_and_representation#create_dropdown_without_foreign-key_relation|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: | ||
| + | |||
| + | <code> | ||
| + | @ECHO OFF | ||
| + | .\runtime\bin\java -Xmx512M ... -jar lib\visionxloader.jar | ||
| + | </code> | ||
| + | |||
| + | 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 .: | ||
| + | |||
| + | <code> | ||
| + | @ECHO OFF | ||
| + | .\runtime\bin\java -Xmx512M -Dfile.encoding=UTF-8 ... -jar lib\visionxloader.jar | ||
| + | </code> | ||
| + | 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: | ||
| + | |||
| + | <code ini> | ||
| + | -Dfile.encoding=UTF-8 | ||
| + | </code> | ||
| + | |||
| + | ==== How to start VisionX with de_CH language settings ==== | ||
| + | |||
| + | Simply change the start script (visionx.bat, visionx.sh) and add your language settings: | ||
| + | |||
| + | <code> | ||
| + | -Duser.country=CH -Duser.language=de_CH -Dtomcat.arguments=-Duser.country=CH;-Duser.language=de_CH | ||
| + | </code> | ||
| + | |||
| + | Full script: | ||
| + | <file dos 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 | ||
| + | </file> | ||
| + | |||
| + | If you use Windows and start VisionX with visionx.exe, it's also possible to create a file with the name visionx.l4j.ini: | ||
| + | <file ini visionx.l4j.ini> | ||
| + | -Duser.country=CH | ||
| + | -Duser.language=de_CH | ||
| + | -Dtomcat.arguments=-Duser.country=CH;-Duser.language=de_CH | ||
| + | </file> | ||
| + | |||
| + | ==== WAR creation shows compiler errors! ==== | ||
| + | |||
| + | Usually such problems occur if you do manual coding with an IDE. To find out what's the compiler error, simply enable logging and add the line | ||
| + | |||
| + | com.sibvisions.visionx.server.ant.AntRunner.level = ALL | ||
| + | | ||
| + | to the file **''<visionx>/lib/logging.properties''**. Read more information about [[visionx:visionx_logging|VisionX logging]]. | ||
| + | |||
| + | Another option is to start the war creation manually with included ANT build file: **build.xml**. | ||
| + | The ''start.complete'' task will create the war file | ||