IsqlApp allows you to issue isql commands from the command line, and run jConnect sample programs.
The syntax for IsqlApp is:
IsqlApp [-U username]
[-P password]
[-S servername]
[-G gateway]
[-p {http|https}]
[-D debug_class_list]
[-v]
[-I input_command_file]
[-c command_terminator]
[-C charset]
[-L language]
[-K service_principal_name]
[-F JAAS_login_config_file_path]
[-T sessionID]
[-V <version {2,3,4,5}>]
Parameter |
Description |
|---|---|
-U |
The login ID with which you want to connect to a server. |
-P |
The password for the specified login ID. |
-S |
The name of the server to which you want to connect. |
-G |
The gateway address. For the HTTP protocol, the URL is: http://host:port. To use the HTTPS protocol that supports encryption, the URL is https://host:port/servlet_alias. |
-p |
Specifies whether you want to use the HTTP protocol or the HTTPS protocol that supports encryption. |
-D |
Turns on debugging for all classes or for just the ones you specify, separated by a comma. For example, -D ALL displays debugging output for all classes. -D SybConnection, Tds displays debugging output only for the SybConnection and Tds classes. |
-v |
Turns on verbose output for display or printing. |
-I |
Causes IsqlApp to take commands from a file instead of the keyboard. After the parameter, you specify the name of the file to use for the IsqlApp input. The file must contain command terminators (“go” by default). |
-c |
Lets you specify a keyword (for example, “go”) that, when entered on a line by itself, terminates the command. This lets you enter multiline commands before using the terminator keyword. If you do not specify a command terminator, each new line terminates a command. |
-C |
Specifies the character set for strings passed through TDS. If you do not specify a character set, IsqlApp uses the default charset of the server. |
-L |
Specifies the language in which to display error messages returned from the server and for jConnect messages. |
-K |
Indicates the user wants to make a Kerberos login to Adaptive Server. This parameter sets the service principal name. For example: -K myASE This example indicates that you wish to perform a Kerberos login and that the service principal name for your server is myASE. See Chapter 3, “Security” for more information. |
-F |
Specifies the path to the JAAS login configuration file. You must set this property if you use the -K option. For example: -F /foo/bar/exampleLogin.conf See the ConnectKerberos.java sample in the sample2 directory of your jConnect installation. For more information, see Chapter 3, “Security”. |
-T |
When this parameter is set, jConnect assumes that an application is trying to resume communication on an existing TDS session held open by the TDS-tunnelling gateway. jConnect skips the login negotiations and forwards all requests from the application to the specified session ID. |
-V |
Enables the use version-specific characteristics. See “Using JCONNECT_ VERSION”. |
You must enter a space after each option flag.
To obtain a full description of the command-line options, enter:
java IsqlApp -help
The following example shows how to connect to a database on a host named “myserver” through port “3756”, and run an isql script named “myscript”:
java IsqlApp -U sa -P sapassword -S jdbc:sybase:Tds:myserver:3756 -I $JDBC_HOME/sp/myscript -c run
An applet that provides GUI access to isql commands
is available as:
$JDBC_HOME/sample2/gateway.html (UNIX)
%JDBC_HOME%\sample2\gateway.html (Windows)
