How do I create a JDBC Type 3 URL to connect to Sybase ASA?
Sybase Type 3 JDBC connection URLs take the following form:
jdbc:openlink://<Hostname>:[portnumber] [/UID] [/PWD] [/READONLY] [/SVT] [/APPLICATION] [/FBS|FETCHBUFFERSIZE] [/ENCRYPTED] [/CHARSET] [/UNICODE] [/DLF] [/DATABASE] [/OPTIONS] [/DRIVER]
Here is a description of each of the parameters:
* Hostname - Network Alias or IP address of machine that runs an
* Port Number - TCP port on which the Request Broker listens.
* /UID - Sybase database username.
* /PWD - Sybase database password.
* /READONLY - Read-write or read-only session mode.
* /SVT - A valid domain alias from the [Domain Aliases] section of the
* /APPLICATION - The Application name. Enables connectivity when restrictive server side rules screen by application name.
* /FBS - (also FETCHBUFFERSIZE) The Fetch Buffer Size. The Fetch Buffer Size is an integer that represents the number of rows to return during one fetch operation..
* /ENCRYPTED - Sets the Encrypted flag for outgoing packets. /ENCRYPTED may pass '1', '0', 'Y', 'N', 'y', or 'n.' (This feature is disabled by default.)
* /CHARSET - Specifies the charset of remote databases. The default value is read from System.getProperty("file.encoding").
* /UNICODE - Instantiates unicode. The unicode connection isn't used by default. The value may be '1', '0', 'Y', 'N', 'y', 'n'(This feature is disabled by default.)
* /DLF - Pushes large, binary objects to the end of the resultset. Smaller data types are retrieved first. This enhances performance. /DLF may be set to '1', '0', 'Y', 'N', 'y', or 'n.' (This feature is disabled by default.)
* /DATABASE - Actual Sybase database name within a particular database environment.
* /OPTIONS - Passes -S Sybase instance name -H IP address or hostname of database server -P Sybase TCP port -V TDS version which defaults to 5.0. For example: -S SYBASE -H 192.75.12.213 -P 1433 -V 8.0
* /DRIVER - The Driver name contained in curly brackets ({}). Used for DSN-Less connections to remote ODBC Drivers.
Here are some sample Sybase Type 3 connection URLs:
jdbc:openlink://localhost:5000/SVT=Sybase/DATABASE=pubs/OPTIONS=-S SYBASE -H 192.75.12.213 -P 4100 -V 5.0/UID=sa/PWD=sa jdbc:openlink://192.75.12.213:5000/SVT=Sybase/DATABASE=pubs2/OPTIONS=-S SYBASE -H 192.75.12.213 -P 4200 -V 5.0/UID=sa/PWD=dba jdbc:openlink://saturn/SVT=Sybase/DATABASE=master/OPTIONS=-S SYBASE -H 192.75.12.213 -P 4100 -V 5.0/UID=sa/PWD= )))