com.ddtek.xquery3.xqj
Class DDXQJDBCConnection

java.lang.Object
  com.ddtek.xquery3.xqj.DDXQJDBCConnection

All Implemented Interfaces:

Serializable

public class DDXQJDBCConnection

extends Object

implements Serializable

Part of DDXQ implementation of XQDataSource, the part that corresponds to a single SQLAdaptor.

See Also:

Serialized Form

Field Summary

static String	ISOLATIONLEVEL
static String	NAME
static String	OPTIONS
static String	PASSWORD
static String	SQLXMLFOREST
static String	SQLXMLIDENTIER
static String	TEMPTABLECOLUMNS
static String	TEMPTABLEPREFIX
static String	URL property names
static String	USER

Constructor Summary

DDXQJDBCConnection()

DDXQJDBCConnection(String name)

Method Summary

String	getName()
String	getOptions() Get the options.
String	getPassword()
boolean	getSqlXmlForest() Gets the forest property specifies the format of the XML result that fn:collection() returns.
String	getSqlXmlIdentifierEscaping() Gets the property controls how DataDirect XQuery handles escaping of identifiers, which is needed because of mismatches that occur when characters in SQL identifiers are mapped to XML.
String	getTempTableColumns() Gets the string representation of the temp table column-type pairs, or null if not set.
String	getTempTableSuffix() Gets the suffix used for temp tables.
int	getTransactionIsolationLevel() Gets the transaction isolation level.
String	getUrl()
String	getUser()
void	setName(String name)
void	setOptions(String options) Set the options
void	setPassword(String password)
void	setSqlXmlForest(boolean forest) Sets the forest property specifies the format of the XML result that fn:collection() returns.
void	setSqlXmlIdentifierEscaping(String escaping) Sets the property controls how DataDirect XQuery handles escaping of identifiers, which is needed because of mismatches that occur when characters in SQL identifiers are mapped to XML.
void	setTempTableColumns(String columns) Set the string representation of the temp table column-type pairs.
void	setTempTableSuffix(String prefix) Set the suffix used for temp tables.
void	setTransactionIsolationLevel(int level) Sets the transaction isolation level, one of the following values: java.sql.Connection.TRANSACTION_READ_UNCOMMITTED java.sql.Connection.TRANSACTION_READ_COMMITTED java.sql.Connection.TRANSACTION_REPEATABLE_READ java.sql.Connection.TRANSACTION_SERIALIZABLE
void	setUrl(String url)
void	setUser(String user)

Methods inherited from class java.lang.Object

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

Field Detail

URL

public static final String URL

property names

See Also:

Constant Field Values

USER

public static final String USER

See Also:

Constant Field Values

PASSWORD

public static final String PASSWORD

See Also:

Constant Field Values

OPTIONS

public static final String OPTIONS

See Also:

Constant Field Values

NAME

public static final String NAME

See Also:

Constant Field Values

SQLXMLFOREST

public static final String SQLXMLFOREST

See Also:

Constant Field Values

SQLXMLIDENTIER

public static final String SQLXMLIDENTIER

See Also:

Constant Field Values

ISOLATIONLEVEL

public static final String ISOLATIONLEVEL

See Also:

Constant Field Values

TEMPTABLEPREFIX

public static final String TEMPTABLEPREFIX

See Also:

Constant Field Values

TEMPTABLECOLUMNS

public static final String TEMPTABLECOLUMNS

See Also:

Constant Field Values

Constructor Detail

DDXQJDBCConnection

public DDXQJDBCConnection(String name)

Parameters:

name -

DDXQJDBCConnection

public DDXQJDBCConnection()

Method Detail

getName

public String getName()

Returns:

Returns the name.

setName

public void setName(String name)

getUser

public String getUser()

Returns:

Returns the user.

setUser

public void setUser(String user)

Parameters:

user - The user to set.

getPassword

public String getPassword()

Returns:

Returns the password.

setPassword

public void setPassword(String password)

Parameters:

password - The password to set.

getUrl

public String getUrl()

Returns:

Returns the url.

setUrl

public void setUrl(String url)

Parameters:

url - The url to set.

getOptions

public String getOptions()

Get the options.

Returns:

the string representation of the options, or null if not set

setOptions

public void setOptions(String options)
                throws XQException

Set the options

Throws:

XQException - when the option value has the wrong format.

setSqlXmlForest

public void setSqlXmlForest(boolean forest)

Sets the forest property specifies the format of the XML result that fn:collection() returns. Valid values are true and false. The default is true.

getSqlXmlForest

public boolean getSqlXmlForest()

Gets the forest property specifies the format of the XML result that fn:collection() returns.

Returns:

the forest property of the first SQL Adapter

setSqlXmlIdentifierEscaping

public void setSqlXmlIdentifierEscaping(String escaping)

Sets the property controls how DataDirect XQuery handles escaping of identifiers, which is needed because of mismatches that occur when characters in SQL identifiers are mapped to XML. Valid values are: none: No mapping is performed. An error is raised if a character in a SQL identifier cannot be mapped to XML. partial: Characters in SQL identifiers, except for colons ( : ), that are not XML characters are escaped using 'x'0 followed by the character�s Unicode representation in hexadecimal format. For example, "comp_plan" becomes comp_x005F_plan and "dept:id" becomes dept:id. full: All non-XML characters, including colons ( : ), are escaped in the SQL identifier name. For example, "dept:id" becomes dept_x003A_id. This setting also escapes names beginning with the characters "xml" The default mapping is full.

Parameters:

escaping - of how escaping of identifiers is handled.

getSqlXmlIdentifierEscaping

public String getSqlXmlIdentifierEscaping()

Gets the property controls how DataDirect XQuery handles escaping of identifiers, which is needed because of mismatches that occur when characters in SQL identifiers are mapped to XML.

Returns:

the mapping of how escaping of identifiers is handled

setTransactionIsolationLevel

public void setTransactionIsolationLevel(int level)

Sets the transaction isolation level, one of the following values: java.sql.Connection.TRANSACTION_READ_UNCOMMITTED java.sql.Connection.TRANSACTION_READ_COMMITTED java.sql.Connection.TRANSACTION_REPEATABLE_READ java.sql.Connection.TRANSACTION_SERIALIZABLE

Parameters:

level - the transaction isolation level.

getTransactionIsolationLevel

public int getTransactionIsolationLevel()

Gets the transaction isolation level.

Returns:

the transaction isolation level.

setTempTableSuffix

public void setTempTableSuffix(String prefix)

Set the suffix used for temp tables.

getTempTableSuffix

public String getTempTableSuffix()

Gets the suffix used for temp tables.

Returns:

the suffix of temp tables.

setTempTableColumns

public void setTempTableColumns(String columns)
                         throws XQException

Set the string representation of the temp table column-type pairs.

Parameters:

columns - column-type pairs.

Throws:

XQException

getTempTableColumns

public String getTempTableColumns()

Gets the string representation of the temp table column-type pairs, or null if not set.

Returns:

Throws:

XQException