Liferay 6.2.0

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

All Known Implementing Classes:
BaseDB, DB2DB, DBUtil, DerbyDB, FirebirdDB, HypersonicDB, InformixDB, IngresDB, InterBaseDB, JDataStoreDB, MySQLDB, OracleDB, PostgreSQLDB, SampleMySQLDB, SAPDB, SQLServerDB, SybaseDB

public interface DB


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

Field Detail

BARE

static final int BARE
See Also:
Constant Field Values

DEFAULT

static final int DEFAULT
See Also:
Constant Field Values

SHARDED

static final int SHARDED
See Also:
Constant Field Values

TYPE_ALL

static final String[] TYPE_ALL

TYPE_DB2

static final String TYPE_DB2
See Also:
Constant Field Values

TYPE_DERBY

static final String TYPE_DERBY
See Also:
Constant Field Values

TYPE_FIREBIRD

static final String TYPE_FIREBIRD
See Also:
Constant Field Values

TYPE_HYPERSONIC

static final String TYPE_HYPERSONIC
See Also:
Constant Field Values

TYPE_INFORMIX

static final String TYPE_INFORMIX
See Also:
Constant Field Values

TYPE_INGRES

static final String TYPE_INGRES
See Also:
Constant Field Values

TYPE_INTERBASE

static final String TYPE_INTERBASE
See Also:
Constant Field Values

TYPE_JDATASTORE

static final String TYPE_JDATASTORE
See Also:
Constant Field Values

TYPE_MYSQL

static final String TYPE_MYSQL
See Also:
Constant Field Values

TYPE_ORACLE

static final String TYPE_ORACLE
See Also:
Constant Field Values

TYPE_POSTGRESQL

static final String TYPE_POSTGRESQL
See Also:
Constant Field Values

TYPE_SAP

static final String TYPE_SAP
See Also:
Constant Field Values

TYPE_SQLSERVER

static final String TYPE_SQLSERVER
See Also:
Constant Field Values

TYPE_SYBASE

static final String TYPE_SYBASE
See Also:
Constant Field Values
Method Detail

addIndexes

void addIndexes(Connection con,
                String indexesSQL,
                Set<String> validIndexNames)
                throws IOException
Throws:
IOException

buildCreateFile

void buildCreateFile(String sqlDir,
                     String databaseName)
                     throws IOException
Throws:
IOException

buildCreateFile

void buildCreateFile(String sqlDir,
                     String databaseName,
                     int population)
                     throws IOException
Throws:
IOException

buildSQL

String buildSQL(String template)
                throws IOException
Throws:
IOException

buildSQLFile

void buildSQLFile(String sqlDir,
                  String fileName)
                  throws IOException
Throws:
IOException

getIndexes

List<Index> getIndexes(Connection con)
                       throws SQLException
Throws:
SQLException

getTemplateBlob

String getTemplateBlob()

getTemplateFalse

String getTemplateFalse()

getTemplateTrue

String getTemplateTrue()

getType

String getType()

increment

long increment()
               throws SystemException
Throws:
SystemException

increment

long increment(String name)
               throws SystemException
Throws:
SystemException

isSupportsAlterColumnName

boolean isSupportsAlterColumnName()

isSupportsAlterColumnType

boolean isSupportsAlterColumnType()

isSupportsDateMilliseconds

boolean isSupportsDateMilliseconds()

isSupportsInlineDistinct

boolean isSupportsInlineDistinct()

isSupportsQueryingAfterException

boolean isSupportsQueryingAfterException()

isSupportsScrollableResults

boolean isSupportsScrollableResults()

isSupportsStringCaseSensitiveQuery

boolean isSupportsStringCaseSensitiveQuery()

isSupportsUpdateWithInnerJoin

boolean isSupportsUpdateWithInnerJoin()

runSQL

void runSQL(Connection con,
            String sql)
            throws IOException,
                   SQLException
Throws:
IOException
SQLException

runSQL

void runSQL(Connection con,
            String[] sqls)
            throws IOException,
                   SQLException
Throws:
IOException
SQLException

runSQL

void runSQL(String sql)
            throws IOException,
                   SQLException
Throws:
IOException
SQLException

runSQL

void runSQL(String[] sqls)
            throws IOException,
                   SQLException
Throws:
IOException
SQLException

runSQLTemplate

void runSQLTemplate(String path)
                    throws IOException,
                           NamingException,
                           SQLException
Throws:
IOException
NamingException
SQLException

runSQLTemplate

void runSQLTemplate(String path,
                    boolean failOnError)
                    throws IOException,
                           NamingException,
                           SQLException
Throws:
IOException
NamingException
SQLException

runSQLTemplateString

void runSQLTemplateString(String template,
                          boolean evaluate,
                          boolean failOnError)
                          throws IOException,
                                 NamingException,
                                 SQLException
Throws:
IOException
NamingException
SQLException

setSupportsStringCaseSensitiveQuery

void setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)

updateIndexes

void updateIndexes(Connection con,
                   String tablesSQL,
                   String indexesSQL,
                   boolean dropStaleIndexes)
                   throws IOException,
                          SQLException
Throws:
IOException
SQLException

Liferay 6.2.0