public class JDBCTypeSettings
extends java.lang.Object
Settings for a JDBC data source type.
The settings are loaded from the file <ds_server_dir>/spotfire/spotfire/WEB-INF/settings-ws.xml, with category = 'spotfire.iis.jdbc' and name = 'type-settings'.
Modifier and Type | Class and Description |
---|---|
static class |
JDBCTypeSettings.TypeMapping
Mapping between a Java and a SQL type.
|
Constructor and Description |
---|
JDBCTypeSettings()
Creates a new
JDBCTypeSettings instance. |
Modifier and Type | Method and Description |
---|---|
void |
addTypeMapping(JDBCTypeSettings.TypeMapping t)
Add a Java to SQL type mapping.
|
com.spotfire.ws.api.common.DataSourceType |
convertToExternal() |
Element |
formatXML(Element e)
Generates an XML description of this object.
|
static JDBCTypeSettings[] |
getAllTypeSettings()
Returns all
JDBCTypeSettings instances that are currently
enabled. |
boolean |
getAlwaysUsePreparedStatement()
Indicates if prepared statement should be used even when no parameters are
set.
|
boolean |
getAutocommit()
Get autocommit mode.
|
int |
getBatchSize()
Returns the batch size that specifies the amount of data in each batch
update.
|
java.lang.String |
getCatalogNamePattern()
Returns the pattern used to format a catalog name in an SQL query.
|
java.lang.String |
getColumnAliasPattern()
Returns the pattern used to format a column alias in an SQL query.
|
java.lang.String |
getColumnNamePattern()
Returns the pattern used to format a column name in an SQL query.
|
int |
getConditionListThreshold()
Return the condition list threshold.
|
java.util.Properties |
getConnectionProperties()
Returns the connection properties used when creating a new connection to
the database.
|
java.lang.String[] |
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.
|
int |
getCredentialsTimeout()
Gets the credentials timeout for a JDBC data source.
|
java.lang.String |
getDateFormatExpression()
Returns an expression that converts a date field to a string value on the
format:"YYYY-MM-DD", e.g.
|
java.lang.String |
getDateLiteralFormatExpression()
Returns an expression that converts a date literal to a database date
value.
|
java.lang.String |
getDateTimeFormatExpression()
Returns an expression that converts a datetime field to string value on the
format: "YYYY-MM-DD HH:MM:SS", e.g.
|
java.lang.String |
getDateTimeLiteralFormatExpression()
Returns an expression that converts a datetime literal to a database
datetime value.
|
java.lang.String |
getDisplayName()
Returns the name of the JDBC type to be displayed in a UI.
|
java.lang.String |
getDriverClass()
Returns the JDBC driver class.
|
java.lang.String[] |
getDropTempTableCommands()
Returns the SQL commands for deleting a temporary table.
|
boolean |
getExpandInClause()
Tells if an SQL IN-clause shall be expanded into OR conditions.
|
int |
getFetchSize()
Returns the fetch size that specifies the amount of data fetched with each
database round trip for a query.
|
int |
getLobThreshold()
Returns the threshold value when LOB values used as parameters in a WHERE
clause, must be written in temporary tables.
|
int |
getMaxColumnNameLength()
Returns the maximum length allowed for column names.
|
int |
getMaxInClauseSize()
Returns the maximum size of an SQL IN-clause.
|
java.lang.Class |
getMetadataProviderClass()
Returns the
JDBCMetadataProvider class. |
int |
getMinInClauseSize()
Returns the minimum number of values for creating a SQL IN-clause.
|
java.lang.String |
getPingCommand()
Returns the ping command used to verify a JDBC connection.
|
java.lang.String |
getProcedureExpressionPattern()
Return the pattern that determines how a procedure expression is written in
the SQL query.
|
java.lang.String |
getProcedureNamePattern()
Returns the pattern used to format a procedure name in an SQL query.
|
int |
getProcedureTableJDBCType()
Returns the JDBC type for procedure tables.
|
java.lang.String |
getProcedureTableTypeName()
Returns the type name for procedure tables.
|
java.lang.Class |
getQueryBuilderClass()
Returns the query builder class.
|
java.lang.String |
getSchemaNamePattern()
Returns the pattern used to format a schema name in an SQL query.
|
java.lang.String |
getSQLAggregateFuntion(java.lang.String datAggregateFuntion)
Get the SQL aggregate function for the given DAT aggregate function, or
null if no such SQL function exists.
|
java.lang.Class |
getSQLFilterClass()
Returns the
SQLFilter class. |
java.lang.Class |
getSQLRuntimeClass()
Returns the
SQLRuntime class. |
java.lang.String |
getSQLType(java.lang.Class javaType)
Returns the SQL type for a given Java type.
|
java.lang.String |
getSQLType(java.lang.Class javaType,
int length)
Returns the SQL type for a given Java type.
|
java.lang.String |
getStringLiteralQuote()
Returns The character used as quote for string literals.
|
java.lang.String |
getTableExpressionPattern()
Return the pattern that determines how a table expression is written in the
SQL query.
|
java.lang.String |
getTableNamePattern()
Returns the pattern used to format a table name in an SQL query.
|
java.lang.String[] |
getTableTypes() |
java.lang.String |
getTempTableNamePattern()
Returns the pattern used to format a temporary table name in an SQL
command.
|
java.lang.String |
getTimeFormatExpression()
Returns an expression that converts a time field to a string value on the
format:"HH:MM:SS", e.g.
|
java.lang.String |
getTimeLiteralFormatExpression()
Returns an expression that converts a time literal to a database time
value.
|
JDBCTypeSettings.TypeMapping[] |
getTypeMappings()
Returns all Java to SQL type mappings.
|
java.lang.String |
getTypeName()
Returns the name of the JDBC type.
|
static JDBCTypeSettings |
getTypeSettings(java.lang.String typeName)
Returns the
JDBCTypeSettings for a specified type name. |
java.lang.String |
getURLPattern()
Returns the URL pattern.
|
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.
|
boolean |
isAnsiJoin()
Returns if an attempt should be made to create ansi join syntax.
|
void |
parseXML(Element e)
Initializes this object from the XML description.
|
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 |
setCatalogNamePattern(java.lang.String p)
Sets the pattern used to format a catalog name in an SQL query.
|
void |
setColumnAliasPattern(java.lang.String p)
Sets the pattern used to format a column alias in an SQL query.
|
void |
setColumnNamePattern(java.lang.String p)
Sets the pattern used to format a column name in an SQL query.
|
void |
setConditionListThreshold(int i)
Sets the condition list threshold.
|
void |
setConnectionProperties(java.util.Properties connectionProperties)
Sets the connection properties used when creating a new connection to the
database.
|
void |
setCreateTempTableCommands(java.lang.String[] s)
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 |
setDateFormatExpression(java.lang.String s)
Sets an expression that converts a date field to a string value on the
format:"YYYY-MM-DD", e.g.
|
void |
setDateLiteralFormatExpression(java.lang.String s)
Sets an expression that converts a date literal to a database date value.
|
void |
setDateTimeFormatExpression(java.lang.String s)
Sets an expression that converts a datetime field to string value on the
format: "YYYY-MM-DD HH:MM:SS", e.g.
|
void |
setDateTimeLiteralFormatExpression(java.lang.String s)
Sets an expression that converts a datetime literal to a database datetime
value.
|
void |
setDisplayName(java.lang.String name)
Deprecated.
This method is deprecated and will be removed without replacement in a future release.
|
void |
setDriverClass(java.lang.String c)
Sets the JDBC driver class.
|
void |
setDropTempTableCommands(java.lang.String[] s)
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 |
setMetadataProviderClass(java.lang.Class c)
Sets the
JDBCMetadataProvider class. |
void |
setMinInClauseSize(int i)
Sets the minimum number of values for creating a SQL IN-clause.
|
void |
setPingCommand(java.lang.String s)
Sets the ping command used to verify a JDBC connection.
|
void |
setProcedureExpressionPattern(java.lang.String s)
Sets the pattern that determines how a procedure expression is written in
the SQL query.
|
void |
setProcedureNamePattern(java.lang.String p)
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(java.lang.String typeName)
Sets the type name for procedure tables.
|
void |
setSchemaNamePattern(java.lang.String p)
Sets the pattern used to format a schema name in an SQL query.
|
void |
setSQLFilterClass(java.lang.Class c)
Sets the
SQLFilter class. |
void |
setSQLRuntimeClass(java.lang.Class c)
Sets the
SQLRuntime class. |
void |
setStringLiteralQuote(java.lang.String s)
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 |
setTableExpressionPattern(java.lang.String s)
Sets the pattern that determines how a table expression is written in the
SQL query.
|
void |
setTableNamePattern(java.lang.String p)
Sets the pattern used to format a table name in an SQL query.
|
void |
setTableTypes(java.lang.String[] types) |
void |
setTempTableNamePattern(java.lang.String p)
Sets the pattern used to format a temporary table name in an SQL command.
|
void |
setTimeFormatExpression(java.lang.String s)
Sets an expression that converts a time field to a string value on the
format:"HH:MM:SS", e.g.
|
void |
setTimeLiteralFormatExpression(java.lang.String s)
Sets an expression that converts a time literal to a database time value.
|
void |
setTypeMappings(JDBCTypeSettings.TypeMapping[] t)
Sets all Java to SQL type mappings.
|
void |
setTypeName(java.lang.String name)
Sets the name of the JDBC type.
|
void |
setURLPattern(java.lang.String s)
Sets the URL pattern.
|
boolean |
supportsCatalogs()
Tells if the catalog level is supported in metadata.
|
boolean |
supportsDistinct()
Tells if the DISTINCT keyword is supported in SQL queries.
|
boolean |
supportsOrderBy()
Tells if the ORDER BY clause is supported in SQL queries.
|
boolean |
supportsProcedures()
Tells if procedures are supported in metadata.
|
boolean |
supportsSchemas()
Tells if the schema level is supported in metadata.
|
public JDBCTypeSettings()
JDBCTypeSettings
instance.public static JDBCTypeSettings getTypeSettings(java.lang.String typeName)
JDBCTypeSettings
for a specified type name.typeName
- a type nameJDBCTypeSettings
instancepublic static JDBCTypeSettings[] getAllTypeSettings()
JDBCTypeSettings
instances that are currently
enabled.JDBCTypeSettings
instancespublic java.lang.String getTypeName()
public void setTypeName(java.lang.String name)
name
- a type namepublic java.lang.String getDisplayName()
@Deprecated public void setDisplayName(java.lang.String name)
name
- a display namepublic java.lang.String getDriverClass()
public void setDriverClass(java.lang.String c)
c
- a class namepublic java.lang.String getURLPattern()
String
public void setURLPattern(java.lang.String s)
s
- a URL pattern String
public java.lang.String getPingCommand()
String
public void setPingCommand(java.lang.String s)
s
- a ping command String
public java.lang.Class getMetadataProviderClass()
JDBCMetadataProvider
class.Class
derived from JDBCMetadataProvider
JDBCMetadataProvider
public void setMetadataProviderClass(java.lang.Class c)
JDBCMetadataProvider
class.c
- a Class
derived from
JDBCMetadataProvider
JDBCMetadataProvider
public java.lang.Class getSQLFilterClass()
SQLFilter
class.Class
derived from SQLFilter
SQLFilter
public void setSQLFilterClass(java.lang.Class c)
SQLFilter
class.c
- a Class
derived from SQLFilter
SQLFilter
public java.lang.Class getSQLRuntimeClass()
SQLRuntime
class.Class
derived from SQLRuntime
SQLRuntime
public void setSQLRuntimeClass(java.lang.Class c)
SQLRuntime
class.c
- a Class
derived from SQLRuntime
SQLRuntime
public java.lang.Class getQueryBuilderClass()
SQLBuilder
.Class
for building queries.public int getFetchSize()
public void setFetchSize(int size)
size
- a fetch size valuepublic int getBatchSize()
public void setBatchSize(int size)
size
- a batch size valuepublic int getMaxColumnNameLength()
public void setMaxColumnNameLength(int i)
i
- maximum column name lengthpublic java.lang.String[] getTableTypes()
public void setTableTypes(java.lang.String[] types)
types
- typespublic boolean supportsCatalogs()
true
if the catalog level is supported, false
otherwiseJDBCMetadataProvider
public void setSupportsCatalogs(boolean b)
b
- true
if the catalog level is supported, false
otherwiseJDBCMetadataProvider
public boolean supportsSchemas()
true
if the schema level is supported, false otherwiseJDBCMetadataProvider
public void setSupportsSchemas(boolean b)
b
- true
if the catalog level is supported, false
otherwiseJDBCMetadataProvider
public boolean supportsProcedures()
true
if procedures are supported, false otherwiseJDBCMetadataProvider
public void setSupportsProcedures(boolean b)
b
- true
if procedures are supported, false otherwiseJDBCMetadataProvider
public boolean supportsDistinct()
true
if DISTINCT is supported, false otherwisepublic void setSupportsDistinct(boolean b)
b
- true
if DISTINCT is supported, false otherwisepublic boolean supportsOrderBy()
true
if ORDER BY is supported, false otherwisepublic void setSupportsOrderBy(boolean b)
b
- true
if ORDER BY is supported, false otherwisepublic int getProcedureTableJDBCType()
public void setProcedureTableJDBCType(int type)
type
- a JDBC typepublic java.lang.String getProcedureTableTypeName()
public void setProcedureTableTypeName(java.lang.String typeName)
typeName
- a type namepublic java.lang.String getColumnNamePattern()
The name is represented by the tag $$name$$
.
String
SQLFilter.formatColumnName(java.lang.String)
public void setColumnNamePattern(java.lang.String p)
The name is represented by the tag $$name$$
.
p
- a column name pattern String
SQLFilter.formatColumnName(java.lang.String)
public java.lang.String getTableNamePattern()
The name is represented by the tag $$name$$
.
String
SQLFilter.formatTableName(java.lang.String)
public void setTableNamePattern(java.lang.String p)
The name is represented by the tag $$name$$
.
p
- a table name pattern String
SQLFilter.formatTableName(java.lang.String)
public java.lang.String getProcedureNamePattern()
The name is represented by the tag $$name$$
.
String
public void setProcedureNamePattern(java.lang.String p)
The name is represented by the tag $$name$$
.
p
- a procedure name pattern String
public java.lang.String getSchemaNamePattern()
The name is represented by the tag $$name$$
.
String
SQLFilter.formatSchemaName(java.lang.String)
public void setSchemaNamePattern(java.lang.String p)
The name is represented by the tag $$name$$
.
p
- a schema name pattern String
SQLFilter.formatSchemaName(java.lang.String)
public java.lang.String getCatalogNamePattern()
The name is represented by the tag $$name$$
.
String
SQLFilter.formatCatalogName(java.lang.String)
public void setCatalogNamePattern(java.lang.String p)
The name is represented by the tag $$name$$
.
p
- a catalog name pattern String
SQLFilter.formatCatalogName(java.lang.String)
public java.lang.String getColumnAliasPattern()
The name is represented by the tag $$name$$
.
String
SQLFilter.formatColumnAlias(java.lang.String)
public void setColumnAliasPattern(java.lang.String p)
The alias is represented by the tag $$name$$
.
p
- a column alias pattern String
SQLFilter.formatColumnAlias(java.lang.String)
public java.lang.String getStringLiteralQuote()
String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public void setStringLiteralQuote(java.lang.String s)
s
- a string literal quote String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public int getMinInClauseSize()
public void setMinInClauseSize(int i)
i
- minimum IN clause sizepublic int getMaxInClauseSize()
public void setMaxInClauseSize(int i)
i
- maximum IN clause sizepublic int getConditionListThreshold()
public void setConditionListThreshold(int i)
i
- a condition list threshold valuepublic boolean getExpandInClause()
true
if IN-clauses shall be expanded,
false
otherwisepublic void setExpandInClause(boolean b)
b
- true
if IN-clauses shall be expanded,
false
otherwisepublic java.lang.String getTableExpressionPattern()
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
]
).
String
SQLFilter.formatTable(java.lang.String, java.lang.String, java.lang.String)
public void setTableExpressionPattern(java.lang.String s)
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
]
).
s
- a table expression pattern String
SQLFilter.formatTable(java.lang.String, java.lang.String, java.lang.String)
public java.lang.String getProcedureExpressionPattern()
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
]
).
String
SQLFilter.formatProcedure(java.lang.String, java.lang.String, java.lang.String)
public void setProcedureExpressionPattern(java.lang.String s)
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
]
).
s
- a procedure expression pattern String
SQLFilter.formatProcedure(java.lang.String, java.lang.String, java.lang.String)
public java.lang.String getDateFormatExpression()
The expression contains a $$value$$
tag that is a placeholder
for a date field.
String
SQLFilter.formatConditionExpression(java.lang.String, java.lang.Class)
public void setDateFormatExpression(java.lang.String s)
The expression must contain a $$value$$
tag that is a
placeholder for a date field.
s
- an expression String
SQLFilter.formatConditionExpression(java.lang.String, java.lang.Class)
public java.lang.String getTimeFormatExpression()
The expression contains a $$value$$
tag that is a placeholder
for a date field.
String
SQLFilter.formatConditionExpression(java.lang.String, java.lang.Class)
public void setTimeFormatExpression(java.lang.String s)
The expression must contain a $$value$$
tag that is a
placeholder for a date field.
s
- an expression String
SQLFilter.formatConditionExpression(java.lang.String, java.lang.Class)
public java.lang.String getDateTimeFormatExpression()
The expression contains a $$value$$
tag that is a placeholder
for a date field.
String
SQLFilter.formatConditionExpression(java.lang.String, java.lang.Class)
public void setDateTimeFormatExpression(java.lang.String s)
The expression must contain a $$value$$
tag that is a
placeholder for a date field.
s
- an expression String
SQLFilter.formatConditionExpression(java.lang.String, java.lang.Class)
public java.lang.String getDateLiteralFormatExpression()
The expression contains a $$value$$
tag that is a placeholder
for a date literal.
String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public void setDateLiteralFormatExpression(java.lang.String s)
The expression must contain a $$value$$
tag that is a
placeholder for a date literal.
s
- an expression String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public java.lang.String getTimeLiteralFormatExpression()
The expression contains a $$value$$
tag that is a placeholder
for a date literal.
String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public void setTimeLiteralFormatExpression(java.lang.String s)
The expression must contain a $$value$$
tag that is a
placeholder for a date literal.
s
- an expression String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public java.lang.String getDateTimeLiteralFormatExpression()
The expression contains a $$value$$
tag that is a placeholder
for a date literal.
String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public void setDateTimeLiteralFormatExpression(java.lang.String s)
The expression must contain a $$value$$
tag that is a
placeholder for a date literal.
s
- an expression String
SQLFilter.formatLiteral(java.lang.String, java.lang.Class)
public java.lang.String getSQLType(java.lang.Class javaType)
javaType
- a Java typeSQLFilter.getSQLType(java.lang.Class, int)
,
JDBCTypeSettings.TypeMapping
public java.lang.String getSQLType(java.lang.Class javaType, int length)
javaType
- a Java typelength
- the length when type
is String
SQLFilter.getSQLType(java.lang.Class, int)
,
JDBCTypeSettings.TypeMapping
public JDBCTypeSettings.TypeMapping[] getTypeMappings()
TypeMapping
arrayJDBCTypeSettings.getSQLType(Class)
public void setTypeMappings(JDBCTypeSettings.TypeMapping[] t)
t
- a TypeMapping
arrayJDBCTypeSettings.getSQLType(Class)
public void setAlwaysUsePreparedStatement(boolean alwaysUsePreparedStatement)
alwaysUsePreparedStatement
- the alwaysUsePreparedStatement to setpublic boolean getAlwaysUsePreparedStatement()
public void addTypeMapping(JDBCTypeSettings.TypeMapping t)
t
- a TypeMapping
objectJDBCTypeSettings.getSQLType(Class)
public java.lang.String getSQLAggregateFuntion(java.lang.String datAggregateFuntion)
datAggregateFuntion
- a DAT aggregate function.public java.lang.String getTempTableNamePattern()
The name is represented by the tag $$name$$
.
String
SQLFilter.formatCreateTableSQL(java.lang.String, java.lang.String[], java.lang.String[])
public void setTempTableNamePattern(java.lang.String p)
The name is represented by the tag $$name$$
.
p
- a table name pattern String
SQLFilter.formatCreateTableSQL(java.lang.String, java.lang.String[], java.lang.String[])
public java.lang.String[] getCreateTempTableCommands()
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, ...)"
String
arraySQLFilter.formatCreateTableSQL(java.lang.String, java.lang.String[], java.lang.String[])
,
SQLFilter.formatColumnList(java.lang.String[], java.lang.String[])
public void setCreateTempTableCommands(java.lang.String[] s)
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, ...)"
s
- a command String
arraySQLFilter.formatCreateTableSQL(java.lang.String, java.lang.String[], java.lang.String[])
,
SQLFilter.formatColumnList(java.lang.String[], java.lang.String[])
public java.lang.String[] getDropTempTableCommands()
The $$name$$
tag is a placeholder for the table name.
String
arraySQLFilter.formatDropTableSQL(java.lang.String)
public void setDropTempTableCommands(java.lang.String[] s)
The $$name$$
tag is a placeholder for the table name.
s
- a command String
arraySQLFilter.formatDropTableSQL(java.lang.String)
public int getLobThreshold()
public void setLobThreshold(int i)
i
- a threshold value, -1 means no limitpublic boolean isAnsiiStyleOuterJoin()
public void setAnsiiStyleOuterJoin(boolean outerJoin)
outerJoin
- if rewrite should take placepublic boolean isAnsiJoin()
public void setAnsiJoin(boolean useAnsiJoin)
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().public java.util.Properties getConnectionProperties()
Properties
valuepublic void setConnectionProperties(java.util.Properties connectionProperties)
connectionProperties
- the connection propertiespublic int getCredentialsTimeout()
public void setCredentialsTimeout(int credentialsTimeout)
credentialsTimeout
- the credentials timeout, in seconds, for a JDBC data sourcepublic void setAutocommit(boolean autocommit)
autocommit
- false means autocommit is not set, true means autocommit is set if supported.public boolean getAutocommit()
public void parseXML(Element e)
e
- the XML Element
. This parameter is not allowed to be
null
com.spotfire.ws.xml.XMLParseException
- if an error occurspublic Element formatXML(Element e)
e
- the XML Element
. This parameter is not allowed to be
null
Element
com.spotfire.ws.xml.XMLFormatException
- if an error occurspublic com.spotfire.ws.api.common.DataSourceType convertToExternal()
Copyright © 2000-2020 TIBCO Software Inc. All Rights Reserved.