My Resume (CV)

(c) by mataya, 1999.

TJAD (swing) & TJADConsole

Tool for JDBC (Java) Application Develpers.

Description:

Sometimes, if e.g. you are using Oracle - SQL Worksheet or SQL Plus are not enough. Then, you can use this simple JAVA tool to connect to database using your JDBC driver and execute your SQL statements.
This tool works on any java platform - I've tested it on Windows and MAC OS X, but it should also work on SUN!
There are many useful features - download and take a look!

How?

TJAD is GUI version - done in Java, using swing, 4.585 lines of code.
First version was done in summer 2000, in few inspired days.. but it was polished every time I needed some additional feature.

TJADConsole NEW!

is light console version with much less features intented mostly for nice output of SELECT SQLs. You can actually execute any SQL that goes through JDBC. It is intented to be used when you have only UNIX or Linux prompt available on some remote machine that has access to database you want to connect. Done in Feb/2003.

Some screenshots of GUI version (swing)

Connection list you can use.

You can execute statements and get textual results.

Or you can switch to using graphical grid with some more options.

How about insert/update/delete wizard? ;)

TJAD has sample JDBC URLs and JDBC driver class names for Oracle, InterBase and Sybase.

Some screenshots of console version (TJADConsole)

Here is TJADConsole started on Linux machine and connected to oracle as scott. You can also see help and sample SQL:

Here is configuration:

Here is history feature:

And here is SQL SELECT with navigation help:

The feature that I was missing most in SQL plus from oracle on UNIX prompt was easy formatting of column widths - here you can choose if you want that column width will fit data in rows or column name or both.

I've planned to make this as terminal application with nice character window and scrolling of resultset, but since I run onto some Java "walls" regarding lousy stdin implementation :(, I was not able to do much more... even simple masking of password requires wacky masking thread - if you will have problems with this, then run application, don't connect to database but go to config and turn off the "Mask password" in configuration.