To connect to a database via jConnect, you need to supply a Universal Resource Locator (URL) for the database.
An example given in the section is as follows:
StringBuffer temp = new StringBuffer();
// Use the SAP Sybase jConnect driver...
temp.append("jdbc:sybase:Tds:");
// to connect to the supplied machine name...
temp.append(_coninfo);
// on the default port number for ASA...
temp.append(":2638");
// and connect.
System.out.println(temp.toString());
conn = DriverManager.getConnection(temp.toString() , _props );
The URL is put together in the following way:
jdbc:sybase:Tds:machine-name:port-number
The individual components are include:
jdbc:sybase:Tds—The SAP Sybase jConnect JDBC driver, using the TDS application protocol.
machine-name—The IP address or name of the machine on which the server is running. If you are establishing a same-machine connection, you can use localhost, which means the current machine.
port number—The port number on which the database server listens. The port number assigned to SAP Sybase IQ is 2638. Use that number unless there are specific reasons not to do so.
The connection string must be less than 253 characters in length.