- introduction
- picture
- Boutique
- Related
Developer's DescriptionBy Nick HristovRun queries and SQL commands.InstallationCopy 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 DriversCopy 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.WindowsUsage: isqlc.cmd [[user password] [-i file]]Unix basedUsage: ./isqlc.sh [[user password] [-i file]]user - database user namepassword - user's passwordfile - file containing SQL queriesWhen -i is used, no banner is displayed and the application exits after the batch is complete.ConfigurationJAVA_HOME - location where JRE is installedDRIVER_CLASSPATH - location of database driver(s)CONFIG_LOCATION - location of config.properties fileConfig.properties filemax_text - display size of character fieldscomment - line comments markerbatch_separator - delimiter between commandsdriver - database driver classconnString - java connect stringExample:max_text=60comment=--batch_separator=;driver=com.microsoft.sqlserver.jdbc.SQLServerDriverconnString=jdbc:sqlserver://123.456.789.007:1433;DatabaseName=somedatabaseBlock comments marker is the standard /* */.Database Drivers DownloadMSSQL Server: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774ORACLE: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.htmlSybase: http://www.sybase.com.au/products/allproductsa-z/softwaredeveloperkit/jconnectMySQL: http://dev.mysql.com/downloads/connector/j/