HotQuery
What is HotQuery? Screen shots products specifications Read HotQuery customer testamonials contact us Go back to the HotQuery home page
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 5
3. JSTL 1.1
4. Oracle, SQL Server or Sybase 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 2000
3. Sybase Adaptive Server 11 thru 12.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
Microsoft Excel
Microsoft Word
User defined column delimeter
 
©2006 Array Software Inc.   toll free 877-ArraySoft