| Connect any database
In principle, with XDEV 3 you can access any database that provides a JDBC driver or via ODBC-JDBC Bridge, for example, to access MS Access.
| XDEV 3 interfaces for database-independence
Beyond the JDBC standard, to some extent there are still significant differences between SQL dialects associated with various databases. In practice therefore, code adjustments must be made to many parts of the program when databases are switched. This is not only time consuming, it is also a significant source of errors. To prevent this, XDEV 3 provides its own database interfaces, which expand the JDBC drivers for the respective databases and abstract the SQL differences not covered by JDBC. The result is a much improved, in comparison to JDBC, database-independence, whereby you will no longer have to make any adjustments to the program code if the database is switched. The Framework provides you with the corresponding interfaces for all of the major databases.
| Query Assistant – rapidly click-together your database queries
XDEV 3 provides you with a powerful Query Assistant, which lets you rapidly click together even the most sophisticated of queries; there is no need to write any SQL code. For queries involving multiple tables, the Assistant generates all joins automatically. The construction of even complex filter conditions is intuitive. The use of all SQL functions is also supported. The Query Assistant then automatically generates the entire query code in the form of Java objects, meaning you don’t have to write a single line of SQL code. It is as simple as that. In comparison to SQL, the generated Java code is fully database-independent. This makes it possible for you to switch the database at any time, without having to modify all of the database queries. Not only does this save you from having to perform a Sisyphean task, it also closes a significant error source. The SQL code for the respective connected database will only be generated at runtime.
| SQL Engine
Only during runtime will the SQL code for the respective connected database will be generated by an SQL engine and sent to the database.
| Transaction Management
With its XDEV Application Framework, XDEV 3 provides you with transaction security for all database accesses – without any additional programming effort. The XDEV 3 Code Editor also provides you with a transaction code template, into which you only have to insert the code for the database access. Accessing multiple databases, even different DBMS, within a transaction is also possible.
| Calling a stored procedure
To call stored procedures, XDEV 3, via the XDEV Application Framework, provides a method callStoredProcedure.
| Security concept
For database accesses you have implemented via interfaces accompanying the XDEV Application Framework from XDEV 3, the data transferred will automatically be encrypted (Diffie-Hellman method), so that you no longer have to take care of this.
| Design database tables directly in XDEV 3
The Data-Editor lets you design database tables directly in XDEV 3 which you can then export to any database. Conversely, as it is also possible to import database tables you can also use the Data-Editor to migrate databases or individual tables.
| Accessing multiple databases simultaneously
With XDEV 3 you can access any number of databases and different DBMS. You only have to link to the corresponding data sources and set the desired data source prior to the query.
| HSQLDB and H2 are included in XDEV 3
Together with XDEV3 you also receive the HSQLDB and H2 Java SQL database engines as standard and test databases. Both are relational database management systems written in Java. The engines are tiny compared to other databases such as MySQL and for the most part they comply with the SQL standard. This is why they are used as an embedded database in many solutions. HSQLDB is a component of Open Office. H2, the newer of the two, is a completely redeveloped database which is considered more sophisticated and is significantly faster.
In completing your projects with XDEV 3, you can use the Assistant to easily link your H2 or HSQLDB to your application, resulting in a fat-client (total package) deliverable. HSQLDB and H2 are open source (BSD, EPL or MPL license) and are completely license free, even for commercial use.