After setting the CLASSPATH, the required connection information needs to be passed in the form of a connection URL. The following example includes the properties required for connecting with user ID/password authentication.

Connection URL Syntax

The connection URL takes the following form: 

jdbc:datadirect:oracleservicecloud:LoginHost=myloginhost;
User=username;Password=password;[property=value[;...]];

where:

myloginhost
specifies the host name of the Oracle Service Cloud site to which you want to connect, for example, mysite.custhelp.com. This value should not include an internet protocol such as http:// or https://.
username
specifies your username.
password

specifies your password.

property=value
specifies connection property settings. Multiple properties are separated by a semi-colon.

Connection URL Examples:

Connection conn = DriverManager.getConnection
 (jdbc:datadirect:oracleservicecloud:LoginHost=mysite.custhelp.com;
  User=test;Password=secret;[property=value[;...]];);