Connection URL

Definition

In the connection URL, url you define the properties of the connection to the database instance. You can find more detailed information in the documentation on the Java platform, see sun.java.com.

Syntax

jdbc:sapdb://<database_computer>[:<port>]/<database_name>[?<option1>[&<option2>]...]

<database_computer>

Name of the database computer

<port>

Port of the X Server on the database computer.

If you have not changed the default value for the port of the X Server, then you do not have to specify the port in the connection URL.

See X Server, Ports and Protocols of the X Server

<database_name>

Database name

<option1>,<option2>,...

Properties of the connection

See

?     Method java.sql.DriverManager.getConnection

?     Class com.sap.dbtech.jdbcext.DataSourceSapDB

Example

jdbc:sapdb://PARMA:9876/DEMODB?sqlmode=ORACLE&timeout=120

Using this connection URL, you set up a connection to the DEMODB database instance on the remote computer PARMA. The X Server on the PARMA computer uses port 9876. As connection options, you have selected the SQL mode ORACLE and a timeout for the database session of 120 seconds.

See also:

Examples: Connecting to the Database Instance