com.liferay.portal.kernel.dao.db
Interface DB


public interface DB

View Source

Author:
Brian Wing Shun Chan

Field Summary
static int MINIMAL
           
static int POPULATED
           
static int SHARDED
           
static java.lang.String[] TYPE_ALL
           
static java.lang.String TYPE_DB2
           
static java.lang.String TYPE_DERBY
           
static java.lang.String TYPE_FIREBIRD
           
static java.lang.String TYPE_HYPERSONIC
           
static java.lang.String TYPE_INFORMIX
           
static java.lang.String TYPE_INGRES
           
static java.lang.String TYPE_INTERBASE
           
static java.lang.String TYPE_JDATASTORE
           
static java.lang.String TYPE_MYSQL
           
static java.lang.String TYPE_ORACLE
           
static java.lang.String TYPE_POSTGRESQL
           
static java.lang.String TYPE_SAP
           
static java.lang.String TYPE_SQLSERVER
           
static java.lang.String TYPE_SYBASE
           
 
Method Summary
 void buildCreateFile(java.lang.String sqlDir, java.lang.String databaseName)
           
 void buildCreateFile(java.lang.String sqlDir, java.lang.String databaseName, int population)
           
 java.lang.String buildSQL(java.lang.String template)
           
 void buildSQLFile(java.lang.String sqlDir, java.lang.String fileName)
           
 java.util.List<Index> getIndexes()
           
 java.lang.String getTemplateFalse()
           
 java.lang.String getTemplateTrue()
           
 java.lang.String getType()
           
 long increment()
           
 boolean isSupportsAlterColumnName()
           
 boolean isSupportsAlterColumnType()
           
 boolean isSupportsDateMilliseconds()
           
 boolean isSupportsScrollableResults()
           
 boolean isSupportsStringCaseSensitiveQuery()
           
 boolean isSupportsUpdateWithInnerJoin()
           
 void runSQL(java.sql.Connection con, java.lang.String sql)
           
 void runSQL(java.sql.Connection con, java.lang.String[] sqls)
           
 void runSQL(java.lang.String sql)
           
 void runSQL(java.lang.String[] sqls)
           
 void runSQLTemplate(java.lang.String path)
           
 void runSQLTemplate(java.lang.String path, boolean failOnError)
           
 void runSQLTemplateString(java.lang.String template, boolean evaluate, boolean failOnError)
           
 void setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)
           
 void updateIndexes(java.lang.String tablesSQL, java.lang.String indexesSQL, java.lang.String indexesProperties, boolean dropStaleIndexes)
           
 

Field Detail

MINIMAL

static final int MINIMAL
See Also:
Constant Field Values

POPULATED

static final int POPULATED
See Also:
Constant Field Values

SHARDED

static final int SHARDED
See Also:
Constant Field Values

TYPE_DB2

static final java.lang.String TYPE_DB2
See Also:
Constant Field Values

TYPE_DERBY

static final java.lang.String TYPE_DERBY
See Also:
Constant Field Values

TYPE_FIREBIRD

static final java.lang.String TYPE_FIREBIRD
See Also:
Constant Field Values

TYPE_HYPERSONIC

static final java.lang.String TYPE_HYPERSONIC
See Also:
Constant Field Values

TYPE_INFORMIX

static final java.lang.String TYPE_INFORMIX
See Also:
Constant Field Values

TYPE_INGRES

static final java.lang.String TYPE_INGRES
See Also:
Constant Field Values

TYPE_INTERBASE

static final java.lang.String TYPE_INTERBASE
See Also:
Constant Field Values

TYPE_JDATASTORE

static final java.lang.String TYPE_JDATASTORE
See Also:
Constant Field Values

TYPE_MYSQL

static final java.lang.String TYPE_MYSQL
See Also:
Constant Field Values

TYPE_ORACLE

static final java.lang.String TYPE_ORACLE
See Also:
Constant Field Values

TYPE_POSTGRESQL

static final java.lang.String TYPE_POSTGRESQL
See Also:
Constant Field Values

TYPE_SAP

static final java.lang.String TYPE_SAP
See Also:
Constant Field Values

TYPE_SQLSERVER

static final java.lang.String TYPE_SQLSERVER
See Also:
Constant Field Values

TYPE_SYBASE

static final java.lang.String TYPE_SYBASE
See Also:
Constant Field Values

TYPE_ALL

static final java.lang.String[] TYPE_ALL
Method Detail

buildCreateFile

void buildCreateFile(java.lang.String sqlDir,
                     java.lang.String databaseName)
                     throws java.io.IOException
Throws:
java.io.IOException

buildCreateFile

void buildCreateFile(java.lang.String sqlDir,
                     java.lang.String databaseName,
                     int population)
                     throws java.io.IOException
Throws:
java.io.IOException

buildSQL

java.lang.String buildSQL(java.lang.String template)
                          throws java.io.IOException
Throws:
java.io.IOException

buildSQLFile

void buildSQLFile(java.lang.String sqlDir,
                  java.lang.String fileName)
                  throws java.io.IOException
Throws:
java.io.IOException

getIndexes

java.util.List<Index> getIndexes()
                                 throws java.sql.SQLException
Throws:
java.sql.SQLException

getTemplateFalse

java.lang.String getTemplateFalse()

getTemplateTrue

java.lang.String getTemplateTrue()

getType

java.lang.String getType()

increment

long increment()
               throws SystemException
Throws:
SystemException

isSupportsAlterColumnName

boolean isSupportsAlterColumnName()

isSupportsAlterColumnType

boolean isSupportsAlterColumnType()

isSupportsDateMilliseconds

boolean isSupportsDateMilliseconds()

isSupportsScrollableResults

boolean isSupportsScrollableResults()

isSupportsStringCaseSensitiveQuery

boolean isSupportsStringCaseSensitiveQuery()

isSupportsUpdateWithInnerJoin

boolean isSupportsUpdateWithInnerJoin()

runSQL

void runSQL(java.lang.String sql)
            throws java.io.IOException,
                   java.sql.SQLException
Throws:
java.io.IOException
java.sql.SQLException

runSQL

void runSQL(java.sql.Connection con,
            java.lang.String sql)
            throws java.io.IOException,
                   java.sql.SQLException
Throws:
java.io.IOException
java.sql.SQLException

runSQL

void runSQL(java.lang.String[] sqls)
            throws java.io.IOException,
                   java.sql.SQLException
Throws:
java.io.IOException
java.sql.SQLException

runSQL

void runSQL(java.sql.Connection con,
            java.lang.String[] sqls)
            throws java.io.IOException,
                   java.sql.SQLException
Throws:
java.io.IOException
java.sql.SQLException

runSQLTemplate

void runSQLTemplate(java.lang.String path)
                    throws java.io.IOException,
                           javax.naming.NamingException,
                           java.sql.SQLException
Throws:
java.io.IOException
javax.naming.NamingException
java.sql.SQLException

runSQLTemplate

void runSQLTemplate(java.lang.String path,
                    boolean failOnError)
                    throws java.io.IOException,
                           javax.naming.NamingException,
                           java.sql.SQLException
Throws:
java.io.IOException
javax.naming.NamingException
java.sql.SQLException

runSQLTemplateString

void runSQLTemplateString(java.lang.String template,
                          boolean evaluate,
                          boolean failOnError)
                          throws java.io.IOException,
                                 javax.naming.NamingException,
                                 java.sql.SQLException
Throws:
java.io.IOException
javax.naming.NamingException
java.sql.SQLException

setSupportsStringCaseSensitiveQuery

void setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)

updateIndexes

void updateIndexes(java.lang.String tablesSQL,
                   java.lang.String indexesSQL,
                   java.lang.String indexesProperties,
                   boolean dropStaleIndexes)
                   throws java.io.IOException,
                          java.sql.SQLException
Throws:
java.io.IOException
java.sql.SQLException