com.liferay.portal.kernel.dao.db

Interface DB

@ProviderType
public interface DB

Author:

Brian Wing Shun Chan

Field Summary

Fields

Modifier and Type	Field and Description
static int	BARE
static int	DEFAULT

Method Summary

Modifier and Type	Method and Description
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)
DBType	getDBType()
List<Index>	getIndexes(Connection con)
int	getMajorVersion()
int	getMinorVersion()
String	getTemplateBlob()
String	getTemplateFalse()
String	getTemplateTrue()
String	getVersionString()
long	increment()
long	increment(String name)
long	increment(String name, int size)
boolean	isSupportsAlterColumnName()
boolean	isSupportsAlterColumnType()
boolean	isSupportsInlineDistinct()
boolean	isSupportsQueryingAfterException()
boolean	isSupportsScrollableResults()
boolean	isSupportsStringCaseSensitiveQuery()
boolean	isSupportsUpdateWithInnerJoin()
default void	runSQL(Connection con, DBTypeToSQLMap dbTypeToSQLMap)
void	runSQL(Connection con, String sql)
void	runSQL(Connection con, String[] sqls)
default void	runSQL(DBTypeToSQLMap dbTypeToSQLMap)
void	runSQL(String sql)
void	runSQL(String[] sqls)
void	runSQLTemplate(String path)
void	runSQLTemplate(String path, boolean failOnError)
void	runSQLTemplateString(Connection connection, String template, boolean evaluate, boolean failOnError)
void	runSQLTemplateString(String template, boolean evaluate, boolean failOnError)
void	setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)
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

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

getDBType

DBType getDBType()

getIndexes

List<Index> getIndexes(Connection con)
                throws SQLException

Throws:

SQLException

getMajorVersion

int getMajorVersion()

getMinorVersion

int getMinorVersion()

getTemplateBlob

String getTemplateBlob()

getTemplateFalse

String getTemplateFalse()

getTemplateTrue

String getTemplateTrue()

getVersionString

String getVersionString()

increment

long increment()

increment

long increment(String name)

increment

long increment(String name,
               int size)

isSupportsAlterColumnName

boolean isSupportsAlterColumnName()

isSupportsAlterColumnType

boolean isSupportsAlterColumnType()

isSupportsInlineDistinct

boolean isSupportsInlineDistinct()

isSupportsQueryingAfterException

boolean isSupportsQueryingAfterException()

isSupportsScrollableResults

boolean isSupportsScrollableResults()

isSupportsStringCaseSensitiveQuery

boolean isSupportsStringCaseSensitiveQuery()

isSupportsUpdateWithInnerJoin

boolean isSupportsUpdateWithInnerJoin()

runSQL

default void runSQL(Connection con,
                    DBTypeToSQLMap dbTypeToSQLMap)
             throws IOException,
                    SQLException

Throws:

IOException

SQLException

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

default void runSQL(DBTypeToSQLMap dbTypeToSQLMap)
             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,
                    javax.naming.NamingException,
                    SQLException

Throws:

IOException

javax.naming.NamingException

SQLException

runSQLTemplate

void runSQLTemplate(String path,
                    boolean failOnError)
             throws IOException,
                    javax.naming.NamingException,
                    SQLException

Throws:

IOException

javax.naming.NamingException

SQLException

runSQLTemplateString

void runSQLTemplateString(Connection connection,
                          String template,
                          boolean evaluate,
                          boolean failOnError)
                   throws IOException,
                          javax.naming.NamingException,
                          SQLException

Throws:

IOException

javax.naming.NamingException

SQLException

runSQLTemplateString

void runSQLTemplateString(String template,
                          boolean evaluate,
                          boolean failOnError)
                   throws IOException,
                          javax.naming.NamingException,
                          SQLException

Throws:

IOException

javax.naming.NamingException

SQLException

setSupportsStringCaseSensitiveQuery

void setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)

updateIndexes

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

Throws:

IOException

SQLException