ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing in Java
  • Overview
  • Summary table
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Managing databases in the WINDEV Java applications
Overview
This document presents the different access modes to databases from a WINDEV Java application.
Summary table
Database/Operating systemWindowsLinuxMac
HFSQL Client/Server or networkDirect access with the Hxx or SQLxx functions with the following DLLs in the runtime directory:
  • wd290hf.dll
  • wd290jav.dll
  • wd290sql.dll
  • wd290vm.dll
Depending on the features used, the following libraries may also be required: wd290pnt.dll, wd290trs.dll, wd290uni.dll.
These libraries are located in WINDEV's "Programs" subdirectory.
Java applet: the .dll cannot be included in the applet (they must be installed or downloaded automatically).
Direct access with the Hxx or SQLxx functions with the following libraries in the runtime directory:
  • wd290hf.so
  • wd290jav.so
  • wd290sql.so
  • wd290vm.so
Depending on the features used, the following libraries may also be required: wd290pnt.so, wd290trs.so, wd290uni.so.
These libraries are available in the "Programs\Framework\Linux" subdirectory of WINDEV.
Java applet: the .so cannot be included in the applet (they must be installed or downloaded automatically).
Direct access with the Hxx or SQLxx functions with the following libraries in the runtime directory:
  • wd290hf.dylib
  • wd290jav.dylib
  • wd290sql.dylib
  • wd290vm.dylib
These libraries are available in the "Programs\Framework\MacOSX" subdirectory of WINDEV.
Java applet: the .dylib cannot be included in the applet (they must be installed or downloaded automatically).
Note:
  • For a direct access to an HFSQL Classic Network database, the data must be found on the local network. The data cannot be found on a Windows share accessible from the Mac.
  • For a HFSQL Client/Server database, the data can be found locally or remotely.
Native MySQL, SQL Server or SQLite AccessDirect access possible with the Hxxx or SQLxxx functions (no DLL on the user computer)Direct access possible with the Hxxx or SQLxxx functions (no .so on the user computer)Direct access possible with the Hxxx or SQLxxx functions (no .dylib on the user computer)
Notes:
- The JDBC driver must be included in the archive
- Make sure that the JDBC driver is compatible with Windows
Notes:
- The JDBC driver must be included in the archive
- Make sure that the JDBC driver is compatible with Linux
Notes:
- The JDBC driver must be included in the archive
- Make sure that the JDBC driver is compatible with Mac
Any database that includes a JDBC driverDirect access possible with the SQLxxx functions only (no DLL on the user computer)Direct access possible with the SQLxxx functions only (no .so on the user computer)Direct access possible with the SQLxxx functions only (no .dylib on the user computer)
Notes:
- The JDBC driver must be included in the archive
- Make sure that the JDBC driver is compatible with Windows
Notes:
- The JDBC driver must be included in the archive
- Make sure that the JDBC driver is compatible with Linux
Notes:
- The JDBC driver must be included in the archive
- Make sure that the JDBC driver is compatible with Mac

Some important points regarding the access to data from a Java application in WINDEV:
  • The execution performed in test mode is not a Java execution but a Windows execution. Therefore, a different connection must be established depending on whether the test mode is used or not (for example: OnTestMode()=True).
  • The RMI and JDBC connections cannot be defined in the analysis. These connections must necessarily be defined through programming (SQLConnect or HOpenConnection).
  • The main differences between Java Archive, Java and Java Web Start Archive are as follows:
    • Java Archive ~= Java application to run/install on a user computer.
    • Java Applet ~= Java application to run via a Web page in a Web browser.
    • Java Web Start Archive ~= Java application run from a Web page but that is run locally like a standard Java application but with a system for automatic Java Web Start update.
Minimum version required
  • Version 14
Comments
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help