JDBC URL format for Oracle

In database configuration file database-config.xml, the JDBC URL for a standalone Oracle instance uses one of the following formats:

<dbcp-connection-pool jdbc-url="jdbc:oracle:thin:userName/password@serverName:port/OracleSID" /> 

or

<dbcp-connection-pool jdbc-url="jdbc:oracle:thin:userName/password@
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverName)(PORT=port))
 (CONNECT_DATA=(SERVICE_NAME=OracleSID)))"/>

The server name can be specified using the computer name or IP address.