Package chemaxon.jchem.db

Class DatabaseConstants

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

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(forRemoval=true)
@SubjectToRemoval(date=JUL_01_2025)
public static final String MSSQL_DRIVER

Deprecated, for removal: This API element is subject to removal in a future version.

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(forRemoval=true)
@SubjectToRemoval(date=JUL_01_2025)
public static final String MSSQL_URL_TEMPLATE

Deprecated, for removal: This API element is subject to removal in a future version.

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(forRemoval=true)
@SubjectToRemoval(date=JUL_01_2025)
public static final String MSSQL_URL_EXAMPLE

Deprecated, for removal: This API element is subject to removal in a future version.

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 Details

DatabaseConstants

public DatabaseConstants()