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

@PublicAPI
public class DatabaseConstants
extends Object

Database constants are defined here.

Since:: JChem 5.2

Field Summary

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

Constructor Summary

Constructors
Constructor 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 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 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 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 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 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 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 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 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 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 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 String COMPOSITE_TYPE_NAME
```
    See Also:
    
    Constant Field Values
  - DBMS_TYPE_NAMES
```
public static final String[] DBMS_TYPE_NAMES
```
  - MYSQL_DRIVER
```
public static final String MYSQL_DRIVER
```
    JDBC driver for MySql database
    
    See Also:
    
    Constant Field Values
  - DERBY_DRIVER
```
public static final String DERBY_DRIVER
```
    JDBC driver for Derby database
    
    See Also:
    
    Constant Field Values
  - MSSQL_DRIVER
```
@Deprecated
public static final 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 String MSSQL2005_DRIVER
```
    JDBC driver for MSSQL database for version 2005 and above
    
    See Also:
    
    Constant Field Values
  - ACCESS_DRIVER
```
public static final String ACCESS_DRIVER
```
    JDBC driver for MS Access database
    
    See Also:
    
    Constant Field Values
  - INTERBASE_DRIVER
```
public static final String INTERBASE_DRIVER
```
    JDB driver for INTERBASE database
    
    See Also:
    
    Constant Field Values
  - DB2_DRIVER
```
public static final String DB2_DRIVER
```
    JDBC driver for DB2 database
    
    See Also:
    
    Constant Field Values
  - HSQLDB_DRIVER
```
public static final String HSQLDB_DRIVER
```
    JDBC driver for HSQLDB and HXSQL database
    
    See Also:
    
    Constant Field Values
  - ORACLE_DRIVER
```
public static final String ORACLE_DRIVER
```
    JDBC driver for Oracle database
    
    See Also:
    
    Constant Field Values
  - POSGRESQL_DRIVER
```
public static final String POSGRESQL_DRIVER
```
    JDBC driver for PosgreSQL database
    
    See Also:
    
    Constant Field Values
  - COMPOSITE_DRIVER
```
public static final String COMPOSITE_DRIVER
```
    JDBC driver for Composite database
    
    See Also:
    
    Constant Field Values
  - ORACLE_URL_TEMPLATE
```
public static final String ORACLE_URL_TEMPLATE
```
    JDBC URL template for Oracle database
    
    See Also:
    
    Constant Field Values
  - MSSQL_URL_TEMPLATE
```
@Deprecated
public static final 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 String MSSQL2005_URL_TEMPLATE
```
    JDBC URL template for MS SQL 2005 database
    
    See Also:
    
    Constant Field Values
  - MYSQL_URL_TEMPLATE
```
public static final String MYSQL_URL_TEMPLATE
```
    JDBC URL template for MySQL database
    
    See Also:
    
    Constant Field Values
  - ACCESS_URL_TEMPLATE
```
public static final String ACCESS_URL_TEMPLATE
```
    JDBC URL template for Access database
    
    See Also:
    
    Constant Field Values
  - INTERBASE_URL_TEMPLATE
```
public static final String INTERBASE_URL_TEMPLATE
```
    JDBC URL template for Interbase database
    
    See Also:
    
    Constant Field Values
  - DB2_URL_TEMPLATE
```
public static final String DB2_URL_TEMPLATE
```
    JDBC URL template for DB2 database
    
    See Also:
    
    Constant Field Values
  - POSGRESQL_URL_TEMPLATE
```
public static final String POSGRESQL_URL_TEMPLATE
```
    JDBC URL template for PosgreSQL database
    
    See Also:
    
    Constant Field Values
  - HSQLDB_URL_TEMPLATE
```
public static final String HSQLDB_URL_TEMPLATE
```
    HSQL URL template for Derby database
    
    See Also:
    
    Constant Field Values
  - DERBY_URL_TEMPLATE
```
public static final String DERBY_URL_TEMPLATE
```
    JDBC URL template for Derby database
    
    See Also:
    
    Constant Field Values
  - COMPOSITE_URL_TEMPLATE
```
public static final String COMPOSITE_URL_TEMPLATE
```
    JDBC URL template for Composite database
    
    See Also:
    
    Constant Field Values
  - ORACLE_URL_EXAMPLE
```
public static final String ORACLE_URL_EXAMPLE
```
    JDBC URL example for Oracle database
    
    See Also:
    
    Constant Field Values
  - MSSQL_URL_EXAMPLE
```
@Deprecated
public static final 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 String MSSQL2005_URL_EXAMPLE
```
    JDBC URL example for MS SQL 2005 database
    
    See Also:
    
    Constant Field Values
  - MYSQL_URL_EXAMPLE
```
public static final String MYSQL_URL_EXAMPLE
```
    JDBC URL example for MySQL database
    
    See Also:
    
    Constant Field Values
  - ACCESS_URL_EXAMPLE
```
public static final String ACCESS_URL_EXAMPLE
```
    JDBC URL example for Access database
    
    See Also:
    
    Constant Field Values
  - INTERBASE_URL_EXAMPLE
```
public static final String INTERBASE_URL_EXAMPLE
```
    JDBC URL example for Interbase database
    
    See Also:
    
    Constant Field Values
  - DB2_URL_EXAMPLE
```
public static final String DB2_URL_EXAMPLE
```
    JDBC URL example for DB2 database
    
    See Also:
    
    Constant Field Values
  - POSGRESQL_URL_EXAMPLE
```
public static final String POSGRESQL_URL_EXAMPLE
```
    JDBC URL example for PosgreSQL database
    
    See Also:
    
    Constant Field Values
  - HSQLDB_URL_EXAMPLE
```
public static final String HSQLDB_URL_EXAMPLE
```
    JDBC URL example for HSQL database
    
    See Also:
    
    Constant Field Values
  - DERBY_URL_EXAMPLE
```
public static final String DERBY_URL_EXAMPLE
```
    JDBC URL example for Derby database
    
    See Also:
    
    Constant Field Values
  - COMPOSITE_URL_EXAMPLE
```
public static final String COMPOSITE_URL_EXAMPLE
```
    JDBC URL example for Composite database
    
    See Also:
    
    Constant Field Values
  - DBMS_NAMES
```
public static final 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 String[] DBMS_DRIVERS
```
    Database drivers.
    
    Since:
    
    JChem 5.9
  - DBMS_URL_TEMPLATES
```
public static final String[] DBMS_URL_TEMPLATES
```
    Database URL templates.
    
    Since:
    
    JChem 5.9
  - DBMS_URL_EXAMPLES
```
public static final 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