How do I create a JDBC Type 3 URL to connect to Sybase?

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 OpenLink Request Broker instance.



* 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 OpenLink server component's oplrqb.ini file. The default domain alias is "Sybase". Custom aliases may take any form.



* /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 -H IP address or hostname of database server -P Sybase TCP port -V TDS version which defaults to 5.0. For example: -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=-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=-H 192.75.12.213 -P 4200 -V 5.0/UID=sa/PWD=dba

jdbc:openlink://saturn/SVT=Sybase/DATABASE=pubs2/OPTIONS=-H 192.75.12.213 -P 4100 -V 5.0/UID=sa/PWD=