Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Specifying Connection URLs

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

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.

TitleResults for “How to create a CRG?”Also Available inAlert