nvSQL

?>

nvSQL

nvSQL dba tools
nvSQL

synopsys

See below the command lines

Description

If you have to administer a database with telnet, it's borring ! You never have the informations you need except if you print them (paper, paper...). For instance, to write a select, you may find useful to have the column lists of the table you are working on.

nvSQL is a desktop tool, managing internal windows, that permit in different windows :

  • to connect to different databases on different hosts
  • to list the columns of tables
  • launch sql
  • see the results in tabular form with sort possibilities of these results.

You can also save to files the sql and/or the results.

Snaphot : accessing 2 databases, 3 queries + results + infos (click to enlarge)

avalaibilty

Actually, nvSQL works only with mysql and informix.

pre_requisites

You need :

  • A jvm 1.4.2 or higher (see java.sun.com)
  • The needed driver(s) (see www.mysql.com and/or www.ibm.com, eventually use the serach engine). I won't have any responsability if you aren't in conformity with the license rules.
  • install the file in nvSQL.zip
  • The needed permissions to access databases
  • For informix: as the informix jdbc driver doesn't know how to manage the DBPATH variable or the path to a database, you need to make symbolic links to the .dbs directories in your HOME directory.
    sqlhost :
    INFORMIXSERVER sesoctcp HOSTNAME SERVICE
    services :
    SERVICE PORT/tcp

installation

The easier is to install the jar file, the scripts to launch, and the drivers such that the "com" directories be at the same level.

On informix server, you need to configure $INFORMIX/etc/sqlhost and /etc/services.

usage

The first step is to get every needed information on the databases that resides on a server. You can do this with :

$java -cp $SGBD_DRIVERS_HOME:$JAR_FILE getPROP --url "$URL" --driver "$DRIVER"

where URL can be :

  • for informix : URL="jdbc:informix-sqli://$HOST:$PORT/$BASE:INFORMIXSERVER=$INFORMIXSERVER;user=$user;password=$password"
    on 1 line where PORT and INFORMIXSERVER are given by the system administrator.
  • for mysql : URL='jdbc:mysql://$HOST/$BASE?user=$USER;password:$PASS'

THESE INFORMATIONS WILL BE STORED IN THE prop FILE. SAVE IT IN A SAFE PLACE WITH NEEDED PERMISSIONS.

and DRIVER :

  • for informix : DRIVER='com.informix.jdbc.IfxDriver'
  • for mysql : DRIVER='com.mysql.jdbc.Driver'

The result will be a file "host.prop" in the current directory that you can modify if you want, for instance, to hide some tables like the 'sys*' tables or some garbage from informix. In such case, don't forget it