org.camunda.bpm.engine.impl.db.sql

Class DbSqlSessionFactory

java.lang.Object

org.camunda.bpm.engine.impl.db.sql.DbSqlSessionFactory

All Implemented Interfaces:

SessionFactory

public class DbSqlSessionFactory
extends Object
implements SessionFactory

Author:

Tom Baeyens

Field Summary

Fields

Modifier and Type	Field and Description
protected boolean	cmmnEnabled
protected String	databaseSchema In some situations you want to set the schema to use for table checks / generation if the database metadata doesn't return that correctly, see https://jira.codehaus.org/browse/ACT-1220, https://jira.codehaus.org/browse/ACT-1062
static Map<String,String>	databaseSpecificBitAnd1
static Map<String,String>	databaseSpecificBitAnd2
static Map<String,String>	databaseSpecificBitAnd3
static Map<String,String>	databaseSpecificCountDistinctAfterEnd
static Map<String,String>	databaseSpecificCountDistinctBeforeEnd
static Map<String,String>	databaseSpecificCountDistinctBeforeStart
static Map<String,String>	databaseSpecificDatepart1
static Map<String,String>	databaseSpecificDatepart2
static Map<String,String>	databaseSpecificDatepart3
static Map<String,String>	databaseSpecificDaysComparator
static Map<String,String>	databaseSpecificDistinct
static Map<String,String>	databaseSpecificDummyTable
static Map<String,String>	databaseSpecificEscapeChar
static Map<String,String>	databaseSpecificFalseConstant
static Map<String,String>	databaseSpecificIfNull
static Map<String,String>	databaseSpecificInnerLimitAfterStatements
static Map<String,String>	databaseSpecificLimitAfterStatements
static Map<String,String>	databaseSpecificLimitAfterWithoutOffsetStatements
static Map<String,String>	databaseSpecificLimitBeforeNativeQueryStatements
static Map<String,String>	databaseSpecificLimitBeforeStatements
static Map<String,String>	databaseSpecificLimitBeforeWithoutOffsetStatements
static Map<String,String>	databaseSpecificLimitBetweenAcquisitionStatements
static Map<String,String>	databaseSpecificLimitBetweenFilterStatements
static Map<String,String>	databaseSpecificLimitBetweenStatements
static Map<String,String>	databaseSpecificOrderByStatements
protected static Map<String,Map<String,String>>	databaseSpecificStatements
static Map<String,String>	databaseSpecificTrueConstant
protected String	databaseTablePrefix
protected String	databaseType
static String	DB2
static Map<String,Map<String,String>>	dbSpecificConstants
protected Map<Class<?>,String>	deleteStatements
protected boolean	dmnEnabled
static String	H2
protected IdGenerator	idGenerator
protected Map<Class<?>,String>	insertStatements
protected boolean	isDbHistoryUsed
protected boolean	isDbIdentityUsed
protected boolean	jdbcBatchProcessing
static String	MARIADB
static int	MAXIMUM_NUMBER_PARAMS
static String	MSSQL
static String	MYSQL
static Map<String,String>	optimizeDatabaseSpecificLimitAfterWithoutOffsetStatements
static Map<String,String>	optimizeDatabaseSpecificLimitBeforeWithoutOffsetStatements
static String	ORACLE
static String	POSTGRES
protected Map<Class<?>,String>	selectStatements
protected org.apache.ibatis.session.SqlSessionFactory	sqlSessionFactory
protected Map<String,String>	statementMappings
protected Map<Class<?>,String>	updateStatements

Constructor Summary

Constructors

Constructor and Description
DbSqlSessionFactory(boolean jdbcBatchProcessing)

Method Summary

Modifier and Type	Method and Description
protected static void	addDatabaseSpecificStatement(String databaseType, String activitiStatement, String ibatisStatement)
String	getDatabaseSchema()
String	getDatabaseTablePrefix()
String	getDatabaseType()
String	getDeleteStatement(Class<?> persistentObjectClass)
Map<Class<?>,String>	getDeleteStatements()
IdGenerator	getIdGenerator()
String	getInsertStatement(DbEntity object)
Map<Class<?>,String>	getInsertStatements()
String	getSelectStatement(Class<?> persistentObjectClass)
Map<Class<?>,String>	getSelectStatements()
Class<?>	getSessionType()
org.apache.ibatis.session.SqlSessionFactory	getSqlSessionFactory()
Map<String,String>	getStatementMappings()
String	getUpdateStatement(DbEntity object)
Map<Class<?>,String>	getUpdateStatements()
boolean	isCmmnEnabled()
boolean	isDbHistoryUsed()
boolean	isDbIdentityUsed()
boolean	isDmnEnabled()
String	mapStatement(String statement)
Session	openSession()
DbSqlSession	openSession(Connection connection, String catalog, String schema)
void	setCmmnEnabled(boolean cmmnEnabled)
void	setDatabaseSchema(String databaseSchema)
void	setDatabaseTablePrefix(String databaseTablePrefix)
void	setDatabaseType(String databaseType)
void	setDbHistoryUsed(boolean isDbHistoryUsed)
void	setDbIdentityUsed(boolean isDbIdentityUsed)
void	setDeleteStatements(Map<Class<?>,String> deleteStatements)
void	setDmnEnabled(boolean dmnEnabled)
void	setIdGenerator(IdGenerator idGenerator)
void	setInsertStatements(Map<Class<?>,String> insertStatements)
void	setSelectStatements(Map<Class<?>,String> selectStatements)
void	setSqlSessionFactory(org.apache.ibatis.session.SqlSessionFactory sqlSessionFactory)
void	setStatementMappings(Map<String,String> statementMappings)
void	setUpdateStatements(Map<Class<?>,String> updateStatements)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

MSSQL

public static final String MSSQL

See Also:

Constant Field Values

DB2

public static final String DB2

See Also:

Constant Field Values

ORACLE

public static final String ORACLE

See Also:

Constant Field Values

H2

public static final String H2

See Also:

Constant Field Values

MYSQL

public static final String MYSQL

See Also:

Constant Field Values

POSTGRES

public static final String POSTGRES

See Also:

Constant Field Values

MARIADB

public static final String MARIADB

See Also:

Constant Field Values

databaseSpecificStatements

protected static final Map<String,Map<String,String>> databaseSpecificStatements

databaseSpecificLimitBeforeStatements

public static final Map<String,String> databaseSpecificLimitBeforeStatements

databaseSpecificLimitAfterStatements

public static final Map<String,String> databaseSpecificLimitAfterStatements

databaseSpecificLimitBeforeWithoutOffsetStatements

public static final Map<String,String> databaseSpecificLimitBeforeWithoutOffsetStatements

databaseSpecificLimitAfterWithoutOffsetStatements

public static final Map<String,String> databaseSpecificLimitAfterWithoutOffsetStatements

databaseSpecificInnerLimitAfterStatements

public static final Map<String,String> databaseSpecificInnerLimitAfterStatements

databaseSpecificLimitBetweenStatements

public static final Map<String,String> databaseSpecificLimitBetweenStatements

databaseSpecificLimitBetweenFilterStatements

public static final Map<String,String> databaseSpecificLimitBetweenFilterStatements

databaseSpecificLimitBetweenAcquisitionStatements

public static final Map<String,String> databaseSpecificLimitBetweenAcquisitionStatements

databaseSpecificCountDistinctBeforeStart

public static final Map<String,String> databaseSpecificCountDistinctBeforeStart

databaseSpecificCountDistinctBeforeEnd

public static final Map<String,String> databaseSpecificCountDistinctBeforeEnd

databaseSpecificCountDistinctAfterEnd

public static final Map<String,String> databaseSpecificCountDistinctAfterEnd

optimizeDatabaseSpecificLimitBeforeWithoutOffsetStatements

public static final Map<String,String> optimizeDatabaseSpecificLimitBeforeWithoutOffsetStatements

optimizeDatabaseSpecificLimitAfterWithoutOffsetStatements

public static final Map<String,String> optimizeDatabaseSpecificLimitAfterWithoutOffsetStatements

databaseSpecificEscapeChar

public static final Map<String,String> databaseSpecificEscapeChar

databaseSpecificOrderByStatements

public static final Map<String,String> databaseSpecificOrderByStatements

databaseSpecificLimitBeforeNativeQueryStatements

public static final Map<String,String> databaseSpecificLimitBeforeNativeQueryStatements

databaseSpecificBitAnd1

public static final Map<String,String> databaseSpecificBitAnd1

databaseSpecificBitAnd2

public static final Map<String,String> databaseSpecificBitAnd2

databaseSpecificBitAnd3

public static final Map<String,String> databaseSpecificBitAnd3

databaseSpecificDatepart1

public static final Map<String,String> databaseSpecificDatepart1

databaseSpecificDatepart2

public static final Map<String,String> databaseSpecificDatepart2

databaseSpecificDatepart3

public static final Map<String,String> databaseSpecificDatepart3

databaseSpecificDummyTable

public static final Map<String,String> databaseSpecificDummyTable

databaseSpecificIfNull

public static final Map<String,String> databaseSpecificIfNull

databaseSpecificTrueConstant

public static final Map<String,String> databaseSpecificTrueConstant

databaseSpecificFalseConstant

public static final Map<String,String> databaseSpecificFalseConstant

databaseSpecificDistinct

public static final Map<String,String> databaseSpecificDistinct

dbSpecificConstants

public static final Map<String,Map<String,String>> dbSpecificConstants

databaseSpecificDaysComparator

public static final Map<String,String> databaseSpecificDaysComparator

MAXIMUM_NUMBER_PARAMS

public static final int MAXIMUM_NUMBER_PARAMS

See Also:

Constant Field Values

databaseType

protected String databaseType

databaseTablePrefix

protected String databaseTablePrefix

databaseSchema

protected String databaseSchema

In some situations you want to set the schema to use for table checks / generation if the database metadata doesn't return that correctly, see https://jira.codehaus.org/browse/ACT-1220, https://jira.codehaus.org/browse/ACT-1062

sqlSessionFactory

protected org.apache.ibatis.session.SqlSessionFactory sqlSessionFactory

idGenerator

protected IdGenerator idGenerator

statementMappings

protected Map<String,String> statementMappings

insertStatements

protected Map<Class<?>,String> insertStatements

updateStatements

protected Map<Class<?>,String> updateStatements

deleteStatements

protected Map<Class<?>,String> deleteStatements

selectStatements

protected Map<Class<?>,String> selectStatements

isDbIdentityUsed

protected boolean isDbIdentityUsed

isDbHistoryUsed

protected boolean isDbHistoryUsed

cmmnEnabled

protected boolean cmmnEnabled

dmnEnabled

protected boolean dmnEnabled

jdbcBatchProcessing

protected boolean jdbcBatchProcessing

Constructor Detail

DbSqlSessionFactory

public DbSqlSessionFactory(boolean jdbcBatchProcessing)

Method Detail

getSessionType

public Class<?> getSessionType()

Specified by:

getSessionType in interface SessionFactory

openSession

public Session openSession()

Specified by:

openSession in interface SessionFactory

openSession

public DbSqlSession openSession(Connection connection,
                                String catalog,
                                String schema)

getInsertStatement

public String getInsertStatement(DbEntity object)

getUpdateStatement

public String getUpdateStatement(DbEntity object)

getDeleteStatement

public String getDeleteStatement(Class<?> persistentObjectClass)

getSelectStatement

public String getSelectStatement(Class<?> persistentObjectClass)

addDatabaseSpecificStatement

protected static void addDatabaseSpecificStatement(String databaseType,
                                                   String activitiStatement,
                                                   String ibatisStatement)

mapStatement

public String mapStatement(String statement)

setDatabaseType

public void setDatabaseType(String databaseType)

getSqlSessionFactory

public org.apache.ibatis.session.SqlSessionFactory getSqlSessionFactory()

setSqlSessionFactory

public void setSqlSessionFactory(org.apache.ibatis.session.SqlSessionFactory sqlSessionFactory)

getIdGenerator

public IdGenerator getIdGenerator()

setIdGenerator

public void setIdGenerator(IdGenerator idGenerator)

getDatabaseType

public String getDatabaseType()

getStatementMappings

public Map<String,String> getStatementMappings()

setStatementMappings

public void setStatementMappings(Map<String,String> statementMappings)

getInsertStatements

public Map<Class<?>,String> getInsertStatements()

setInsertStatements

public void setInsertStatements(Map<Class<?>,String> insertStatements)

getUpdateStatements

public Map<Class<?>,String> getUpdateStatements()

setUpdateStatements

public void setUpdateStatements(Map<Class<?>,String> updateStatements)

getDeleteStatements

public Map<Class<?>,String> getDeleteStatements()

setDeleteStatements

public void setDeleteStatements(Map<Class<?>,String> deleteStatements)

getSelectStatements

public Map<Class<?>,String> getSelectStatements()

setSelectStatements

public void setSelectStatements(Map<Class<?>,String> selectStatements)

isDbIdentityUsed

public boolean isDbIdentityUsed()

setDbIdentityUsed

public void setDbIdentityUsed(boolean isDbIdentityUsed)

isDbHistoryUsed

public boolean isDbHistoryUsed()

setDbHistoryUsed

public void setDbHistoryUsed(boolean isDbHistoryUsed)

isCmmnEnabled

public boolean isCmmnEnabled()

setCmmnEnabled

public void setCmmnEnabled(boolean cmmnEnabled)

isDmnEnabled

public boolean isDmnEnabled()

setDmnEnabled

public void setDmnEnabled(boolean dmnEnabled)

setDatabaseTablePrefix

public void setDatabaseTablePrefix(String databaseTablePrefix)

getDatabaseTablePrefix

public String getDatabaseTablePrefix()

getDatabaseSchema

public String getDatabaseSchema()

setDatabaseSchema

public void setDatabaseSchema(String databaseSchema)