Liferay 6.2-ce-ga5

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


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
 void addIndexes(Connection con, String indexesSQL, Set<String> validIndexNames)
           
 void buildCreateFile(String sqlDir, String databaseName)
           
 void buildCreateFile(String sqlDir, String databaseName, int population)
           
 String buildSQL(String template)
           
 void buildSQLFile(String sqlDir, String fileName)
           
 List<Index> getIndexes(Connection con)
           
 String getTemplateFalse()
           
 String getTemplateTrue()
           
 String getType()
           
 long increment()
           
 long increment(String name)
           
 boolean isSupportsAlterColumnName()
           
 boolean isSupportsAlterColumnType()
           
 boolean isSupportsDateMilliseconds()
           
 boolean isSupportsInlineDistinct()
           
 boolean isSupportsQueryingAfterException()
           
 boolean isSupportsScrollableResults()
           
 boolean isSupportsStringCaseSensitiveQuery()
           
 boolean isSupportsUpdateWithInnerJoin()
           
 void runSQL(Connection con, String sql)
           
 void runSQL(Connection con, String[] sqls)
           
 void runSQL(String sql)
           
 void runSQL(String[] sqls)
           
 void runSQLTemplate(String path)
           
 void runSQLTemplate(String path, boolean failOnError)
           
 void runSQLTemplateString(String template, boolean evaluate, boolean failOnError)
           
 void setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)
           
 void updateIndexes(Connection con, String tablesSQL, String indexesSQL, String indexesProperties, 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

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,
                   String indexesProperties,
                   boolean dropStaleIndexes)
                   throws IOException,
                          SQLException
Throws:
IOException
SQLException

Liferay 6.2-ce-ga5