skip to main content
Using the JDBC Client : Specifying Driver Connection URLs
 

Specifying Driver Connection URLs

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 OpenAccess SDK 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. See Specifying Connection Properties for a list of connection properties and their valid values.

JDBC 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.