Xenonsoft, South London, England is very pleased to announce the
availability of:
Xenon-SQL, the Java based interactive SQL Editor, version 2.3.5.
**** The Personal End User Edition. ****
This software allows you use connect to relational database like MySql,
Sybase, and Oracle and submit SQL queries and commands to the target
databases. In order for `Xenon-SQL' to connect to a database you __MUST__
have a suitable JDBC (Java Database Connectivity) driver specifically for
your database. Most commercial database suppliers have a supplied (or
contributed) JDBC driver around somewhere, so surf the Internet to find it!
The Xenon-SQL software can be obtain from the FTP server:
`ftp://ftp.demon.net/pub/java'
or as a last resort `http://www.xenonsoft.demon.co.uk/software.html'.
The software requires the Java Development Kit minimum version 1.1.5 and
Swing also known as the Java Foundation Classes miminum version
1.1-Beta3. These are available from JavaSoft's web site:
`http://java.sun.com/products/'
The software was developed on a Linuxed/PC with Blackdown's 1.1.7-v1a port
of the JDK `http://www.blackdown.org/java-linux.html'
SunSoft[tm] maintains a list of JDBC drivers from a number of third party
vendors on it web pages See the following URL for a list of JDBC drivers
provided:
`http://java.sun.com:80/products/jdbc/jdbc.drivers.html'
Please read the license file `LICENSE*'.
For installation instructions read the `INSTALLER' file.
It may also be worth reading the `PROBLEMS' file if you have trouble.
NEW FEATURES
=============
o Xenon-SQL now has a Java based installer program called `FreeInstaller'.
The `FreeInstaller' is "available as free software", written and
produced by, yours truly, Peter Pilgrim.
o Xenon-SQL uses a private application directory to store important files.
On Windows NT this is `<HOME_DIRECTORY>\_Xsql' and on UNIX this is
`<HOME_DIRECTORY>/.Xsql'.
o Xenon-SQL is now multi-threaded. Each editor frame can now execute
separate SQL commands as a background task. The application is no longer
blocked on the AWT event queue. No more hours glasses or watches. A
background command thread is started with the [Execute] button. The
thread can be halted by the new [Stop] image button. I did a test to
prove the concept worked by forcing the thread to sleep 10.0 seconds
whilst using two editor frames.
o Since Xenon-SQL is now multithreaded. Two new components have been
created and introduced, namely the `JFlashProgressPanelBar' and
`JStatusBar'. The flash progress bar animates when SQL command is
executed as a background task. The status bar is container for the new
flash progress bar and a message label, where `Xenon-SQL' writes generic
messages.
o Xenon-SQL now uses the `JFileChooser' component, because the API is more
stable. SQL command history can be save in `native' format and portable
`ascii' text format. The native format is a java object serialisation,
and the text format allows you to edit and change the entire SQL command
history in an external editor, such as GNU Emacs. Save your some changes
and reload the history back into Xenon SQL.
o Meta Data Query Tree Dialog displays extra tree nodes in additioning to
representing all catalogues in the database. The new tree nodes are
primary keys, imported key, exported keys, database types, and index
information. There new node have some nice icons to go with them.
o `Strategies' to calculate the best column width in a table, and therefore
display a visually pleasantly table.
o `Pluggable Look And Feel' overdue support for standard Swing/JFC
feature. Yes. `Xenon-SQL' can now switch between "look and feels".
o `SliderDials' to control the row height and the intercell spacing in the
tables. These slider dials behave look and behave similar to the leading
edge dials as seen in the Silicon Graphics[tm] `Inventor' 3D Graphics
application.
o A user request to load up multiple JDBC drivers at start-up time has been
added. The property in the `~/.Xsql/xsql_login' file has been changed to
allow this. The property is now called `Xsql.jdbc.driverList'.
o More internationalisation has added to fully support the above new
features.
TESTS
=====
The software has been tested:
+ against MySQL[tm] compiled on Linux with the
`twz1.jdbc.mysql.jdbcMysqlDriver' JDBC driver.
+ against Sybase[tm] SQL Server/11.03 with the
`connect.syabse.SybaseDriver 3.0' JDBC driver.
MISCELLANY
===========
We are using MySQL 3.21.33 from <http://www.tcx.se/> (UK mirror
<http://www.omnipotent.net/> ) for Linux. `Xenon-SQL' requires a Java
Database Connectivity JDBC driver class to connect to your database. We are
using Terence W. Zeller's `twz1.jdbc.mysql.jdbcMysqlDriver' available from
`ftp://mysql.omnipotent.net/Contrib/'
WE ARE VERY INTERESTED TO KNOW if you get the software working successfully
on a new database not list aboved. Also feel free to contact us if you have
questions or maybe want send to comments or a request for features. So
please please send those emails.
FINITO
=======
Contact the author at `[EMAIL PROTECTED]'.
It is __widely__ known that the author occasionally lurks around
Blackdown's Java Linux (`http:www.blackdown.org/java-linux.html>') mailing
list (`[EMAIL PROTECTED] ').
Enjoy baby bop.
Peter A. Pilgrim
;;; Emacs File Variables
;;; ------------------------------------------------------------
;;; Local Variables: ***
;;; mode:Indented-Text ***
;;; fill-column:75 ***
;;; End: ***
--
Del Segno Al Coda
Pete
Powered By
__
/ /= __ ___ __ __ __ __ __
/ /= / // |/ // // / // /
/ /__ / // /| / // _/ / > <==
/____/__//_/=|__//____/__/__/= Slackware 3.5
==== == == === ==== == ==
"... ,because Unix is the best!"
Peter Pilgrim <mailto:[EMAIL PROTECTED]>
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
