Handling a database from a Java application You can start developing your application as soon as the WINDEV project is defined as being a Java project...... Java application and WINDEV A Java application is an application entirely compiled in Java...... Native Oracle Connector: Programming with HFSQL functions To use an Oracle database with the Native Connector, the structure of ORACLE tables must be imported into the WINDEV or WEBDEV analysis...... Native Oracle Connector for WINDEV and WEBDEV WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... Native Oracle Connector: Programming with SQL functions The SQL functions can be used to handle the ORACLE database, regardless of whether WDORAINS is used or not to configure the accessed database...... Configuring the connection with WDORAINS (optional setting) For backward compatibility with the earlier versions of Native Oracle Connector (also called Native Oracle Access), the connection can still be configured in WDORAINS (supplied with Native Oracle Connector)...... Native Oracle Connector: Specific features and remarks Remarks and specific features of the Native Oracle Connector... Setup of the WEBDEV Application Server for Linux The installation package (or DVD, if provided) allows you to install...... Setup of the WEBDEV Application Server for Linux Handling data files in PHP WEBDEV allows you to create a PHP site that handles data files...... Native Oracle Connector for WINDEV and WEBDEV License agreement for Native Oracle Connector License agreement for Native Oracle Connector... 16. Java applications in practice Java applications in practice... HConnect (Function) Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. Generating SQL scripts The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...... OLE DB: Required configuration To handle a database via OLE DB, the following elements must be installed on the development computer and on the deployment computer...... WDSQL: Database structure WDSQL is used to find out the structure of the accessed database...... 13. Universal replication 12. Universal replication Multi-database queries A query (typed in SQL code) can operate on different databases...... Native Oracle Connector: Retrieving the output value of a stored procedure The Native Oracle Connector is used to: specify the input values during the call to a stored procedure. retrieve the output values after a call to a stored procedure.... Deploying a Java archive Like for any application, WINDEV allows you to create a setup program for a Java application...... WDConver : Overview WDConver is a tool used to convert data to an HFSQL Classic data file from...... Accessing a database via a web service The database can be accessed via a web service...... Synchronizing the analysis with external databases The analysis must be synchronized with an external database if it uses......