HotQuery for J2EE Specifications
Requirements		1. Sun Java 2 SDK version 1.4.2 or higher 2. J2EE servlet container compliant with...   a. Servlet 2.4   b. JSP 2.0   c. JSTL 1.1   Note: HotQuery works with the free Apache Tomcat version 6 3. JSTL 1.1 4. Oracle, SQL Server or MySql JDBC driver 5. Database access with rights to create a user, tables (& sequences for Oracle).
Databases		1. Oracle 7 thru 10g 2. Microsoft SQL Server 2008 3. Mysql 5+
Platforms		Windows, Unix, Solaris, Linux
Web Servers		Microsoft IIS, Apache, NetScape, Sun
User Rights		Respects native database access rights. User authentication is preformed by the database. Users can query & view data only from the tables & views they were granted rights to in the database. Note: HotQuery does not store any user passwords.
Tables joins		Unlimited
SQL code		Automatic generation, based on user's point & click selections
SQL Functions		Average Min Max Sum Count Distinct column selection Grouping (SQL Group By) Sorting by any column (SQL Order By clause)
SQL Operators		=   Equals >   Greater than <   Less than >=   Greater than or equal to <=   Less than or equal to <>   Not equal to Like   Like a value Not Like   Not Like a value Between     In   Contains a list Not In   Does not contain values in list Null   Column is null Not Null   Column is not null
Date Formats		Full DateTime Date = mm/dd/yyyy Supports user defineable date range queries.
Column Types		All - Supports all native SQL Server & Oracle data types.
Object Types		Tables, Views & Synonymns Query-by-Example form SQL statement queries HotLinked (chained) queries with unlimited data drill down. External link queries
Object features		View the structure. Displays Columns, constraints, indexes, primary keys & foreign keys. Full table browsing Auto preview column data with 'distinct' SQL option Owner, comments (Oracle only) & creation date Sort table & view list by Name, Owner, Comments (Oracle only) & creation date.
Email		Email query results Download query results to your local computer
Export Formats		Text - Comma delimited Text - Tab delimited User defined column delimeter

©2009 Array Software Inc.		toll free 877-ArraySoft