JaySQL

JaySQL 

 

A Universal Database Tool for JDBC

 

JaySQL is a "must have" utility for DBAs and programmers who deal with databases. It empowers them to be more productive by providing an intuitive tool that can talk to any database through ODBC.
 

Main Features:

• 100% Java Compatible
• Support for multiple operating systems including Windows, Linux, Solaris, MAC and more...
• Same look and feel as WinSQL

 

How it works?

It's simple. JaySQL can talk to any database for which you have a JDBC driver. Most of the databases today come with a JDBC driver and usually, it is free.

There are four types of JDBC driver:

• Type 1 - JDBC-ODBC Bridge
• Type 2 - A native API party Java enabled
• Type 3 - Pure Java for database middleware
• Type 4 - Wire protocol pure Java

 

JaySQL talks to the JDBC driver through an enhanced built-in Driver Manager. The Driver converts generic JDBC calls into database-specific requests and sends it to the back-end server. The server computes the results and sends them back to JaySQL through the driver.

 

Version Feature Matrix

 

Features	Lite	Pro
100% pure Java - Platform independent	V	V
Syntax highlighting for SQL script	V	V
Connect to multiple data sources	V	V
Database catalog Shows tables, views, stored procedures	V	V
Run selective query Highlight part of the script and send just that to the server	V	V
Result in grid or text box	V	V
Support for database transactions	V	V
Customized editor	V	V
Data browsing	V	V
Local comment parsing	V	V
Submit batches Queries can be separated by a separator and therefore, multiple queries can be submitted at the same time.	V	V
Multi-threaded architecture	V	V
Database specific plugins		V
Database Diff		V
DB Architect - Complete product of DB Architect included		V
Result Printing - Print query results as report		V
List of available data types		V

 

Differences between WinSQL for ODBC and JDBC

WinSQL and JaySQL are two separate products with similar names. WinSQL was introduced in 1997 and is used by over 250,000 users worldwide. JaySQL on the other hand, is a new addition (introduced in 2003) to our product family and is targeted towards developers using operating system other than MS Windows.

 

Here is a list of some differences

• The most important difference in these products is that JaySQL can run on other platforms besides Windows, including Linux, Sun Solaris and Apple Mac. JaySQL is a 100% pure Java solution that can run on any Java compatible platforms.
• If you use the type-4 JDBC driver, WinSQL can talk directly to the database eliminating any bulky client side API. Usually these JDBC drivers are shipped as a few JAR files and therefore, it is very easy to setup.
• It is very easy to change the look and feel for JaySQL. Specify a -DCustomLookAndFeel= as a command line parameter and modify how WinSQL screens appear.

 

Which product should I use?

• If you plan to use WinSQL on any Microsoft platform (Win9x, NT, Win2000, XP or 2003), we recommend that you use WinSQL - it has more features than JaySQL.
• If you want a querying tool for Linux, Solaris, Mac, or any other platform use JaySQL.
• If you are a programmer working on any Java related project and want to use a JDBC driver instead of ODBC, use JaySQL.