Documentation of 'org.hsqldb.Database' Java class
Database
Skip navigation links
org.hsqldb

Class Database


  • public class Database
extends java.lang.Object
    Database is the root class for HSQL Database Engine database.

    It holds the data structures that form an HSQLDB database instance.

    Since:
    1.9.0

    • Field Detail

      • logger

        public Logger logger

      • sqlEnforceTypes

        public boolean sqlEnforceTypes
        Defaults are used in version upgrades, but overridden by databaseProperties or URL properties for new databases.

      • sqlEnforceRefs

        public boolean sqlEnforceRefs

      • sqlEnforceSize

        public boolean sqlEnforceSize

      • sqlEnforceNames

        public boolean sqlEnforceNames

      • sqlRegularNames

        public boolean sqlRegularNames

      • sqlEnforceTDCD

        public boolean sqlEnforceTDCD

      • sqlEnforceTDCU

        public boolean sqlEnforceTDCU

      • sqlTranslateTTI

        public boolean sqlTranslateTTI

      • sqlConcatNulls

        public boolean sqlConcatNulls

      • sqlUniqueNulls

        public boolean sqlUniqueNulls

      • sqlNullsFirst

        public boolean sqlNullsFirst

      • sqlNullsOrder

        public boolean sqlNullsOrder

      • sqlConvertTruncate

        public boolean sqlConvertTruncate

      • sqlAvgScale

        public int sqlAvgScale

      • sqlDoubleNaN

        public boolean sqlDoubleNaN

      • sqlLongvarIsLob

        public boolean sqlLongvarIsLob

      • sqlIgnoreCase

        public boolean sqlIgnoreCase

      • sqlSyntaxDb2

        public boolean sqlSyntaxDb2

      • sqlSyntaxMss

        public boolean sqlSyntaxMss

      • sqlSyntaxMys

        public boolean sqlSyntaxMys

      • sqlSyntaxOra

        public boolean sqlSyntaxOra

      • sqlSyntaxPgs

        public boolean sqlSyntaxPgs

      • recoveryMode

        public int recoveryMode

      • defaultIsolationLevel

        public int defaultIsolationLevel

      • txConflictRollback

        public boolean txConflictRollback

      • checkpointRunner

        public org.hsqldb.Database.CheckpointRunner checkpointRunner

      • timeoutRunner

        public org.hsqldb.Database.TimeoutRunner timeoutRunner

    • Method Detail

      • getDatabaseID

        public int getDatabaseID()
        Returns the database ID.

      • getUniqueName

        public java.lang.String getUniqueName()
        Returns a unique String identifier for the database.

      • setUniqueName

        public void setUniqueName(java.lang.String name)

      • getType

        public java.lang.String getType()
        Returns the type of the database: "mem", "file", "res"

      • getPath

        public java.lang.String getPath()
        Returns the path of the database

      • getSessionManager

        public SessionManager getSessionManager()
        Returns the SessionManager for the database.

      • isReadOnly

        public boolean isReadOnly()

      • setReadOnly

        public void setReadOnly()
        Puts this Database object in global read-only mode. After this call, all existing and future sessions are limited to read-only transactions. Any following attempts to update the state of the database will result in throwing an HsqlException.

      • setFilesReadOnly

        public void setFilesReadOnly()
        After this call all CACHED and TEXT tables will be set to read-only mode. Changes to MEMORY tables will NOT be stored or updated in the script file. This mode is intended for use with read-only media where data should not be persisted.

      • isFilesReadOnly

        public boolean isFilesReadOnly()
        Is this in filesReadOnly mode?

      • isFilesInJar

        public boolean isFilesInJar()
        Is this in filesInJar mode?

      • getUserManager

        public UserManager getUserManager()
        Returns the UserManager for this Database.

      • getGranteeManager

        public GranteeManager getGranteeManager()
        Returns the GranteeManager for this Database.

      • setReferentialIntegrity

        public void setReferentialIntegrity(boolean ref)
        Sets the isReferentialIntegrity attribute.

      • isReferentialIntegrity

        public boolean isReferentialIntegrity()
        Is referential integrity currently enforced?

      • getResultMaxMemoryRows

        public int getResultMaxMemoryRows()

      • setResultMaxMemoryRows

        public void setResultMaxMemoryRows(int size)

      • setStrictNames

        public void setStrictNames(boolean mode)

      • setRegularNames

        public void setRegularNames(boolean mode)

      • setStrictColumnSize

        public void setStrictColumnSize(boolean mode)

      • setStrictReferences

        public void setStrictReferences(boolean mode)

      • setStrictTypes

        public void setStrictTypes(boolean mode)

      • setStrictTDCD

        public void setStrictTDCD(boolean mode)

      • setStrictTDCU

        public void setStrictTDCU(boolean mode)

      • setTranslateTTI

        public void setTranslateTTI(boolean mode)

      • setNullsFirst

        public void setNullsFirst(boolean mode)

      • setNullsOrder

        public void setNullsOrder(boolean mode)

      • setConcatNulls

        public void setConcatNulls(boolean mode)

      • setUniqueNulls

        public void setUniqueNulls(boolean mode)

      • setConvertTrunc

        public void setConvertTrunc(boolean mode)

      • setDoubleNaN

        public void setDoubleNaN(boolean mode)

      • setAvgScale

        public void setAvgScale(int scale)

      • setLongVarIsLob

        public void setLongVarIsLob(boolean mode)

      • setIgnoreCase

        public void setIgnoreCase(boolean mode)

      • setSyntaxDb2

        public void setSyntaxDb2(boolean mode)

      • setSyntaxMss

        public void setSyntaxMss(boolean mode)

      • setSyntaxMys

        public void setSyntaxMys(boolean mode)

      • setSyntaxOra

        public void setSyntaxOra(boolean mode)

      • setSyntaxPgs

        public void setSyntaxPgs(boolean mode)

      • close

        public void close(int closemode)
        Closes this Database using the specified mode.

        1. closemode -1 performs SHUTDOWN IMMEDIATELY, equivalent to a poweroff or crash.
        2. closemode 0 performs a normal SHUTDOWN that checkpoints the database normally.
        3. closemode 1 performs a shutdown compact that scripts out the contents of any CACHED tables to the log then deletes the existing *.data file that contains the data for all CACHED table before the normal checkpoint process which in turn creates a new, compact *.data file.

      • getSettingsSQL

        public java.lang.String[] getSettingsSQL()

      • getScript

        public Result getScript(boolean indexRoots)
        Returns the schema and authorisation statements for the database.

      • getURI

        public java.lang.String getURI()

      • getCanonicalPath

        public java.lang.String getCanonicalPath()

      • getTimeoutRunner

        public org.hsqldb.Database.TimeoutRunner getTimeoutRunner()
Skip navigation links

DataMelt 3.0 © DataMelt by jWork.ORG

Ads help maintain this website.