Product Documentation

c-treeACE V11.0 Update Guide

Previous Topic

Next Topic

c-treeACE SQL JDBC Now Allows Specifying User and Password in Connection URL

In V11 and later, the c-treeACE SQL JDBC driver allows specifying the user and the password in the connection URL using the following syntax:


jdbc:ctree:port@host_name:db_name?user=username&password=passwd

The URL string has the following components:

  • jdbc:ctree - An identifying protocol and subprotocol string for the c-treeACE SQL JDBC driver.
  • :port - The port number associated with the c-treeACE SQL server on the host system.
  • @host_name - Name of the server system where the database resides.
  • :db_name - Name of the database.
  • ?settings - Setting as per the following table separated by "&"

URL settings:

  • characterEncoding=encoding - Encoding is a valid java encoding name.
  • user=username - Where username is a valid database user.
  • password=passwd - Where passwd is the user password.

The user and password specified in the URL take precedence over other ways of specifying them in JDBC.

TOCIndex