Class JDBCTypeSettings
Settings for a JDBC data source type.
The settings are loaded from datasource templates.
- Since:
- 3.0
-
Nested Class Summary
Modifier and TypeClassDescriptionstatic class
Mapping between a Java and a SQL type. -
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionvoid
Add a Java to SQL type mapping.static JDBCTypeSettings[]
Returns allJDBCTypeSettings
instances that are currently enabled.boolean
Indicates if prepared statement should be used even when no parameters are set.boolean
Get autocommit mode.int
Returns the batch size that specifies the amount of data in each batch update.Returns the pattern used to format a catalog name in an SQL query.Returns the pattern used to format a column alias in an SQL query.Returns the pattern used to format a column name in an SQL query.int
Return the condition list threshold.Returns the connection properties used when creating a new connection to the database.String[]
Returns the SQL commands needed for creating a temporary table that is used to store filter values (when more than 'condition-list-threshold') and to store result from subqueries.int
Gets the credentials timeout for a JDBC data source.Returns an expression that converts a date field to a string value on the format:"YYYY-MM-DD", e.g. "2002-11-19".Returns an expression that converts a date literal to a database date value.Returns an expression that converts a datetime field to string value on the format: "YYYY-MM-DD HH:MM:SS", e.g. "2002-11-19 14:59:00".Returns an expression that converts a datetime literal to a database datetime value.Returns the name of the JDBC type to be displayed in a UI.Returns the JDBC driver class.String[]
Returns the SQL commands for deleting a temporary table.boolean
Tells if an SQL IN-clause shall be expanded into OR conditions.int
Returns the fetch size that specifies the amount of data fetched with each database round trip for a query.int
Returns the threshold value when LOB values used as parameters in a WHERE clause, must be written in temporary tables.int
Returns the maximum length allowed for column names.int
Returns the maximum size of an SQL IN-clause.Returns theJDBCMetadataProvider
class.int
Returns the minimum number of values for creating a SQL IN-clause.Returns the ping command used to verify a JDBC connection.Return the pattern that determines how a procedure expression is written in the SQL query.Returns the pattern used to format a procedure name in an SQL query.int
Returns the JDBC type for procedure tables.Returns the type name for procedure tables.Returns the query builder class.Returns the pattern used to format a schema name in an SQL query.getSQLAggregateFuntion
(String datAggregateFuntion) Get the SQL aggregate function for the given DAT aggregate function, or null if no such SQL function exists.Returns theSQLFilter
class.Returns theSQLRuntime
class.getSQLType
(Class javaType) Returns the SQL type for a given Java type.getSQLType
(Class javaType, int length) Returns the SQL type for a given Java type.Returns The character used as quote for string literals.Return the pattern that determines how a table expression is written in the SQL query.Returns the pattern used to format a table name in an SQL query.String[]
Returns the pattern used to format a temporary table name in an SQL command.Returns an expression that converts a time field to a string value on the format:"HH:MM:SS", e.g. "14:59:00".Returns an expression that converts a time literal to a database time value.Returns all Java to SQL type mappings.Returns the name of the JDBC type.Returns the URL pattern.boolean
Get useGetSchemas.boolean
Returns if an attempt should be done to go from oracle outer join syntax with '(+)' to ANSI form If useAnsiJoin() is true, then this setting has no effect.boolean
Returns if an attempt should be made to create ansi join syntax.void
setAlwaysUsePreparedStatement
(boolean alwaysUsePreparedStatement) Indicates if prepared statement should be used even when no parameters are set.void
setAnsiiStyleOuterJoin
(boolean outerJoin) Set if an attempt should be done to go from oracle outer join syntax with '(+)' to ANSI form If useAnsiJoin() is true, then this setting has no effect.void
setAnsiJoin
(boolean useAnsiJoin) Set if an attempt should be made to create ansi join syntax.void
setAutocommit
(boolean autocommit) Sets the auto commit mode for connection on the data source.void
setBatchSize
(int size) Sets the batch size that specifies the amount of data in each batch update.void
Sets the pattern used to format a catalog name in an SQL query.void
Sets the pattern used to format a column alias in an SQL query.void
Sets the pattern used to format a column name in an SQL query.void
setConditionListThreshold
(int i) Sets the condition list threshold.void
setConnectionProperties
(Properties connectionProperties) Sets the connection properties used when creating a new connection to the database.void
Sets the SQL commands needed for creating a temporary table that is used to store filter values (when more than 'condition-list-threshold') and to store result from subqueries.void
setCredentialsTimeout
(int credentialsTimeout) Sets the credentials timeout for a JDBC data source.void
Sets an expression that converts a date field to a string value on the format:"YYYY-MM-DD", e.g. "2002-11-19".void
Sets an expression that converts a date literal to a database date value.void
Sets an expression that converts a datetime field to string value on the format: "YYYY-MM-DD HH:MM:SS", e.g. "2002-11-19 14:59:00".void
Sets an expression that converts a datetime literal to a database datetime value.void
Sets the JDBC driver class.void
Sets the SQL commands for deleting a temporary table.void
setExpandInClause
(boolean b) Sets if an SQL IN-clause shall be expanded into OR conditions.void
setFetchSize
(int size) Sets the fetch size that specifies the amount of data fetched with each database round trip for a query.void
setLobThreshold
(int i) Sets the threshold value when LOB values used as parameters in a WHERE clause, must be written in temporary tables.void
setMaxColumnNameLength
(int i) Sets the maximum length allowed for database column names.void
setMaxInClauseSize
(int i) Size the maximum size of an SQL IN-clause.void
Sets theJDBCMetadataProvider
class.void
setMinInClauseSize
(int i) Sets the minimum number of values for creating a SQL IN-clause.void
Sets the ping command used to verify a JDBC connection.void
Sets the pattern that determines how a procedure expression is written in the SQL query.void
Sets the pattern used to format a procedure name in an SQL query.void
setProcedureTableJDBCType
(int type) Sets the JDBC type for procedure tables.void
setProcedureTableTypeName
(String typeName) Sets the type name for procedure tables.void
Sets the pattern used to format a schema name in an SQL query.void
Sets theSQLFilter
class.void
Sets theSQLRuntime
class.void
Sets The character used as quote for string literals.void
setSupportsCatalogs
(boolean b) Sets if the catalog level is supported in metadata.void
setSupportsDistinct
(boolean b) Sets if the DISTINCT keyword is supported in SQL queries.void
setSupportsOrderBy
(boolean b) Sets if the ORDER BY keyword is supported in SQL queries.void
setSupportsProcedures
(boolean b) Sets if procedures are supported in metadata.void
setSupportsSchemas
(boolean b) Sets if the schema level is supported in metadata.void
Sets the pattern that determines how a table expression is written in the SQL query.void
Sets the pattern used to format a table name in an SQL query.void
setTableTypes
(String[] types) void
Sets the pattern used to format a temporary table name in an SQL command.void
Sets an expression that converts a time field to a string value on the format:"HH:MM:SS", e.g. "14:59:00".void
Sets an expression that converts a time literal to a database time value.void
Sets all Java to SQL type mappings.void
setTypeName
(String name) Sets the name of the JDBC type.void
Sets the URL pattern.void
setUseGetSchemas
(boolean useGetSchemas) Set Sets useGetSchemas which specifies if jdbc GetSchemas method should be used.boolean
Tells if the catalog level is supported in metadata.boolean
Tells if the DISTINCT keyword is supported in SQL queries.boolean
Tells if the ORDER BY clause is supported in SQL queries.boolean
Tells if procedures are supported in metadata.boolean
Tells if the schema level is supported in metadata.toString()
Return a string showing the values of all the members.
-
Constructor Details
-
JDBCTypeSettings
public JDBCTypeSettings()Creates a newJDBCTypeSettings
instance.- Since:
- 3.0
-
-
Method Details
-
getAllTypeSettings
Returns allJDBCTypeSettings
instances that are currently enabled.- Returns:
- all
JDBCTypeSettings
instances - Since:
- 3.0
-
getTypeName
Returns the name of the JDBC type.- Returns:
- a type name
- Since:
- 3.0
-
setTypeName
Sets the name of the JDBC type.- Parameters:
name
- a type name- Since:
- 3.0
-
getDisplayName
Returns the name of the JDBC type to be displayed in a UI.- Returns:
- a display name
- Since:
- 3.0
-
getDriverClass
Returns the JDBC driver class.- Returns:
- a class name
- Since:
- 3.0
-
setDriverClass
Sets the JDBC driver class.- Parameters:
c
- a class name- Since:
- 3.0
-
getURLPattern
Returns the URL pattern.- Returns:
- a URL pattern
String
- Since:
- 3.0
-
setURLPattern
Sets the URL pattern.- Parameters:
s
- a URL patternString
- Since:
- 3.0
-
getPingCommand
Returns the ping command used to verify a JDBC connection.- Returns:
- a ping command
String
- Since:
- 3.0
-
setPingCommand
Sets the ping command used to verify a JDBC connection.- Parameters:
s
- a ping commandString
- Since:
- 3.0
-
getMetadataProviderClass
Returns theJDBCMetadataProvider
class.- Returns:
- a
Class
derived fromJDBCMetadataProvider
- Since:
- 3.0
- See Also:
-
setMetadataProviderClass
Sets theJDBCMetadataProvider
class.- Parameters:
c
- aClass
derived fromJDBCMetadataProvider
- Since:
- 3.0
- See Also:
-
getSQLFilterClass
Returns theSQLFilter
class.- Returns:
- a
Class
derived fromSQLFilter
- Since:
- 3.0
- See Also:
-
setSQLFilterClass
Sets theSQLFilter
class.- Parameters:
c
- aClass
derived fromSQLFilter
- Since:
- 3.0
- See Also:
-
getSQLRuntimeClass
Returns theSQLRuntime
class.- Returns:
- a
Class
derived fromSQLRuntime
- Since:
- 3.0
- See Also:
-
setSQLRuntimeClass
Sets theSQLRuntime
class.- Parameters:
c
- aClass
derived fromSQLRuntime
- Since:
- 3.0
- See Also:
-
getQueryBuilderClass
Returns the query builder class. The default isSQLBuilder
.- Returns:
- a
Class
for building queries. - Since:
- 3.0
-
getFetchSize
public int getFetchSize()Returns the fetch size that specifies the amount of data fetched with each database round trip for a query. The fetch size is measured as the number of fields.- Returns:
- a fetch size value
- Since:
- 3.0
-
setFetchSize
public void setFetchSize(int size) Sets the fetch size that specifies the amount of data fetched with each database round trip for a query. The fetch size is measured as the number of fields.- Parameters:
size
- a fetch size value- Since:
- 3.0
-
getBatchSize
public int getBatchSize()Returns the batch size that specifies the amount of data in each batch update. The batch size is measured as the number of fields.- Returns:
- a batch size value
- Since:
- 3.0
-
setBatchSize
public void setBatchSize(int size) Sets the batch size that specifies the amount of data in each batch update. The batch size is measured as the number of fields.- Parameters:
size
- a batch size value- Since:
- 3.0
-
getMaxColumnNameLength
public int getMaxColumnNameLength()Returns the maximum length allowed for column names.- Returns:
- maximum column name length
- Since:
- 3.0
-
setMaxColumnNameLength
public void setMaxColumnNameLength(int i) Sets the maximum length allowed for database column names.- Parameters:
i
- maximum column name length- Since:
- 3.0
-
getTableTypes
- Returns:
- clone of tableTypes
- Since:
- 3.0
-
setTableTypes
- Parameters:
types
- types- Since:
- 3.0
-
supportsCatalogs
public boolean supportsCatalogs()Tells if the catalog level is supported in metadata.- Returns:
true
if the catalog level is supported, false otherwise- Since:
- 3.0
- See Also:
-
setSupportsCatalogs
public void setSupportsCatalogs(boolean b) Sets if the catalog level is supported in metadata.- Parameters:
b
-true
if the catalog level is supported, false otherwise- Since:
- 3.0
- See Also:
-
supportsSchemas
public boolean supportsSchemas()Tells if the schema level is supported in metadata.- Returns:
true
if the schema level is supported, false otherwise- Since:
- 3.0
- See Also:
-
setSupportsSchemas
public void setSupportsSchemas(boolean b) Sets if the schema level is supported in metadata.- Parameters:
b
-true
if the catalog level is supported, false otherwise- Since:
- 3.0
- See Also:
-
supportsProcedures
public boolean supportsProcedures()Tells if procedures are supported in metadata.- Returns:
true
if procedures are supported, false otherwise- Since:
- 3.0
- See Also:
-
setSupportsProcedures
public void setSupportsProcedures(boolean b) Sets if procedures are supported in metadata.- Parameters:
b
-true
if procedures are supported, false otherwise- Since:
- 3.0
- See Also:
-
supportsDistinct
public boolean supportsDistinct()Tells if the DISTINCT keyword is supported in SQL queries.- Returns:
true
if DISTINCT is supported, false otherwise- Since:
- 3.0
-
setSupportsDistinct
public void setSupportsDistinct(boolean b) Sets if the DISTINCT keyword is supported in SQL queries.- Parameters:
b
-true
if DISTINCT is supported, false otherwise- Since:
- 3.0
-
supportsOrderBy
public boolean supportsOrderBy()Tells if the ORDER BY clause is supported in SQL queries.- Returns:
true
if ORDER BY is supported, false otherwise- Since:
- 3.0
-
setSupportsOrderBy
public void setSupportsOrderBy(boolean b) Sets if the ORDER BY keyword is supported in SQL queries.- Parameters:
b
-true
if ORDER BY is supported, false otherwise- Since:
- 3.0
-
getProcedureTableJDBCType
public int getProcedureTableJDBCType()Returns the JDBC type for procedure tables.- Returns:
- a JDBC type
- Since:
- 3.0
-
setProcedureTableJDBCType
public void setProcedureTableJDBCType(int type) Sets the JDBC type for procedure tables.- Parameters:
type
- a JDBC type- Since:
- 3.0
-
getProcedureTableTypeName
Returns the type name for procedure tables.- Returns:
- a type name
- Since:
- 3.0
-
setProcedureTableTypeName
Sets the type name for procedure tables.- Parameters:
typeName
- a type name- Since:
- 3.0
-
getColumnNamePattern
Returns the pattern used to format a column name in an SQL query.The name is represented by the tag
$$name$$
.- Returns:
- a column name pattern
String
- Since:
- 3.0
- See Also:
-
setColumnNamePattern
Sets the pattern used to format a column name in an SQL query.The name is represented by the tag
$$name$$
.- Parameters:
p
- a column name patternString
- Since:
- 3.0
- See Also:
-
getTableNamePattern
Returns the pattern used to format a table name in an SQL query.The name is represented by the tag
$$name$$
.- Returns:
- a table name pattern
String
- Since:
- 3.0
- See Also:
-
setTableNamePattern
Sets the pattern used to format a table name in an SQL query.The name is represented by the tag
$$name$$
.- Parameters:
p
- a table name patternString
- Since:
- 3.0
- See Also:
-
getProcedureNamePattern
Returns the pattern used to format a procedure name in an SQL query.The name is represented by the tag
$$name$$
.- Returns:
- a procedure name pattern
String
- Since:
- 3.0
-
setProcedureNamePattern
Sets the pattern used to format a procedure name in an SQL query.The name is represented by the tag
$$name$$
.- Parameters:
p
- a procedure name patternString
- Since:
- 3.0
-
getSchemaNamePattern
Returns the pattern used to format a schema name in an SQL query.The name is represented by the tag
$$name$$
.- Returns:
- a schema name pattern
String
- Since:
- 3.0
- See Also:
-
setSchemaNamePattern
Sets the pattern used to format a schema name in an SQL query.The name is represented by the tag
$$name$$
.- Parameters:
p
- a schema name patternString
- Since:
- 3.0
- See Also:
-
getCatalogNamePattern
Returns the pattern used to format a catalog name in an SQL query.The name is represented by the tag
$$name$$
.- Returns:
- a catalog name pattern
String
- Since:
- 3.0
- See Also:
-
setCatalogNamePattern
Sets the pattern used to format a catalog name in an SQL query.The name is represented by the tag
$$name$$
.- Parameters:
p
- a catalog name patternString
- Since:
- 3.0
- See Also:
-
getColumnAliasPattern
Returns the pattern used to format a column alias in an SQL query.The name is represented by the tag
$$name$$
.- Returns:
- a column alias pattern
String
- Since:
- 3.0
- See Also:
-
setColumnAliasPattern
Sets the pattern used to format a column alias in an SQL query.The alias is represented by the tag
$$name$$
.- Parameters:
p
- a column alias patternString
- Since:
- 3.0
- See Also:
-
getStringLiteralQuote
Returns The character used as quote for string literals.- Returns:
- a string literal quote
String
- Since:
- 3.0
- See Also:
-
setStringLiteralQuote
Sets The character used as quote for string literals.- Parameters:
s
- a string literal quoteString
- Since:
- 3.0
- See Also:
-
getMinInClauseSize
public int getMinInClauseSize()Returns the minimum number of values for creating a SQL IN-clause. For fewer values, each value will have its own condition.- Returns:
- minimum IN clause size
- Since:
- 3.0
-
setMinInClauseSize
public void setMinInClauseSize(int i) Sets the minimum number of values for creating a SQL IN-clause. For fewer values, each value will have its own condition.- Parameters:
i
- minimum IN clause size- Since:
- 3.0
-
getMaxInClauseSize
public int getMaxInClauseSize()Returns the maximum size of an SQL IN-clause. Larger lists are split into several clauses that are OR:ed together.- Returns:
- maximum IN clause size
- Since:
- 3.0
-
setMaxInClauseSize
public void setMaxInClauseSize(int i) Size the maximum size of an SQL IN-clause. Larger lists are split into several clauses that are OR:ed together.- Parameters:
i
- maximum IN clause size- Since:
- 3.0
-
getConditionListThreshold
public int getConditionListThreshold()Return the condition list threshold. A temporary table is used when executing an SQL query, where total size of a condition list is larger than this threshold value.- Returns:
- a condition list threshold value
- Since:
- 3.0
-
setConditionListThreshold
public void setConditionListThreshold(int i) Sets the condition list threshold. A temporary table is used when executing an SQL query, where total size of a condition list is larger than this threshold value.- Parameters:
i
- a condition list threshold value- Since:
- 3.0
-
getExpandInClause
public boolean getExpandInClause()Tells if an SQL IN-clause shall be expanded into OR conditions.- Returns:
true
if IN-clauses shall be expanded,false
otherwise- Since:
- 3.0
-
setExpandInClause
public void setExpandInClause(boolean b) Sets if an SQL IN-clause shall be expanded into OR conditions.- Parameters:
b
-true
if IN-clauses shall be expanded,false
otherwise- Since:
- 3.0
-
getTableExpressionPattern
Return the pattern that determines how a table expression is written in the SQL query.The following tags are used as placeholders for the catalog, schema and table name:
$$catalog$$
,$$schema$$
and$$table$$
.Optional parts are surrounded by brackets (
[
and]
).- Returns:
- a table expression pattern
String
- Since:
- 3.0
- See Also:
-
setTableExpressionPattern
Sets the pattern that determines how a table expression is written in the SQL query.The following tags are used as placeholders for the catalog, schema and table name:
$$catalog$$
,$$schema$$
and$$table$$
.Optional parts are surrounded by brackets (
[
and]
).- Parameters:
s
- a table expression patternString
- Since:
- 3.0
- See Also:
-
getProcedureExpressionPattern
Return the pattern that determines how a procedure expression is written in the SQL query.The following tags are used as placeholders for the catalog, schema and procedure name:
$$catalog$$
,$$schema$$
and$$procedure$$
.Optional parts are surrounded by brackets (
[
and]
).- Returns:
- a procedure expression pattern
String
- Since:
- 3.0
- See Also:
-
setProcedureExpressionPattern
Sets the pattern that determines how a procedure expression is written in the SQL query.The following tags are used as placeholders for the catalog, schema and table name:
$$catalog$$
,$$schema$$
and$$procedure$$
.Optional parts are surrounded by brackets (
[
and]
).- Parameters:
s
- a procedure expression patternString
- Since:
- 3.0
- See Also:
-
getDateFormatExpression
Returns an expression that converts a date field to a string value on the format:"YYYY-MM-DD", e.g. "2002-11-19".The expression contains a
$$value$$
tag that is a placeholder for a date field.- Returns:
- an expression
String
- Since:
- 3.0
- See Also:
-
setDateFormatExpression
Sets an expression that converts a date field to a string value on the format:"YYYY-MM-DD", e.g. "2002-11-19".The expression must contain a
$$value$$
tag that is a placeholder for a date field.- Parameters:
s
- an expressionString
- Since:
- 3.0
- See Also:
-
getTimeFormatExpression
Returns an expression that converts a time field to a string value on the format:"HH:MM:SS", e.g. "14:59:00".The expression contains a
$$value$$
tag that is a placeholder for a date field.- Returns:
- an expression
String
- Since:
- 3.0
- See Also:
-
setTimeFormatExpression
Sets an expression that converts a time field to a string value on the format:"HH:MM:SS", e.g. "14:59:00".The expression must contain a
$$value$$
tag that is a placeholder for a date field.- Parameters:
s
- an expressionString
- Since:
- 3.0
- See Also:
-
getDateTimeFormatExpression
Returns an expression that converts a datetime field to string value on the format: "YYYY-MM-DD HH:MM:SS", e.g. "2002-11-19 14:59:00".The expression contains a
$$value$$
tag that is a placeholder for a date field.- Returns:
- an expression
String
- Since:
- 3.0
- See Also:
-
setDateTimeFormatExpression
Sets an expression that converts a datetime field to string value on the format: "YYYY-MM-DD HH:MM:SS", e.g. "2002-11-19 14:59:00".The expression must contain a
$$value$$
tag that is a placeholder for a date field.- Parameters:
s
- an expressionString
- Since:
- 3.0
- See Also:
-
getDateLiteralFormatExpression
Returns an expression that converts a date literal to a database date value. The date literal is on the format "YYYY-MM-DD", e.g. "2002-11-19".The expression contains a
$$value$$
tag that is a placeholder for a date literal.- Returns:
- an expression
String
- Since:
- 3.0
- See Also:
-
setDateLiteralFormatExpression
Sets an expression that converts a date literal to a database date value. The date literal is on the format: "YYYY-MM-DD", e.g. "2002-11-19".The expression must contain a
$$value$$
tag that is a placeholder for a date literal.- Parameters:
s
- an expressionString
- Since:
- 3.0
- See Also:
-
getTimeLiteralFormatExpression
Returns an expression that converts a time literal to a database time value. The time literal is on the format:"HH:MM:SS", e.g. "14:59:00".The expression contains a
$$value$$
tag that is a placeholder for a date literal.- Returns:
- an expression
String
- Since:
- 3.0
- See Also:
-
setTimeLiteralFormatExpression
Sets an expression that converts a time literal to a database time value. The time literal is on the format:"HH:MM:SS", e.g. "14:59:00".The expression must contain a
$$value$$
tag that is a placeholder for a date literal.- Parameters:
s
- an expressionString
- Since:
- 3.0
- See Also:
-
getDateTimeLiteralFormatExpression
Returns an expression that converts a datetime literal to a database datetime value. The datetime literal is on the format: "YYYY-MM-DD HH:MM:SS", e.g. "2002-11-19 14:59:00".The expression contains a
$$value$$
tag that is a placeholder for a date literal.- Returns:
- an expression
String
- Since:
- 3.0
- See Also:
-
setDateTimeLiteralFormatExpression
Sets an expression that converts a datetime literal to a database datetime value. The datetime literal is on the format: "YYYY-MM-DD HH:MM:SS", e.g. "2002-11-19 14:59:00".The expression must contain a
$$value$$
tag that is a placeholder for a date literal.- Parameters:
s
- an expressionString
- Since:
- 3.0
- See Also:
-
getSQLType
Returns the SQL type for a given Java type.- Parameters:
javaType
- a Java type- Returns:
- a SQL type
- Since:
- 3.0
- See Also:
-
getSQLType
Returns the SQL type for a given Java type. If a positive length argument is specified, the method returns the type mapping with the smallest max-length that is larger than length. If a zero-length is specified, the method returns the first type-mapping in the list where max-length = -1, or if there is no such type-mapping with max-length = -1, then it returns the type mapping with largest max-length.- Parameters:
javaType
- a Java typelength
- the length whentype
isString
- Returns:
- a SQL type
- Since:
- 3.0
- See Also:
-
getTypeMappings
Returns all Java to SQL type mappings.- Returns:
- a
TypeMapping
array - Since:
- 3.0
- See Also:
-
setTypeMappings
Sets all Java to SQL type mappings.- Parameters:
t
- aTypeMapping
array- Since:
- 3.0
- See Also:
-
setAlwaysUsePreparedStatement
public void setAlwaysUsePreparedStatement(boolean alwaysUsePreparedStatement) Indicates if prepared statement should be used even when no parameters are set.- Parameters:
alwaysUsePreparedStatement
- the alwaysUsePreparedStatement to set- Since:
- 3.0
-
getAlwaysUsePreparedStatement
public boolean getAlwaysUsePreparedStatement()Indicates if prepared statement should be used even when no parameters are set.- Returns:
- true if prepared statement should be used, false if not.
- Since:
- 3.0
-
addTypeMapping
Add a Java to SQL type mapping.- Parameters:
t
- aTypeMapping
object- Since:
- 3.0
- See Also:
-
getSQLAggregateFuntion
Get the SQL aggregate function for the given DAT aggregate function, or null if no such SQL function exists.- Parameters:
datAggregateFuntion
- a DAT aggregate function.- Returns:
- an SQL aggregate function.
- Since:
- 3.0
-
getTempTableNamePattern
Returns the pattern used to format a temporary table name in an SQL command.The name is represented by the tag
$$name$$
.- Returns:
- a table name pattern
String
- Since:
- 3.0
- See Also:
-
setTempTableNamePattern
Sets the pattern used to format a temporary table name in an SQL command.The name is represented by the tag
$$name$$
.- Parameters:
p
- a table name patternString
- Since:
- 3.0
- See Also:
-
getCreateTempTableCommands
Returns the SQL commands needed for creating a temporary table that is used to store filter values (when more than 'condition-list-threshold') and to store result from subqueries.The
$$name$$
tag is a placeholder for the table name. The$$column_list$$
tag is a placeholder for a column list on the format "(name type, name type, ...)"- Returns:
- a command
String
array - Since:
- 3.0
- See Also:
-
setCreateTempTableCommands
Sets the SQL commands needed for creating a temporary table that is used to store filter values (when more than 'condition-list-threshold') and to store result from subqueries.The
$$name$$
tag is a placeholder for the table name. The$$column_list$$
tag is a placeholder for a column list on the format "(name type, name type, ...)"- Parameters:
s
- a commandString
array- Since:
- 3.0
- See Also:
-
getDropTempTableCommands
Returns the SQL commands for deleting a temporary table.The
$$name$$
tag is a placeholder for the table name.- Returns:
- a command
String
array - Since:
- 3.0
- See Also:
-
setDropTempTableCommands
Sets the SQL commands for deleting a temporary table.The
$$name$$
tag is a placeholder for the table name.- Parameters:
s
- a commandString
array- Since:
- 3.0
- See Also:
-
getLobThreshold
public int getLobThreshold()Returns the threshold value when LOB values used as parameters in a WHERE clause, must be written in temporary tables.- Returns:
- a threshold value, -1 means no limit
- Since:
- 3.0
-
setLobThreshold
public void setLobThreshold(int i) Sets the threshold value when LOB values used as parameters in a WHERE clause, must be written in temporary tables.- Parameters:
i
- a threshold value, -1 means no limit- Since:
- 3.0
-
isAnsiiStyleOuterJoin
public boolean isAnsiiStyleOuterJoin()Returns if an attempt should be done to go from oracle outer join syntax with '(+)' to ANSI form If useAnsiJoin() is true, then this setting has no effect.- Returns:
- if we should rewrite
- Since:
- 3.0
-
setAnsiiStyleOuterJoin
public void setAnsiiStyleOuterJoin(boolean outerJoin) Set if an attempt should be done to go from oracle outer join syntax with '(+)' to ANSI form If useAnsiJoin() is true, then this setting has no effect.- Parameters:
outerJoin
- if rewrite should take place- Since:
- 3.0
-
isAnsiJoin
public boolean isAnsiJoin()Returns if an attempt should be made to create ansi join syntax.- Returns:
- true if attempts should be made to create ansi join syntax, false if not.
- Since:
- 7.5
-
setAnsiJoin
public void setAnsiJoin(boolean useAnsiJoin) Set if an attempt should be made to create ansi join syntax.- Parameters:
useAnsiJoin
- if set to true attempts should be made to create ansi join syntax, if false no attempt to rewrite inner joins will be made and outer joins depend on value for isAnsiiStyleOuterJoin().- Since:
- 7.5
-
getConnectionProperties
Returns the connection properties used when creating a new connection to the database.- Returns:
- a
Properties
value - Since:
- 3.0
-
setConnectionProperties
Sets the connection properties used when creating a new connection to the database.- Parameters:
connectionProperties
- the connection properties- Since:
- 3.0
-
getCredentialsTimeout
public int getCredentialsTimeout()Gets the credentials timeout for a JDBC data source. The timeout is given in seconds.- Returns:
- the credentials timeout, in seconds, for a JDBC data source.
- Since:
- 3.2
-
setCredentialsTimeout
public void setCredentialsTimeout(int credentialsTimeout) Sets the credentials timeout for a JDBC data source. The timeout is stated in seconds.- Parameters:
credentialsTimeout
- the credentials timeout, in seconds, for a JDBC data source- Since:
- 3.2
-
setAutocommit
public void setAutocommit(boolean autocommit) Sets the auto commit mode for connection on the data source.- Parameters:
autocommit
- false means autocommit is not set, true means autocommit is set if supported.- Since:
- 3.2
-
getAutocommit
public boolean getAutocommit()Get autocommit mode.- Returns:
- true if autocommit mode is set, false otherwise.
- Since:
- 3.2
-
getUseGetSchemas
public boolean getUseGetSchemas()Get useGetSchemas.- Returns:
- Indicates whether to use getSchemas function or not, while fetching schemas from the catalog.
-
setUseGetSchemas
public void setUseGetSchemas(boolean useGetSchemas) Set Sets useGetSchemas which specifies if jdbc GetSchemas method should be used. It will increase the performance, when a user clicks on a catalog to view it's schemas, however, it will show all the schemas, irrespective whether schemas contain tables/procedures or not..- Parameters:
useGetSchemas
- If set to true, getSchemas function is used while fetching schemas from the catalog, it is only applicable when the jdbc version is 4.1 or higher.
-
toString
Return a string showing the values of all the members.
-