E Appendix: URL Reference

Both the database schema and application installers for the Point-of-Service product will ask for several different URLs. These include the following:

JDBC URL for a Database

Used by the Java application and installer to connect to the database.

Using the SID

Syntax:

jdbc:oracle:thin:@[host]:[tcpPort]:[SIDname]

• [host]: host name of the database server

• [tcpPort]: database listener port

• [SIDname]: system identifier for the database

Example:

jdbc:oracle:thin:@myhost:1525:mySIDdatabase

Using the Service Name

Syntax:

jdbc:oracle:thin:@//[host]:[tcpPort]/[service_name]

• [host]: host name of the database server

• [tcpPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@//myhost:1525/myserviceDB

Using the Oracle Net Connection

Syntax:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=[host])
(PORT=[tcpPort]))(CONNECT_DATA=(SERVICE_NAME=[service_name])))

• [host]: host name of the database server

• [tcpPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost1)
(PORT=1525))(CONNECT_DATA=(SERVICE_NAME=mydatabase1)))

Secure JDBC URL for a Database

Used by the Java application and installer to connect to the database.

Using the Secure Oracle Net Connection

Syntax:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=[host])
(PORT=[tcpsPort]))(CONNECT_DATA=(SERVICE_NAME=[service_name])))

• [host]: host name of the database server

• [tcpsPort]: database listener port

• [service_name]: system identifier for the database

Example:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=myhost1)
(PORT=7004))(CONNECT_DATA=(SERVICE_NAME=mydatabase1)))

URL for the Siebel Web Service

Used by the Java application to access Siebel if integration with Siebel is enabled.

Syntax:

For most deployments, the URL will conform to one of the following patterns depending on the transport and web service authentication being used.

• Using a transport method of HTTP and Siebel authentication:

  http://<host>[:<port>]/eai_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1
  

• Using a transport method of HTTP and WS-Security authentication:

  http://<host>[:<port>]/eai_anon_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1
  

• Using a transport method of HTTPS and Siebel authentication:

  https://<host>[:<port>]/eai_secure_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1
  

• Using a transport method of HTTPS and WS-Security authentication:

  https://<host>[:<port>]/eai_secure_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1
  

For example, http://sdc78029svqe.corp.siebel.com/eai_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1

JNDI Provider URL for an Application

Used for server-to-server calls between applications.

Syntax:

t3://<host>:<port>

• <host>: host name selected when the WebLogic domain was created

• <port>: port number selected when the WebLogic domain was created

Example:

t3://adminserver:7001

Deployer URI

Used by the Oracle Ant tasks to deploy an application to a WebLogic Server. The application installer does not ask the user for this value. It is constructed based on other inputs and written to the ant.install.properties file for input to the installation script. For repeat installations using silent mode, you may need to correct mistakes in the deployer URI.

Syntax:

input.deployer.uri = t3://<host>:<port>

• <host>: host name selected when the WebLogic domain was created

• <port>: port number selected when the WebLogic domain was created

Example:

input.deployer.uri = t3://localhost:7003