| Version | 1.0 |
|---|---|
| Publisher | Nick Hristov |
| Release date | Jul 12, 2013 |
| Date added | Jul 12, 2013 |
| Os requirements | Windows 2003, Windows Vista, Windows 98, Windows Me, Windows, Windows NT, Windows 2000, Windows 8, Windows Server 2008, Windows 7, Windows XP |
| Requirements | Java 1.6 |
| Total downloads | 3 300 |
| Downloads per week | 4 |
| Price | Free |
Description
Installation
Copy and unzip in a folder.
For Unix based OS run mkfile(./mkfile). It will create isqlc.sh, which is the start up file for the application.
Installing Database Drivers
Copy jar file(s) into root folder or modify DRIVER_CLASSPATH to point to jar's location and start application.
For legal reasons, Database Drivers are not supplied with the application. They can be downloaded from the links below.
Windows
Usage: isqlc.cmd [[user password] [-i file]]
Unix based
Usage: ./isqlc.sh [[user password] [-i file]]
user - database user name
password - user's password
file - file containing SQL queries
When -i is used, no banner is displayed and the application exits after the batch is complete.
Configuration
JAVA_HOME - location where JRE is installed
DRIVER_CLASSPATH - location of database driver(s)
CONFIG_LOCATION - location of config.properties file
Config.properties file
max_text - display size of character fields
comment - line comments marker
batch_separator - delimiter between commands
driver - database driver class
connString - java connect string
Example:
max_text=60
comment=--
batch_separator=;
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
connString=jdbc:sqlserver://123.456.789.007:1433;DatabaseName=somedatabase
Block comments marker is the standard /* */.
Database Drivers Download
MSSQL Server: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
ORACLE: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
Sybase: http://www.sybase.com.au/products/allproductsa-z/softwaredeveloperkit/jconnect
MySQL: http://dev.mysql.com/downloads/connector/j/
