PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Summary table
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
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:
  • wdxxxhf.dll
  • wdxxxjav.dll
  • wdxxxsql.dll
  • wdxxxvm.dll
Depending on the features used, the following libraries may also be required: wdxxximg.dll, wdxxxtrs.dll, wdxxxuni.dll.Depending on the features used, the following libraries may also be required: wdxxxpnt.dll, wdxxxtrs.dll, wdxxxuni.dll.
These libraries are supplied in the "Programs" sub-directory of WINDEV.
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:
  • wdxxxhf.so
  • wdxxxjav.so
  • wdxxxsql.so
  • wdxxxvm.so
Depending on the features used, the following libraries may also be required: wdxxximg.so, wdxxxtrs.so, wdxxxuni.so.Depending on the features used, the following libraries may also be required: wdxxxpnt.so, wdxxxtrs.so, wdxxxuni.so.
These libraries are supplied in the "Programs\Framework\Linux" sub-directory 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:
  • wdxxxhf.dylib
  • wdxxxjav.dylib
  • wdxxxsql.dylib
  • wdxxxvm.dylib
These libraries are supplied in the "Programs\Framework\MacOSX" sub-directory 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 a 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 by programming (SQLConnect or HOpenConnection...).
  • The main differences between Java Archive, Java and 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 required version
  • Version 14
Comments
Click [Add] to post a comment