DB (Liferay 7.0.10 portal-kernel API)

```
@ProviderType
public interface DB
```
Author:

Brian Wing Shun Chan

Field Summary

Fields
Modifier and Type Field and Description

static int BARE

static int DEFAULT

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

Method Summary

All Methods Instance Methods Abstract Methods
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()`
`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(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

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(Connection connection,
                          String template,
                          boolean evaluate,
                          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

Interface DB

Field Summary

Method Summary

Field Detail

BARE

DEFAULT

Method Detail

addIndexes

buildCreateFile

buildCreateFile

buildSQL

buildSQLFile

getDBType

getIndexes

getMajorVersion

getMinorVersion

getTemplateBlob

getTemplateFalse

getTemplateTrue

getVersionString

increment

increment

increment

isSupportsAlterColumnName

isSupportsAlterColumnType

isSupportsInlineDistinct

isSupportsQueryingAfterException

isSupportsScrollableResults

isSupportsStringCaseSensitiveQuery

isSupportsUpdateWithInnerJoin

runSQL

runSQL

runSQL

runSQL

runSQLTemplate

runSQLTemplate

runSQLTemplateString

runSQLTemplateString

setSupportsStringCaseSensitiveQuery

updateIndexes