Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ JDBC Driver GuideThe HCL OneDB™ JDBC Driver Programmer's Guide describes how to install, load, and use HCL OneDB™ JDBC Driver to connect to the HCL OneDB™ database from within a Java™ application.
Globalization and date formats
User-defined localesHCL OneDB™ JDBC Driver uses the Java™ globalization API to manipulate international data.
Connect with the NEWNLSMAP property

Connect with the NEWNLSMAP property

To support connecting to NLS databases, HCL OneDB™ JDBC Driver maintains a table for mapping NLS locale to the corresponding Java™ development kit locale and code set. Locales and code sets that are not supported in a particular version of the development kit might be supported in later versions of the development kit. Use the NEWNLSMAP connection property to specify mappings for an NLS locale that is not specified in the table.

The NEWNLSMAP property has the following format:

NEWNLSMAP=NLS-locale,JDK-locale,JDK-codeset:NLS-locale,JDK-locale,
JDK-codeset,....

Here is an example URL using these properties:

jdbc:onedb://myhost:9088/mydatabase;user=myname;password=mypasswd;NEWNLSMAP=rumanian,ro_RO,ISO8859_2;

There is no limit to the number of mappings you can specify. If you specify an incorrect number of parameters or values, you get a Locale Not Supported or Encoding or Code Set Not Supported message.