Databinding

VirtualTable

Database interfaces

DBInterface

Automatized database queries

AutoQueries

Lazy-Loading

Paging

Security concept

Security

Persistence

Persisting

Record locking

Locking
Following databases are supported:
The XDEV Application Framework provides an abstract data layer with its Virtual Tables, which enables simple and completely incomplex data communication between database and user interface. Virtual Tables are saving tons of programming effort, including complex querying and creating GUI Models and renderers.
XDEV 5 provides interfaces for every important database, based on JDBC. With those, partially substantial differences between the different databases and the JDBC standards concerning the SQL syntax can be abstacted and mapped to specific Java types. Beyond that, the interfaces take care about encrypted data communication as wel as connection pooling. XDEV 5 makes your application database independent and can be run with every important databases from the start. Switching databases is possible at any time without any problems, without having to change the querying logic of your application.
Lists, tables and trees can be filled automatically with data, so that you don't have to generate any querying logic. Even complex JOINS, spanning many tables, are done by the used Virtual Table automatically.
Barely or even completely unfiltered database queries are not returning the entire result at once, but showing only as much records as being able to be displayed inside the target component instead. The remaining records are loaded on demand.  The big advantages of this method are
1.) best performance possible and
2.) even gigantic result sets cannot trigger a memory overflow

Loading the data happens either record for record by moving the scroller or via paging with a new control, the XdevDBPageNavigationBar, which simply has to be connected to a respective ListBox or Table. Everything else is done by the Framework in the background automatically. And best of all, Lazy-Loading also works with your own custom queries.
With the aid of a special SQL-Engine, database queries can be phrased directly in Java. The syntax is as easy to read as SQL. Other than SQL, however, Java objects are always database independent, so that changing the database is possible at any time without any problems. The SQL code is generated dynamically at runtime, converted to Prepared Statements and then sent to the database.
The XDEV Application Framework also takes care of saving your data. Not only forms, but also edited tables can be persisted with a single method- call. This way, only new and edited data will be synchronized with the database. When and for which data persitency happens is up to the developer.
The XDEV Application Framework offers transaction security for every database access without additional programming effort. The XDEV 5 Code- Editor provides a transaction code template, that has only to be filled to work. Accessing multiple databases and even different DBMSs in a single transaction are possible.
SQLEngine

SQL-Engine

Die database interfaces of the XDEV Application Framework offer you an extensive security concept, so that you do not have to care about this at all. Database queries are not sent as SQL-Strings, but as Prepared Statements to prevent SQL-Injections. The data transfer follows the Diffie- Hellman key exchange, which is considered to be non-solvable. This concept can be exchanged by any other implementation at any time.
Transactions

Transaction management

StoredProcedures

Stored Procedures support

XAPI

API

OpenSource

Open Source

ConnectionLeakTracker

Connection-Leak-Tracker

XDEV 5 offers a method to call Stored Procedures as well as a comfortable wizard.
The XDEV Application Framework also offers a large variety of helpful functions that are needed for every database application, including access to databases, files, computer memory, desktop as well as to external applications.
The XDEV Application Framework is available as Open Source Software published under the LGPL license. This allows the use of the Framework independently of XDEV 5 for commercial usage and selling closed source software products.
The XDEV Application Framework is now providing an API to detect unwanted open database connections.
Even concurrent database access is managed by the Framework. Both optimistc and pessimistic locking strategies are supported. With the aid of business rules, both variants can be cusomised very easily to fit individual requirements, for instance how long the lock has to last, under which circumstances it will be released or how the end user will be informed about locks.
oracle
Oracle
postgresql
PostgreSQL
sqlite
SQLite
sybase
Sybase
h2
H2
informix
Informix
ingres
Ingres
mysqlIcon
MySQL
mssqlIcon
MS SQL Server
cache
Caché
db2
DB2
db2i
DB2 for iSeries
firebird
Firebird
hsql
HSQL
The XDEV Application Framework forms the main component of XDEV's RAD concept aside from the GUI-Builder. The Framework provides a base architecture and infrastructure for graphical user interfaces and database applications and releases you from many tasks, that developers have to usually program themselves, including data binding, processing results (Resultsets), transaction management and data encryption. Beyond that, the Framework offers a compact function library (XAPI) containing a big variety of functions, which simplify the access to databases, files, computer memory, interfaces and external applications. The XDEV Application Framework is Open Source.

XDEV Application Framework

XDEV 5
ABOUT
 
SERVICES
 
FEATURES
 
COMMUNITY
 
XDEV5_Logo