Active Query Builder Java Edition - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Active Query Builder Java Edition by Active Database Software

Build complex SQL queries via an intuitive visual interface. Active Query Builder Java Edition is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder Java Edition is a Swing-based Java bean component built using JRE 6 (1.6) and supports all modern Java development environments including NetBeans, Eclipse and IntelliJ IDEA.

Common product information about Active Query Builder

Easy visual building of complex SQL queries with unions and sub-queries.

MS-Access style user-friendly interface with drag & drop support.

Two-way SQL query building (combined with SQL text editing).

Defining user-friendly aliases for tables and field names.

Powerful means of SQL query analysis and programming modification.

Working in offline mode, storing metadata in XML files.

Restricting access to unwanted objects, preventing query execution.

Sophisticated SQL parser, support of most popular database servers.

SQL query text formatting.

Integration with Java applications is achieved by setting a few properties or adding a few lines of code.

The component may be integrated into your Java application with just a few lines of code. Active Query Builder Java Edition does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible.

Full access to internal query representation objects.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Also you can edit existing queries or create new SQL queries using these objects in run-time.

JDBC and custom metadata providers.

Active Query Builder is able to retrieve metadata from all supported database servers automatically. Also it can load metadata to from any other data source using the event-driven metadata provider. Using Active Query Builder you can work disconnected providing all necessary metadata information by yourself.

List of features of Active Query Builder Java Edition.

Completely visual building of complex SQL queries

Visual building of sub-queries

Visual building of unions

Columns pane allowing to define grouping, sorting, and constructing criteria

Tree pane to browse and navigate query tree

Database objects tree pane to add objects to query

Changing real objects and field names with user-friendly aliases - Not available in free edition

Powerful programming interface

Configuring the layout of generated SQL code

Retrieving the list of parameters found in the query - Not available in free edition

Retrieving extended information about parameters: datatype, related object, field and operator - Not available in free edition

Ability to alter with metadata - Not available in free edition

Ability to define alternate user-friendly names for database objects and fields - Not available in free edition

Ability to build queries with objects from different databases - Not available in free edition

Pre-filtering of database objects to speed up metadata loading - Not available in free edition

Ability to work without live database connection - Not available in free edition

Saving and loading all metadata information to XML format - Not available in free edition

Ability to work in offline mode - Not available in free edition

Full access to internal query representation objects - Not available in free edition

Support for various SQL Dialects

ANSI SQL/92

Microsoft SQL Server - Not available in free edition

Oracle - Not available in free edition

Microsoft Access - Not available in free edition

MySQL - Not available in free edition

Firebird - Not available in free edition

IBM DB2 - Not available in free edition

Sybase - Not available in free edition

PostgreSQL - Not available in free edition

Informix - Not available in free edition

SQLite - Not available in free edition

ANSI SQL/89 - Not available in free edition

ANSI SQL/2003 - Not available in free edition

Several visual representation models

MS Access style

SQL Server Enterprise Manager style

Miscellaneous options

SQL Formatter: Plain text output filter to customize SQL code the way you like it

Ability to detect SQL Syntax dialect automatically - Not available in free edition

Full Unicode support

Full set of database connectivity options

Metadata retrieval from all supported database servers through native JDBC drivers - Not available in free edition

Generic event-driven metadata provider

Build complex SQL queries via an intuitive visual interface.

PartNumbers: PC-516519-233395 516519-233395 PC-516519-233398 516519-233398 PC-516519-233401 516519-233401 PC-516519-233410 516519-233410 PC-516519-233404 516519-233404 PC-516519-233416 516519-233416 PC-516519-233417 516519-233417

Publisher PartNumbers: 1682228 1682229 1684103 1688559 1708334

PurchaseOptions: Active Query Builder Standard Java Edition V1.1 - without Source Code 1 Developer License, Active Query Builder Standard Java Edition V1.1 - without Source Code 4 Developer Team License, Active Query Builder Standard Java Edition V1.1 - with Source Code Special Offer - Includes 1 Year Priority Support for free 1 Developer License with Source Code (includes 1 Year Priority Support for free), Active Query Builder Standard Java Edition V1.1 - with Source Code Special Offer - Includes 1 Year Priority Support for free 4 Developer Team License with Source Code (includes 1 Year Priority Support for free), Active Query Builder Standard Java Edition V1.1 - Source Code License 1 Source Code License (Requires that you already own a developer license), Active Query Builder Standard Java Edition - Priority Support 1 Developer 1 Year Priority Support License, Active Query Builder Standard Java Edition - Priority Support 4 Developer 1 Year Priority Support License

Resources: Read the Active Query Builder DataSheet, Download the Active Query Builder Java Edition V1.1 evaluation on to your computer - Limited Functionality

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000, Windows NT 4.0, Sun Solaris 10, Linux Kernel V2.6.x, FreeBSD, Mac OS X

Architecture of Product: 32Bit

Product Type: Component

Component Type: JavaBean

Compatible Containers: NetBeans, Eclipse V3.3, IntelliJ IDEA 5

Keywords: SQL query language Author active query builder, activequerybuilder, active querybuilder, active querybuilder