skip to main content
Configuring the JDBC Client : Connecting to a Data Source : Specifying Connection URLs
 

Specifying Connection URLs

After registering the JDBC Client, pass your database connection information in the form of a connection URL.
The connection URL format is:

jdbc:openaccess://hostname:port[;key=value]...
where:
hostname
is the TCP/IP address or TCP/IP host name of the server to which you are connecting.
Note: Untrusted applets cannot open a socket to a machine other than the originating host. Therefore, if any JDBC Client will be used by an untrusted applet, your OpenAccess SDK Server software must be installed on the same machine as your Web server software. This is a Java restriction.
port
is the TCP/IP port on which the OpenAccess SDK Server is listening. A default installation of OpenAccess SDK Server uses the port 19986.
key=value
specifies connection properties. Refer to the OpenAccess SDK Client Reference for a list of connection properties and their valid values.
Connection URL Examples
The following examples show some typical JDBC driver connection URLs:

jdbc:openaccess://OpenAccesshost:19986;
jdbc:openaccess://189.23.5.25:19986;user=john;password=whatever
jdbc:openaccess://189.23.5.132:19986;Database=stores7
jdbc:openaccess://189.23.5.68:19986;Database=pubs;HUser=john;HPassword=whatever
jdbc:openaccess://OpenAccesshost:4006;Database=pubs;DBUser=john;DBPassword=whatever
The preceding examples do not show the user and password connection properties. Typically, these properties are specified in the connection properties stored in the java.util.Properties object, which is supplied as a parameter to the getConnection method.
See Testing JDBC Connections for information on testing a connection.