DatabaseConstants (JChem Base API documentation (c) 1998-2021 ChemAxon Ltd.)

java.lang.Object
- chemaxon.jchem.db.DatabaseConstants

```
@PublicAPI
public class DatabaseConstants
extends java.lang.Object
```
Database constants are defined here.

Since:

JChem 5.2

Author:

JChem Base team, Roland Molnar, Nora Mate

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`ACCESS`
`static java.lang.String`	`ACCESS_DRIVER` JDBC driver for MS Access database
`static java.lang.String`	`ACCESS_TYPE_NAME`
`static java.lang.String`	`ACCESS_URL_EXAMPLE` JDBC URL example for Access database
`static java.lang.String`	`ACCESS_URL_TEMPLATE` JDBC URL template for Access database
`static int`	`COMPOSITE`
`static java.lang.String`	`COMPOSITE_DRIVER` JDBC driver for Composite database
`static java.lang.String`	`COMPOSITE_TYPE_NAME`
`static java.lang.String`	`COMPOSITE_URL_EXAMPLE` JDBC URL example for Composite database
`static java.lang.String`	`COMPOSITE_URL_TEMPLATE` JDBC URL template for Composite database
`static int`	`DB2`
`static java.lang.String`	`DB2_DRIVER` JDBC driver for DB2 database
`static java.lang.String`	`DB2_TYPE_NAME`
`static java.lang.String`	`DB2_URL_EXAMPLE` JDBC URL example for DB2 database
`static java.lang.String`	`DB2_URL_TEMPLATE` JDBC URL template for DB2 database
`static java.lang.String[]`	`DBMS_DRIVERS` Database drivers.
`static java.lang.String[]`	`DBMS_NAMES` Readable names for database types.
`static java.lang.String[]`	`DBMS_TYPE_NAMES`
`static java.lang.String[]`	`DBMS_URL_EXAMPLES` Database URL examples.
`static java.lang.String[]`	`DBMS_URL_TEMPLATES` Database URL templates.
`static int`	`DEFAULT_BATCH_SIZE`
`static int`	`DEFAULT_COMMIT_INTERVAL`
`static int`	`DERBY`
`static java.lang.String`	`DERBY_DRIVER` JDBC driver for Derby database
`static java.lang.String`	`DERBY_TYPE_NAME`
`static java.lang.String`	`DERBY_URL_EXAMPLE` JDBC URL example for Derby database
`static java.lang.String`	`DERBY_URL_TEMPLATE` JDBC URL template for Derby database
`static int`	`HSQLDB`
`static java.lang.String`	`HSQLDB_DRIVER` JDBC driver for HSQLDB and HXSQL database
`static java.lang.String`	`HSQLDB_TYPE_NAME`
`static java.lang.String`	`HSQLDB_URL_EXAMPLE` JDBC URL example for HSQL database
`static java.lang.String`	`HSQLDB_URL_TEMPLATE` HSQL URL template for Derby database
`static int`	`INTERBASE`
`static java.lang.String`	`INTERBASE_DRIVER` JDB driver for INTERBASE database
`static java.lang.String`	`INTERBASE_TYPE_NAME`
`static java.lang.String`	`INTERBASE_URL_EXAMPLE` JDBC URL example for Interbase database
`static java.lang.String`	`INTERBASE_URL_TEMPLATE` JDBC URL template for Interbase database
`static int`	`MSSQL`
`static java.lang.String`	`MSSQL_DRIVER` Deprecated. as of JChem 5.9, only the new MSSQL database is supported
`static java.lang.String`	`MSSQL_URL_EXAMPLE` Deprecated. as of JChem 5.9, only the new MSSQL database is supported
`static java.lang.String`	`MSSQL_URL_TEMPLATE` Deprecated. as of JChem 5.9, only the new MSSQL database is supported
`static int`	`MSSQL2005`
`static java.lang.String`	`MSSQL2005_DRIVER` JDBC driver for MSSQL database for version 2005 and above
`static java.lang.String`	`MSSQL2005_TYPE_NAME`
`static java.lang.String`	`MSSQL2005_URL_EXAMPLE` JDBC URL example for MS SQL 2005 database
`static java.lang.String`	`MSSQL2005_URL_TEMPLATE` JDBC URL template for MS SQL 2005 database
`static int`	`MYSQL`
`static java.lang.String`	`MYSQL_DRIVER` JDBC driver for MySql database
`static java.lang.String`	`MYSQL_TYPE_NAME`
`static java.lang.String`	`MYSQL_URL_EXAMPLE` JDBC URL example for MySQL database
`static java.lang.String`	`MYSQL_URL_TEMPLATE` JDBC URL template for MySQL database
`static int`	`ORACLE`
`static java.lang.String`	`ORACLE_DRIVER` JDBC driver for Oracle database
`static java.lang.String`	`ORACLE_TYPE_NAME`
`static java.lang.String`	`ORACLE_URL_EXAMPLE` JDBC URL example for Oracle database
`static java.lang.String`	`ORACLE_URL_TEMPLATE` JDBC URL template for Oracle database
`static java.lang.String`	`POSGRESQL_DRIVER` JDBC driver for PosgreSQL database
`static java.lang.String`	`POSGRESQL_URL_EXAMPLE` JDBC URL example for PosgreSQL database
`static java.lang.String`	`POSGRESQL_URL_TEMPLATE` JDBC URL template for PosgreSQL database
`static int`	`POSTGRESQL`
`static java.lang.String`	`POSTGRESQL_TYPE_NAME`
`static int`	`UNKNOWN`
`static java.lang.String`	`UNKNWON_TYPE_NAME`

Constructor Summary

Constructors
Constructor and Description

DatabaseConstants()

Constructors
Constructor and Description
`DatabaseConstants()`

Method Summary
- Methods inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - DEFAULT_COMMIT_INTERVAL
```
public static final int DEFAULT_COMMIT_INTERVAL
```
    See Also:
    
    Constant Field Values
  - DEFAULT_BATCH_SIZE
```
public static final int DEFAULT_BATCH_SIZE
```
    See Also:
    
    Constant Field Values
  - UNKNOWN
```
public static final int UNKNOWN
```
    See Also:
    
    Constant Field Values
  - UNKNWON_TYPE_NAME
```
public static final java.lang.String UNKNWON_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - ORACLE
```
public static final int ORACLE
```
    See Also:
    
    Constant Field Values
  - ORACLE_TYPE_NAME
```
public static final java.lang.String ORACLE_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - MSSQL
```
public static final int MSSQL
```
    See Also:
    
    Constant Field Values
  - MSSQL2005
```
public static final int MSSQL2005
```
    See Also:
    
    Constant Field Values
  - MSSQL2005_TYPE_NAME
```
public static final java.lang.String MSSQL2005_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - MYSQL
```
public static final int MYSQL
```
    See Also:
    
    Constant Field Values
  - MYSQL_TYPE_NAME
```
public static final java.lang.String MYSQL_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - ACCESS
```
public static final int ACCESS
```
    See Also:
    
    Constant Field Values
  - ACCESS_TYPE_NAME
```
public static final java.lang.String ACCESS_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - INTERBASE
```
public static final int INTERBASE
```
    See Also:
    
    Constant Field Values
  - INTERBASE_TYPE_NAME
```
public static final java.lang.String INTERBASE_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - DB2
```
public static final int DB2
```
    See Also:
    
    Constant Field Values
  - DB2_TYPE_NAME
```
public static final java.lang.String DB2_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - POSTGRESQL
```
public static final int POSTGRESQL
```
    See Also:
    
    Constant Field Values
  - POSTGRESQL_TYPE_NAME
```
public static final java.lang.String POSTGRESQL_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - HSQLDB
```
public static final int HSQLDB
```
    See Also:
    
    Constant Field Values
  - HSQLDB_TYPE_NAME
```
public static final java.lang.String HSQLDB_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - DERBY
```
public static final int DERBY
```
    See Also:
    
    Constant Field Values
  - DERBY_TYPE_NAME
```
public static final java.lang.String DERBY_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - COMPOSITE
```
public static final int COMPOSITE
```
    See Also:
    
    Constant Field Values
  - COMPOSITE_TYPE_NAME
```
public static final java.lang.String COMPOSITE_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - DBMS_TYPE_NAMES
```
public static final java.lang.String[] DBMS_TYPE_NAMES
```
  - MYSQL_DRIVER
```
public static final java.lang.String MYSQL_DRIVER
```
    JDBC driver for MySql database
    
    See Also:
    
    Constant Field Values
  - DERBY_DRIVER
```
public static final java.lang.String DERBY_DRIVER
```
    JDBC driver for Derby database
    
    See Also:
    
    Constant Field Values
  - MSSQL_DRIVER
```
@Deprecated
public static final java.lang.String MSSQL_DRIVER
```
    Deprecated. as of JChem 5.9, only the new MSSQL database is supported
    
    JDBC driver for MSSQL database before version 2005
    
    See Also:
    
    MSSQL2005_DRIVER, Constant Field Values
  - MSSQL2005_DRIVER
```
public static final java.lang.String MSSQL2005_DRIVER
```
    JDBC driver for MSSQL database for version 2005 and above
    
    See Also:
    
    Constant Field Values
  - ACCESS_DRIVER
```
public static final java.lang.String ACCESS_DRIVER
```
    JDBC driver for MS Access database
    
    See Also:
    
    Constant Field Values
  - INTERBASE_DRIVER
```
public static final java.lang.String INTERBASE_DRIVER
```
    JDB driver for INTERBASE database
    
    See Also:
    
    Constant Field Values
  - DB2_DRIVER
```
public static final java.lang.String DB2_DRIVER
```
    JDBC driver for DB2 database
    
    See Also:
    
    Constant Field Values
  - HSQLDB_DRIVER
```
public static final java.lang.String HSQLDB_DRIVER
```
    JDBC driver for HSQLDB and HXSQL database
    
    See Also:
    
    Constant Field Values
  - ORACLE_DRIVER
```
public static final java.lang.String ORACLE_DRIVER
```
    JDBC driver for Oracle database
    
    See Also:
    
    Constant Field Values
  - POSGRESQL_DRIVER
```
public static final java.lang.String POSGRESQL_DRIVER
```
    JDBC driver for PosgreSQL database
    
    See Also:
    
    Constant Field Values
  - COMPOSITE_DRIVER
```
public static final java.lang.String COMPOSITE_DRIVER
```
    JDBC driver for Composite database
    
    See Also:
    
    Constant Field Values
  - ORACLE_URL_TEMPLATE
```
public static final java.lang.String ORACLE_URL_TEMPLATE
```
    JDBC URL template for Oracle database
    
    See Also:
    
    Constant Field Values
  - MSSQL_URL_TEMPLATE
```
@Deprecated
public static final java.lang.String MSSQL_URL_TEMPLATE
```
    Deprecated. as of JChem 5.9, only the new MSSQL database is supported
    
    JDBC URL template for MS SQL database
    
    See Also:
    
    MSSQL2005_DRIVER, Constant Field Values
  - MSSQL2005_URL_TEMPLATE
```
public static final java.lang.String MSSQL2005_URL_TEMPLATE
```
    JDBC URL template for MS SQL 2005 database
    
    See Also:
    
    Constant Field Values
  - MYSQL_URL_TEMPLATE
```
public static final java.lang.String MYSQL_URL_TEMPLATE
```
    JDBC URL template for MySQL database
    
    See Also:
    
    Constant Field Values
  - ACCESS_URL_TEMPLATE
```
public static final java.lang.String ACCESS_URL_TEMPLATE
```
    JDBC URL template for Access database
    
    See Also:
    
    Constant Field Values
  - INTERBASE_URL_TEMPLATE
```
public static final java.lang.String INTERBASE_URL_TEMPLATE
```
    JDBC URL template for Interbase database
    
    See Also:
    
    Constant Field Values
  - DB2_URL_TEMPLATE
```
public static final java.lang.String DB2_URL_TEMPLATE
```
    JDBC URL template for DB2 database
    
    See Also:
    
    Constant Field Values
  - POSGRESQL_URL_TEMPLATE
```
public static final java.lang.String POSGRESQL_URL_TEMPLATE
```
    JDBC URL template for PosgreSQL database
    
    See Also:
    
    Constant Field Values
  - HSQLDB_URL_TEMPLATE
```
public static final java.lang.String HSQLDB_URL_TEMPLATE
```
    HSQL URL template for Derby database
    
    See Also:
    
    Constant Field Values
  - DERBY_URL_TEMPLATE
```
public static final java.lang.String DERBY_URL_TEMPLATE
```
    JDBC URL template for Derby database
    
    See Also:
    
    Constant Field Values
  - COMPOSITE_URL_TEMPLATE
```
public static final java.lang.String COMPOSITE_URL_TEMPLATE
```
    JDBC URL template for Composite database
    
    See Also:
    
    Constant Field Values
  - ORACLE_URL_EXAMPLE
```
public static final java.lang.String ORACLE_URL_EXAMPLE
```
    JDBC URL example for Oracle database
    
    See Also:
    
    Constant Field Values
  - MSSQL_URL_EXAMPLE
```
@Deprecated
public static final java.lang.String MSSQL_URL_EXAMPLE
```
    Deprecated. as of JChem 5.9, only the new MSSQL database is supported
    
    JDBC URL example for MS SQL database
    
    See Also:
    
    MSSQL2005_URL_EXAMPLE, Constant Field Values
  - MSSQL2005_URL_EXAMPLE
```
public static final java.lang.String MSSQL2005_URL_EXAMPLE
```
    JDBC URL example for MS SQL 2005 database
    
    See Also:
    
    Constant Field Values
  - MYSQL_URL_EXAMPLE
```
public static final java.lang.String MYSQL_URL_EXAMPLE
```
    JDBC URL example for MySQL database
    
    See Also:
    
    Constant Field Values
  - ACCESS_URL_EXAMPLE
```
public static final java.lang.String ACCESS_URL_EXAMPLE
```
    JDBC URL example for Access database
    
    See Also:
    
    Constant Field Values
  - INTERBASE_URL_EXAMPLE
```
public static final java.lang.String INTERBASE_URL_EXAMPLE
```
    JDBC URL example for Interbase database
    
    See Also:
    
    Constant Field Values
  - DB2_URL_EXAMPLE
```
public static final java.lang.String DB2_URL_EXAMPLE
```
    JDBC URL example for DB2 database
    
    See Also:
    
    Constant Field Values
  - POSGRESQL_URL_EXAMPLE
```
public static final java.lang.String POSGRESQL_URL_EXAMPLE
```
    JDBC URL example for PosgreSQL database
    
    See Also:
    
    Constant Field Values
  - HSQLDB_URL_EXAMPLE
```
public static final java.lang.String HSQLDB_URL_EXAMPLE
```
    JDBC URL example for HSQL database
    
    See Also:
    
    Constant Field Values
  - DERBY_URL_EXAMPLE
```
public static final java.lang.String DERBY_URL_EXAMPLE
```
    JDBC URL example for Derby database
    
    See Also:
    
    Constant Field Values
  - COMPOSITE_URL_EXAMPLE
```
public static final java.lang.String COMPOSITE_URL_EXAMPLE
```
    JDBC URL example for Composite database
    
    See Also:
    
    Constant Field Values
  - DBMS_NAMES
```
public static final java.lang.String[] DBMS_NAMES
```
    Readable names for database types. The indexes correspond to the values of the database constants.
    
    See Also:
    
    ORACLE, MSSQL2005, MYSQL, ACCESS, INTERBASE, DB2, POSTGRESQL, DERBY, COMPOSITE
  - DBMS_DRIVERS
```
public static final java.lang.String[] DBMS_DRIVERS
```
    Database drivers.
    
    Since:
    
    JChem 5.9
  - DBMS_URL_TEMPLATES
```
public static final java.lang.String[] DBMS_URL_TEMPLATES
```
    Database URL templates.
    
    Since:
    
    JChem 5.9
  - DBMS_URL_EXAMPLES
```
public static final java.lang.String[] DBMS_URL_EXAMPLES
```
    Database URL examples.
    
    Since:
    
    JChem 5.9
- Constructor Detail
  - DatabaseConstants
```
public DatabaseConstants()
```

Class DatabaseConstants

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

DEFAULT_COMMIT_INTERVAL

DEFAULT_BATCH_SIZE

UNKNOWN

UNKNWON_TYPE_NAME

ORACLE

ORACLE_TYPE_NAME

MSSQL

MSSQL2005

MSSQL2005_TYPE_NAME

MYSQL

MYSQL_TYPE_NAME

ACCESS

ACCESS_TYPE_NAME

INTERBASE

INTERBASE_TYPE_NAME

DB2

DB2_TYPE_NAME

POSTGRESQL

POSTGRESQL_TYPE_NAME

HSQLDB

HSQLDB_TYPE_NAME

DERBY

DERBY_TYPE_NAME

COMPOSITE

COMPOSITE_TYPE_NAME

DBMS_TYPE_NAMES

MYSQL_DRIVER

DERBY_DRIVER

MSSQL_DRIVER

MSSQL2005_DRIVER

ACCESS_DRIVER

INTERBASE_DRIVER

DB2_DRIVER

HSQLDB_DRIVER

ORACLE_DRIVER

POSGRESQL_DRIVER

COMPOSITE_DRIVER

ORACLE_URL_TEMPLATE

MSSQL_URL_TEMPLATE

MSSQL2005_URL_TEMPLATE

MYSQL_URL_TEMPLATE

ACCESS_URL_TEMPLATE

INTERBASE_URL_TEMPLATE

DB2_URL_TEMPLATE

POSGRESQL_URL_TEMPLATE

HSQLDB_URL_TEMPLATE

DERBY_URL_TEMPLATE

COMPOSITE_URL_TEMPLATE

ORACLE_URL_EXAMPLE

MSSQL_URL_EXAMPLE

MSSQL2005_URL_EXAMPLE

MYSQL_URL_EXAMPLE

ACCESS_URL_EXAMPLE

INTERBASE_URL_EXAMPLE

DB2_URL_EXAMPLE

POSGRESQL_URL_EXAMPLE

HSQLDB_URL_EXAMPLE

DERBY_URL_EXAMPLE

COMPOSITE_URL_EXAMPLE

DBMS_NAMES

DBMS_DRIVERS

DBMS_URL_TEMPLATES

DBMS_URL_EXAMPLES

Constructor Detail

DatabaseConstants