org.firebirdsql.pool

Class FBWrappingDataSource

java.lang.Object

org.firebirdsql.ds.RootCommonDataSource

org.firebirdsql.pool.FBWrappingDataSource

All Implemented Interfaces:

java.io.Serializable, java.sql.Wrapper, javax.naming.Referenceable, javax.naming.spi.ObjectFactory, javax.sql.CommonDataSource, javax.sql.DataSource, FirebirdConnectionProperties, ConnectionPoolConfiguration, FirebirdPool

Deprecated.

FBWrappingDataSource will be removed in Jaybird 3; consider migrating to a third party connection pool

@Deprecated
public class FBWrappingDataSource
extends RootCommonDataSource
implements javax.sql.DataSource, javax.naming.spi.ObjectFactory, javax.resource.Referenceable, java.io.Serializable, FirebirdPool

Implementation of DataSource including connection pooling. Following properties are supported:

• blobBufferSize size of the buffer used to transfer BLOB data.
• blockingTimeout time in milliseconds during which getConnection() method will block if no free connection is in pool.
• charSet similar to encoding, but takes Java character set name instead of Firebird's encoding.
• database path to a database including the server name; for example localhost/3050:c:/path/to/database.gdb.
• encoding character encoding for the JDBC connection.
• freeSize read-only: gives amount of free connections in the pool, when 0, blocking will occur if workingSize is equal to maxPoolSize.
• isolation default transaction isolation level for connections as string; possible values are:
  • TRANSACTION_READ_COMMITTED
  • TRANSACTION_REPEATABLE_READ
  • TRANSACTION_SERIALIZABLE
• loginTimeout property from DataSource, in this context is a synonym for blockingTimeout (however value is specified in seconds).
• maxIdleTime time in milliseconds after which idle physical connection in the pool is closed.
• maxStatements maximum number of pooled prepared statements, if 0, pooling is switched off.
• maxPoolSize maximum number of physical connections that can be opened by this data source.
• minPoolSize minimum number of connections that will remain open by this data source.
• nonStandardProperty a non-standard connection parameter in form name[=value].
• password password that is used to connect to database.
• pingInterval time interval during which connection will be proved for aliveness.
• pooling allows switching pooling off.
• statementPooling alternative way to switch statement pooling off.
• socketBufferSize size of the socket buffer in bytes. In some cases values used by JVM by default are not optimal. This results in performance degradation (especially when you transfer big BLOBs). Usually 8192 bytes provides good results.
• roleName SQL role name.
• tpbMapping mapping of the TPB parameters to JDBC transaction isolation levels.
• transactionIsolationLevel default transaction isolation level, number from Connection interface.
• totalSize total number of allocated connections.
• type type of connection that will be created. There are four possible types: pure Java (or type 4), type 2 that will use Firebird client library to connect to the database, local-mode type 2 driver, and embedded that will use embedded engine (access to local databases). Possible values are (case insensitive):
  • "PURE_JAVA" or "TYPE4" for pure Java (type 4) JDBC connections;
  • "NATIVE" or "TYPE2" to use Firebird client library;
  • "LOCAL" to use Firebird client library in local-mode (IPC link to server);
  • "EMBEDDED" to use embedded engine.
• userName name of the user that will be used to access the database.
• workingSize number of connections that are in use (e.g. were obtained using getConnection() method, but not yet closed).

Author:

Roman Rokytskyy

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
FBWrappingDataSource() Deprecated. Create instance of this class.

Method Summary

Modifier and Type	Method and Description
protected void	finalize() Deprecated. Finalize this instance.
int	getBlobBufferSize() Deprecated.
int	getBlockingTimeout() Deprecated. Get time during which ConnectionPoolDataSource.getPooledConnection() can block.
int	getBuffersNumber() Deprecated.
java.lang.String	getCharSet() Deprecated.
java.sql.Connection	getConnection() Deprecated. Get JDBC connection from this data source.
java.sql.Connection	getConnection(java.lang.String user, java.lang.String password) Deprecated. Get JDBC connection for the specified user name and password.
int	getConnectionCount() Deprecated. Confusing name. Use getFreeSize() instead.
int	getConnectTimeout() Deprecated. Get the current connect timeout.
java.lang.String	getDatabase() Deprecated.
DatabaseParameterBuffer	getDatabaseParameterBuffer() Deprecated. Get the database parameter buffer corresponding to the current connection request information.
java.lang.String	getDefaultIsolation() Deprecated. Get the default transaction isolation level as string.
javax.naming.Reference	getDefaultReference() Deprecated. Get default JNDI reference for this datasource.
int	getDefaultTransactionIsolation() Deprecated. Get the default transaction isolation level.
java.lang.String	getDescription() Deprecated.
java.lang.String	getEncoding() Deprecated.
int	getFreeSize() Deprecated.
int	getIdleTimeout() Deprecated. non-standard name, use getMaxIdleTime().
java.lang.String	getIsolation() Deprecated. Use getDefaultIsolation() instead.
int	getLoginTimeout() Deprecated. Get login timeout.
java.io.PrintWriter	getLogWriter() Deprecated. Get log writer.
int	getMaxConnections() Deprecated. non-standard name, use getMaxPoolSize().
int	getMaxIdleTime() Deprecated. Get time after which idle connections will be deallocated.
int	getMaxPoolSize() Deprecated. Get maximum number of physical connections that can be simultaneously open.
int	getMaxStatements() Deprecated.
int	getMinConnections() Deprecated. non-standard name, use getMinPoolSize()
int	getMinPoolSize() Deprecated. Get minimum number of open JDBC connections that will be created when pool is started.
java.lang.String	getNonStandardProperty(java.lang.String key) Deprecated. Get the property that does not have corresponding getter method by its name.
java.lang.Object	getObjectInstance(java.lang.Object obj, javax.naming.Name name, javax.naming.Context nameCtx, java.util.Hashtable environment) Deprecated. Get object instance for the specified name in the specified context.
java.lang.String	getPassword() Deprecated.
int	getPingInterval() Deprecated. Get time interval after which connection should be pinged.
java.lang.String	getPingStatement() Deprecated. Get SQL statement that will be used to ping connection.
boolean	getPooling() Deprecated. use isPooling() method.
javax.naming.Reference	getReference() Deprecated. Get JDNI reference.
int	getRetryInterval() Deprecated. Get interval of getting connections retries.
java.lang.String	getRoleName() Deprecated.
int	getSocketBufferSize() Deprecated.
int	getSoTimeout() Deprecated. Get the current Socket blocking timeout (SoTimeout).
java.lang.String	getSqlDialect() Deprecated.
java.lang.String	getSqlRole() Deprecated. please use getRoleName() instead.
int	getTotalSize() Deprecated.
java.lang.String	getTpbMapping() Deprecated. Get the used TPB mapping.
int	getTransactionIsolationLevel() Deprecated. Use getDefaultTransactionIsolation() instead.
TransactionParameterBuffer	getTransactionParameters(int isolation) Deprecated. Get the transaction parameter buffer corresponding to the current connection request information.
java.lang.String	getType() Deprecated.
java.lang.String	getUserName() Deprecated.
java.lang.String	getUseTranslation() Deprecated.
int	getWorkingSize() Deprecated.
boolean	isDefaultResultSetHoldable() Deprecated. Get the default ResultSet holdability.
boolean	isKeepStatements() Deprecated.
boolean	isPingable() Deprecated. Check if this pool supports pingable connections.
boolean	isPooling() Deprecated. Check if this connection pool uses connection pooling, or just implements JDBC 2.0 SE interfaces.
boolean	isStatementPooling() Deprecated. Check if this connection pool provides also prepared statement pooling.
boolean	isTimestampUsesLocalTimezone() Deprecated.
boolean	isUseFirebirdAutocommit() Deprecated. Get whether to use Firebird autocommit (experimental).
boolean	isUseStandardUdf() Deprecated.
boolean	isUseStreamBlobs() Deprecated.
boolean	isWrapperFor(java.lang.Class iface) Deprecated.
void	restart() Deprecated.
void	setBlobBufferSize(int bufferSize) Deprecated.
void	setBlockingTimeout(int blockingTimeoutValue) Deprecated.
void	setBuffersNumber(int buffersNumber) Deprecated.
void	setCharSet(java.lang.String charSet) Deprecated.
void	setConnectTimeout(int connectTimeout) Deprecated. Set the connect timeout.
void	setDatabase(java.lang.String database) Deprecated.
void	setDefaultIsolation(java.lang.String isolation) Deprecated. Set the default transaction isolation level as string.
void	setDefaultResultSetHoldable(boolean isHoldable) Deprecated. Sets the default ResultSet holdability.
void	setDefaultTransactionIsolation(int defaultIsolationLevel) Deprecated. Set the default transaction isolation level.
void	setDescription(java.lang.String descriptionValue) Deprecated.
void	setEncoding(java.lang.String encoding) Deprecated.
void	setIdleTimeout(int idleTimeoutValue) Deprecated. non-standard name, use setMaxIdleTime(int).
void	setIsolation(java.lang.String isolation) Deprecated. Use setDefaultIsolation(String) instead.
void	setKeepStatements(boolean keepStatements) Deprecated.
void	setLoginTimeout(int seconds) Deprecated. Set login timeout.
void	setLogWriter(java.io.PrintWriter printWriter) Deprecated. Set log writer.
void	setMaxConnections(int maxConnections) Deprecated. non-standard name, use setMaxPoolSize(int).
void	setMaxIdleTime(int maxIdleTime) Deprecated.
void	setMaxPoolSize(int maxPoolSize) Deprecated.
void	setMaxStatements(int maxStatements) Deprecated.
void	setMinConnections(int minConnections) Deprecated. non-standard name, use setMinPoolSize(int)
void	setMinPoolSize(int minPoolSize) Deprecated.
void	setNonStandardProperty(java.lang.String propertyMapping) Deprecated. Set the property that does not have corresponding setter method.
void	setNonStandardProperty(java.lang.String key, java.lang.String value) Deprecated. Set the property that does not have corresponding setter method.
void	setPassword(java.lang.String password) Deprecated.
void	setPingInterval(int pingIntervalValue) Deprecated.
void	setPingStatement(java.lang.String pingStatement) Deprecated.
void	setPooling(boolean pooling) Deprecated.
void	setProperties(java.util.Properties props) Deprecated.
void	setReference(javax.naming.Reference reference) Deprecated. Set JNDI reference for this data source.
void	setRetryInterval(int retryInterval) Deprecated.
void	setRoleName(java.lang.String roleName) Deprecated.
void	setSocketBufferSize(int socketBufferSize) Deprecated.
void	setSoTimeout(int soTimeout) Deprecated. Set the Socket blocking timeout (SoTimeout).
void	setSqlDialect(java.lang.String sqlDialect) Deprecated.
void	setSqlRole(java.lang.String sqlRole) Deprecated. please use setRoleName(String) instead.
void	setStatementPooling(boolean statementPooling) Deprecated.
void	setTimestampUsesLocalTimezone(boolean timestampUsesLocalTimezone) Deprecated.
void	setTpbMapping(java.lang.String tpbMapping) Deprecated. Set path to the properties file with the TPB mapping.
void	setTransactionIsolationLevel(int level) Deprecated. Use setDefaultTransactionIsolation(int) instead.
void	setTransactionParameters(int isolation, TransactionParameterBuffer tpb) Deprecated. Set transaction parameters for the specified transaction isolation level.
void	setType(java.lang.String type) Deprecated.
void	setUseFirebirdAutocommit(boolean useFirebirdAutocommit) Deprecated. Set whether to use Firebird autocommit (experimental).
void	setUserName(java.lang.String userName) Deprecated.
void	setUseStandardUdf(boolean useStandardUdf) Deprecated.
void	setUseStreamBlobs(boolean useStreamBlobs) Deprecated.
void	setUseTranslation(java.lang.String translationPath) Deprecated.
void	shutdown() Deprecated.
java.lang.Object	unwrap(java.lang.Class iface) Deprecated.

Methods inherited from class org.firebirdsql.ds.RootCommonDataSource

getParentLogger

Methods inherited from class java.lang.Object

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

Methods inherited from interface javax.sql.CommonDataSource

getParentLogger

Constructor Detail

FBWrappingDataSource

public FBWrappingDataSource()

Deprecated.

Create instance of this class.

Method Detail

finalize

protected void finalize()
                 throws java.lang.Throwable

Deprecated.

Finalize this instance. This method will shut the pool down.

Overrides:

finalize in class java.lang.Object

Throws:

java.lang.Throwable - if something went wrong.

restart

public void restart()

Deprecated.

Specified by:

restart in interface FirebirdPool

shutdown

public void shutdown()

Deprecated.

Specified by:

shutdown in interface FirebirdPool

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Deprecated.

Get JDBC connection from this data source.

Specified by:

getConnection in interface javax.sql.DataSource

Returns:

instance of Connection.

Throws:

java.sql.SQLException - if connection cannot be obtained due to some reason.

getConnection

public java.sql.Connection getConnection(java.lang.String user,
                                         java.lang.String password)
                                  throws java.sql.SQLException

Deprecated.

Get JDBC connection for the specified user name and password.

Specified by:

getConnection in interface javax.sql.DataSource

Returns:

instance of Connection

Throws:

java.sql.SQLException - if something went wrong.

getLoginTimeout

public int getLoginTimeout()

Deprecated.

Get login timeout.

Specified by:

getLoginTimeout in interface javax.sql.CommonDataSource

Returns:

login timeout.

getLogWriter

public java.io.PrintWriter getLogWriter()

Deprecated.

Get log writer.

Specified by:

getLogWriter in interface javax.sql.CommonDataSource

Overrides:

getLogWriter in class RootCommonDataSource

Returns:

instance of PrintWriter.

setLoginTimeout

public void setLoginTimeout(int seconds)

Deprecated.

Set login timeout.

Specified by:

setLoginTimeout in interface javax.sql.CommonDataSource

Parameters:

seconds - login timeout.

setLogWriter

public void setLogWriter(java.io.PrintWriter printWriter)

Deprecated.

Set log writer.

Specified by:

setLogWriter in interface javax.sql.CommonDataSource

Overrides:

setLogWriter in class RootCommonDataSource

Parameters:

printWriter - instance of PrintWriter.

getBlockingTimeout

public int getBlockingTimeout()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Get time during which ConnectionPoolDataSource.getPooledConnection() can block. By default method blocks forever.

Specified by:

getBlockingTimeout in interface ConnectionPoolConfiguration

Specified by:

getBlockingTimeout in interface FirebirdPool

Returns:

pool blocking timeout in milliseconds, Integer.MAX_VALUE indicates blocking forever.

setBlockingTimeout

public void setBlockingTimeout(int blockingTimeoutValue)

Deprecated.

Specified by:

setBlockingTimeout in interface FirebirdPool

getDescription

public java.lang.String getDescription()

Deprecated.

setDescription

public void setDescription(java.lang.String descriptionValue)

Deprecated.

getMaxIdleTime

public int getMaxIdleTime()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Get time after which idle connections will be deallocated.

Specified by:

getMaxIdleTime in interface ConnectionPoolConfiguration

Specified by:

getMaxIdleTime in interface FirebirdPool

Returns:

idle timeout in milliseconds, Integer.MAX_VALUE indicates that idle connections are not removed.

setMaxIdleTime

public void setMaxIdleTime(int maxIdleTime)

Deprecated.

Specified by:

setMaxIdleTime in interface FirebirdPool

getIdleTimeout

public int getIdleTimeout()

Deprecated. non-standard name, use getMaxIdleTime().

Description copied from interface: ConnectionPoolConfiguration

Get time after which idle connections will be deallocated.

Specified by:

getIdleTimeout in interface ConnectionPoolConfiguration

Returns:

idle timeout in milliseconds, Integer.MAX_VALUE indicates that idle connections are not removed.

setIdleTimeout

public void setIdleTimeout(int idleTimeoutValue)

Deprecated. non-standard name, use setMaxIdleTime(int).

getMaxStatements

public int getMaxStatements()

Deprecated.

Specified by:

getMaxStatements in interface FirebirdPool

setMaxStatements

public void setMaxStatements(int maxStatements)

Deprecated.

Specified by:

setMaxStatements in interface FirebirdPool

getMaxPoolSize

public int getMaxPoolSize()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Get maximum number of physical connections that can be simultaneously open.

Specified by:

getMaxPoolSize in interface ConnectionPoolConfiguration

Specified by:

getMaxPoolSize in interface FirebirdPool

Returns:

maximum number of simultaneously open physical database connections, 0 if no limit exists.

setMaxPoolSize

public void setMaxPoolSize(int maxPoolSize)

Deprecated.

Specified by:

setMaxPoolSize in interface FirebirdPool

getMaxConnections

public int getMaxConnections()

Deprecated. non-standard name, use getMaxPoolSize().

Description copied from interface: ConnectionPoolConfiguration

Get maximum number of physical connections that can be simultaneously open.

Specified by:

getMaxConnections in interface ConnectionPoolConfiguration

Returns:

maximum number of simultaneously open physical database connections, 0 if no limit exists.

setMaxConnections

public void setMaxConnections(int maxConnections)

Deprecated. non-standard name, use setMaxPoolSize(int).

getMinPoolSize

public int getMinPoolSize()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Get minimum number of open JDBC connections that will be created when pool is started.

Specified by:

getMinPoolSize in interface ConnectionPoolConfiguration

Specified by:

getMinPoolSize in interface FirebirdPool

Returns:

minimum number of open JDBC connections to open at startup.

setMinPoolSize

public void setMinPoolSize(int minPoolSize)

Deprecated.

Specified by:

setMinPoolSize in interface FirebirdPool

getMinConnections

public int getMinConnections()

Deprecated. non-standard name, use getMinPoolSize()

Description copied from interface: ConnectionPoolConfiguration

Get minimum number of open JDBC connections that will be created when pool is started.

Specified by:

getMinConnections in interface ConnectionPoolConfiguration

Returns:

minimum number of open JDBC connections to open at startup.

setMinConnections

public void setMinConnections(int minConnections)

Deprecated. non-standard name, use setMinPoolSize(int)

isKeepStatements

public boolean isKeepStatements()

Deprecated.

setKeepStatements

public void setKeepStatements(boolean keepStatements)

Deprecated.

getPingInterval

public int getPingInterval()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Get time interval after which connection should be pinged.

Specified by:

getPingInterval in interface ConnectionPoolConfiguration

Specified by:

getPingInterval in interface FirebirdPool

Returns:

number of milliseconds in the ping interval.

setPingInterval

public void setPingInterval(int pingIntervalValue)

Deprecated.

Specified by:

setPingInterval in interface FirebirdPool

getPingStatement

public java.lang.String getPingStatement()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Get SQL statement that will be used to ping connection. Ping SQL statement returns exactly one row without throwing an exception. Ping SQL statement must not influence the outcome of a transaction.

Examples of ping SQL statements:

• Oracle: "SELECT CAST(1 AS INTEGER) FROM DUAL"
• Firebird: "SELECT CAST(1 AS INTEGER) FROM RDB$DATABASE"

Specified by:

getPingStatement in interface ConnectionPoolConfiguration

Returns:

SQL statement that will be used to ping connection.

setPingStatement

public void setPingStatement(java.lang.String pingStatement)

Deprecated.

getRetryInterval

public int getRetryInterval()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Get interval of getting connections retries. It might happen that pool contains no free connection. In order not to wait until connection is returned into the pool, pool will try to obtain connection again and again with the interval returned by this method. Default value is 1000 (1 sec).

Specified by:

getRetryInterval in interface ConnectionPoolConfiguration

Returns:

retry interval in milliseconds.

setRetryInterval

public void setRetryInterval(int retryInterval)

Deprecated.

isPingable

public boolean isPingable()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Check if this pool supports pingable connections. Pingable connections are used to correctly check if connection is still alive or not.

Specified by:

isPingable in interface ConnectionPoolConfiguration

Returns:

true if this pool supports pingable connections.

getSqlRole

public java.lang.String getSqlRole()

Deprecated. please use getRoleName() instead.

setSqlRole

public void setSqlRole(java.lang.String sqlRole)

Deprecated. please use setRoleName(String) instead.

getPooling

public boolean getPooling()

Deprecated. use isPooling() method.

isPooling

public boolean isPooling()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Check if this connection pool uses connection pooling, or just implements JDBC 2.0 SE interfaces. By default pooling is on. It might make sense to set pooling off to check performance degradation in test environment. It could be also used in the environment where physical connection must be closed right after usage, however using JDBC 2.0 SE interfaces is either a requirement or is simpler than standard java.sql.Driver.

Specified by:

isPooling in interface ConnectionPoolConfiguration

Specified by:

isPooling in interface FirebirdPool

Returns:

true if pooling is enabled.

setPooling

public void setPooling(boolean pooling)

Deprecated.

Specified by:

setPooling in interface FirebirdPool

isStatementPooling

public boolean isStatementPooling()

Deprecated.

Description copied from interface: ConnectionPoolConfiguration

Check if this connection pool provides also prepared statement pooling. By default prepared statement pooling is enabled, however there might be situations where statement pooling is not desired, for example in environments where database can quickly run out of handles and fast handle reuse is required.

Specified by:

isStatementPooling in interface ConnectionPoolConfiguration

Specified by:

isStatementPooling in interface FirebirdPool

Returns:

true if prepared statement pooling is enabled.

setStatementPooling

public void setStatementPooling(boolean statementPooling)

Deprecated.

Specified by:

setStatementPooling in interface FirebirdPool

getConnectionCount

public int getConnectionCount()
                       throws java.sql.SQLException

Deprecated. Confusing name. Use getFreeSize() instead.

Throws:

java.sql.SQLException

getFreeSize

public int getFreeSize()
                throws java.sql.SQLException

Deprecated.

Specified by:

getFreeSize in interface FirebirdPool

Throws:

java.sql.SQLException

getWorkingSize

public int getWorkingSize()
                   throws java.sql.SQLException

Deprecated.

Specified by:

getWorkingSize in interface FirebirdPool

Throws:

java.sql.SQLException

getTotalSize

public int getTotalSize()
                 throws java.sql.SQLException

Deprecated.

Specified by:

getTotalSize in interface FirebirdPool

Throws:

java.sql.SQLException

getTransactionIsolationLevel

public int getTransactionIsolationLevel()

Deprecated. Use getDefaultTransactionIsolation() instead.

setTransactionIsolationLevel

public void setTransactionIsolationLevel(int level)

Deprecated. Use setDefaultTransactionIsolation(int) instead.

getIsolation

public java.lang.String getIsolation()

Deprecated. Use getDefaultIsolation() instead.

setIsolation

public void setIsolation(java.lang.String isolation)
                  throws java.sql.SQLException

Deprecated. Use setDefaultIsolation(String) instead.

Throws:

java.sql.SQLException

setProperties

public void setProperties(java.util.Properties props)

Deprecated.

getBlobBufferSize

public int getBlobBufferSize()

Deprecated.

Specified by:

getBlobBufferSize in interface FirebirdConnectionProperties

Returns:

BLOB buffer size in bytes.

getBuffersNumber

public int getBuffersNumber()

Deprecated.

Specified by:

getBuffersNumber in interface FirebirdConnectionProperties

Returns:

number of cache buffers that should be allocated for this connection, should be specified for ClassicServer instances, SuperServer has a server-wide configuration parameter.

getCharSet

public java.lang.String getCharSet()

Deprecated.

Specified by:

getCharSet in interface FirebirdConnectionProperties

Returns:

Character set for the connection.

See Also:

FirebirdConnectionProperties.setCharSet(String)

getDatabase

public java.lang.String getDatabase()

Deprecated.

Specified by:

getDatabase in interface FirebirdConnectionProperties

Returns:

path to the database including the server name and the port, if needed.

getDatabaseParameterBuffer

public DatabaseParameterBuffer getDatabaseParameterBuffer()
                                                   throws java.sql.SQLException

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the database parameter buffer corresponding to the current connection request information.

Specified by:

getDatabaseParameterBuffer in interface FirebirdConnectionProperties

Returns:

instance of DatabaseParameterBuffer.

Throws:

java.sql.SQLException - if database parameter buffer cannot be created.

getDefaultIsolation

public java.lang.String getDefaultIsolation()

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the default transaction isolation level as string. This method is complementary to the FirebirdConnectionProperties.getDefaultTransactionIsolation(), however it takes a string as parameter instead of a numeric constant.

Specified by:

getDefaultIsolation in interface FirebirdConnectionProperties

Returns:

default transaction isolation as string.

See Also:

FirebirdConnectionProperties.setDefaultIsolation(String)

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the default transaction isolation level. This is the transaction isolation level for the newly created connections.

Specified by:

getDefaultTransactionIsolation in interface FirebirdConnectionProperties

Returns:

default transaction isolation level.

getEncoding

public java.lang.String getEncoding()

Deprecated.

Specified by:

getEncoding in interface FirebirdConnectionProperties

Returns:

Character encoding for the connection.

See Also:

FirebirdConnectionProperties.setEncoding(String)

getNonStandardProperty

public java.lang.String getNonStandardProperty(java.lang.String key)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the property that does not have corresponding getter method by its name.

Specified by:

getNonStandardProperty in interface FirebirdConnectionProperties

Parameters:

key - name of the property to get.

Returns:

value of the property.

getPassword

public java.lang.String getPassword()

Deprecated.

Specified by:

getPassword in interface FirebirdConnectionProperties

Returns:

password corresponding to the specified user name.

getRoleName

public java.lang.String getRoleName()

Deprecated.

Specified by:

getRoleName in interface FirebirdConnectionProperties

Returns:

SQL role to use.

getSocketBufferSize

public int getSocketBufferSize()

Deprecated.

Specified by:

getSocketBufferSize in interface FirebirdConnectionProperties

Returns:

socket buffer size in bytes, or -1 is not specified.

getSqlDialect

public java.lang.String getSqlDialect()

Deprecated.

Specified by:

getSqlDialect in interface FirebirdConnectionProperties

Returns:

SQL dialect of the client.

getTpbMapping

public java.lang.String getTpbMapping()

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the used TPB mapping.

Specified by:

getTpbMapping in interface FirebirdConnectionProperties

Returns:

path to the TPB mapping.

See Also:

FirebirdConnectionProperties.setTpbMapping(String)

getTransactionParameters

public TransactionParameterBuffer getTransactionParameters(int isolation)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the transaction parameter buffer corresponding to the current connection request information.

Specified by:

getTransactionParameters in interface FirebirdConnectionProperties

Parameters:

isolation - transaction isolation level for which TPB should be returned.

Returns:

instance of TransactionParameterBuffer.

getType

public java.lang.String getType()

Deprecated.

Specified by:

getType in interface FirebirdConnectionProperties

Returns:

type of the connection, for example, "PURE_JAVA", "LOCAL", "EMBEDDED", depends on the GDS implementations installed in the system.

getUserName

public java.lang.String getUserName()

Deprecated.

Specified by:

getUserName in interface FirebirdConnectionProperties

Returns:

name of the user that will be used when connecting to the database.

getUseTranslation

public java.lang.String getUseTranslation()

Deprecated.

Specified by:

getUseTranslation in interface FirebirdConnectionProperties

Returns:

path to the character translation table.

isTimestampUsesLocalTimezone

public boolean isTimestampUsesLocalTimezone()

Deprecated.

Specified by:

isTimestampUsesLocalTimezone in interface FirebirdConnectionProperties

Returns:

true if the Jaybird 1.0 handling of the calendar in corresponding setters. This is also compatible with MySQL calendar treatment.

isUseStandardUdf

public boolean isUseStandardUdf()

Deprecated.

Specified by:

isUseStandardUdf in interface FirebirdConnectionProperties

Returns:

true if driver should assume that standard UDF are installed.

isUseStreamBlobs

public boolean isUseStreamBlobs()

Deprecated.

Specified by:

isUseStreamBlobs in interface FirebirdConnectionProperties

Returns:

true if stream blobs should be created, otherwise false.

setBlobBufferSize

public void setBlobBufferSize(int bufferSize)

Deprecated.

Specified by:

setBlobBufferSize in interface FirebirdConnectionProperties

Parameters:

bufferSize - size of the BLOB buffer in bytes.

setBuffersNumber

public void setBuffersNumber(int buffersNumber)

Deprecated.

Specified by:

setBuffersNumber in interface FirebirdConnectionProperties

Parameters:

buffersNumber - number of cache buffers that should be allocated for this connection, should be specified for ClassicServer instances, SuperServer has a server-wide configuration parameter.

setCharSet

public void setCharSet(java.lang.String charSet)

Deprecated.

Specified by:

setCharSet in interface FirebirdConnectionProperties

Parameters:

charSet - Character set for the connection. Similar to encoding property, but accepts Java names instead of Firebird ones.

setDatabase

public void setDatabase(java.lang.String database)

Deprecated.

Specified by:

setDatabase in interface FirebirdConnectionProperties

Parameters:

database - path to the database including the server name and the port, if needed.

setDefaultIsolation

public void setDefaultIsolation(java.lang.String isolation)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set the default transaction isolation level as string. This method is complementary to the FirebirdConnectionProperties.setDefaultTransactionIsolation(int), however it takes a string as parameter instead of a numeric constant.

Following strings are allowed:

• "TRANSACTION_READ_COMMITTED" for a READ COMMITTED isolation level.
• "TRANSACTION_REPEATABLE_READ" for a REPEATABLE READ isolation level.
• "TRANSACTION_SERIALIZABLE" for a SERIALIZABLE isolation level.

Specified by:

setDefaultIsolation in interface FirebirdConnectionProperties

Parameters:

isolation - string constant representing a default isolation level.

setDefaultTransactionIsolation

public void setDefaultTransactionIsolation(int defaultIsolationLevel)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set the default transaction isolation level.

Specified by:

setDefaultTransactionIsolation in interface FirebirdConnectionProperties

Parameters:

defaultIsolationLevel - default transaction isolation level.

setEncoding

public void setEncoding(java.lang.String encoding)

Deprecated.

Specified by:

setEncoding in interface FirebirdConnectionProperties

Parameters:

encoding - Character encoding for the connection. See Firebird documentation for more information.

setNonStandardProperty

public void setNonStandardProperty(java.lang.String key,
                                   java.lang.String value)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set the property that does not have corresponding setter method.

Specified by:

setNonStandardProperty in interface FirebirdConnectionProperties

Parameters:

key - name of the property to set.

value - value of the property.

setNonStandardProperty

public void setNonStandardProperty(java.lang.String propertyMapping)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set the property that does not have corresponding setter method.

Specified by:

setNonStandardProperty in interface FirebirdConnectionProperties

Parameters:

propertyMapping - parameter value in the ?propertyName[=propertyValue]? form, this allows setting non-standard parameters using configuration files.

setPassword

public void setPassword(java.lang.String password)

Deprecated.

Specified by:

setPassword in interface FirebirdConnectionProperties

Parameters:

password - password corresponding to the specified user name.

setRoleName

public void setRoleName(java.lang.String roleName)

Deprecated.

Specified by:

setRoleName in interface FirebirdConnectionProperties

Parameters:

roleName - SQL role to use.

setSocketBufferSize

public void setSocketBufferSize(int socketBufferSize)

Deprecated.

Specified by:

setSocketBufferSize in interface FirebirdConnectionProperties

Parameters:

socketBufferSize - socket buffer size in bytes.

setSqlDialect

public void setSqlDialect(java.lang.String sqlDialect)

Deprecated.

Specified by:

setSqlDialect in interface FirebirdConnectionProperties

Parameters:

sqlDialect - SQL dialect of the client.

setTimestampUsesLocalTimezone

public void setTimestampUsesLocalTimezone(boolean timestampUsesLocalTimezone)

Deprecated.

Specified by:

setTimestampUsesLocalTimezone in interface FirebirdConnectionProperties

Parameters:

timestampUsesLocalTimezone - true if the Jaybird 1.0 handling of the calendar in corresponding setters. This is also compatible with MySQL calendar treatment.

setTpbMapping

public void setTpbMapping(java.lang.String tpbMapping)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set path to the properties file with the TPB mapping. The path begins with the protocol specification followed by the path to the resource. A special protocol "res:" should be used to specify resource in the classpath.

For the compatibility reasons, if no protocol is specified, classpath is used by default.

Properties file contains a mapping between the transaction isolation level (name of the constant in the Connection interface and a comma-separated list of TPB parameters.

Specified by:

setTpbMapping in interface FirebirdConnectionProperties

Parameters:

tpbMapping - path to the properties file.

setTransactionParameters

public void setTransactionParameters(int isolation,
                                     TransactionParameterBuffer tpb)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set transaction parameters for the specified transaction isolation level. The specified TPB is used as a default mapping for the specified isolation level.

Specified by:

setTransactionParameters in interface FirebirdConnectionProperties

Parameters:

isolation - transaction isolation level.

tpb - instance of TransactionParameterBuffer containing transaction parameters.

setType

public void setType(java.lang.String type)

Deprecated.

Specified by:

setType in interface FirebirdConnectionProperties

Parameters:

type - type of the connection, for example, "PURE_JAVA", "LOCAL", "EMBEDDED", depends on the GDS implementations installed in the system.

setUserName

public void setUserName(java.lang.String userName)

Deprecated.

Specified by:

setUserName in interface FirebirdConnectionProperties

Parameters:

userName - name of the user that will be used when connecting to the database.

setUseStandardUdf

public void setUseStandardUdf(boolean useStandardUdf)

Deprecated.

Specified by:

setUseStandardUdf in interface FirebirdConnectionProperties

Parameters:

useStandardUdf - true if driver should assume that standard UDF are installed.

setUseStreamBlobs

public void setUseStreamBlobs(boolean useStreamBlobs)

Deprecated.

Specified by:

setUseStreamBlobs in interface FirebirdConnectionProperties

Parameters:

useStreamBlobs - true if stream blobs should be created, otherwise false.

setUseTranslation

public void setUseTranslation(java.lang.String translationPath)

Deprecated.

Specified by:

setUseTranslation in interface FirebirdConnectionProperties

Parameters:

translationPath - path to the character translation table.

isDefaultResultSetHoldable

public boolean isDefaultResultSetHoldable()

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the default ResultSet holdability.

Specified by:

isDefaultResultSetHoldable in interface FirebirdConnectionProperties

Returns:

true when ResultSets are holdable by default, false not holdable.

setDefaultResultSetHoldable

public void setDefaultResultSetHoldable(boolean isHoldable)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Sets the default ResultSet holdability.

Specified by:

setDefaultResultSetHoldable in interface FirebirdConnectionProperties

Parameters:

isHoldable - true when ResultSets are holdable by default, false not holdable.

getSoTimeout

public int getSoTimeout()

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the current Socket blocking timeout (SoTimeout).

Specified by:

getSoTimeout in interface FirebirdConnectionProperties

Returns:

The socket blocking timeout in milliseconds (0 is 'infinite')

setSoTimeout

public void setSoTimeout(int soTimeout)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set the Socket blocking timeout (SoTimeout).

Specified by:

setSoTimeout in interface FirebirdConnectionProperties

Parameters:

soTimeout - Timeout in milliseconds (0 is 'infinite')

getConnectTimeout

public int getConnectTimeout()

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get the current connect timeout.

Specified by:

getConnectTimeout in interface FirebirdConnectionProperties

Returns:

Connect timeout in seconds (0 is 'infinite', or better: OS specific timeout)

setConnectTimeout

public void setConnectTimeout(int connectTimeout)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set the connect timeout.

Specified by:

setConnectTimeout in interface FirebirdConnectionProperties

Parameters:

connectTimeout - Connect timeout in seconds (0 is 'infinite', or better: OS specific timeout)

isUseFirebirdAutocommit

public boolean isUseFirebirdAutocommit()

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Get whether to use Firebird autocommit (experimental).

Specified by:

isUseFirebirdAutocommit in interface FirebirdConnectionProperties

Returns:

use Firebird autocommit

setUseFirebirdAutocommit

public void setUseFirebirdAutocommit(boolean useFirebirdAutocommit)

Deprecated.

Description copied from interface: FirebirdConnectionProperties

Set whether to use Firebird autocommit (experimental).

Specified by:

setUseFirebirdAutocommit in interface FirebirdConnectionProperties

Parameters:

useFirebirdAutocommit - true Use Firebird autocommit

getObjectInstance

public java.lang.Object getObjectInstance(java.lang.Object obj,
                                          javax.naming.Name name,
                                          javax.naming.Context nameCtx,
                                          java.util.Hashtable environment)
                                   throws java.lang.Exception

Deprecated.

Get object instance for the specified name in the specified context. This method constructs new datasource if obj represents Reference, whose factory class is equal to this class.

Specified by:

getObjectInstance in interface javax.naming.spi.ObjectFactory

Throws:

java.lang.Exception

getReference

public javax.naming.Reference getReference()

Deprecated.

Get JDNI reference.

Specified by:

getReference in interface javax.naming.Referenceable

Returns:

instance of Reference.

setReference

public void setReference(javax.naming.Reference reference)

Deprecated.

Set JNDI reference for this data source.

Parameters:

reference - JNDI reference.

getDefaultReference

public javax.naming.Reference getDefaultReference()

Deprecated.

Get default JNDI reference for this datasource. This method is called if datasource is used in non-JCA environment.

Returns:

instance of Reference containing all information that allows to reconstruct the datasource.

isWrapperFor

public boolean isWrapperFor(java.lang.Class iface)
                     throws java.sql.SQLException

Deprecated.

Specified by:

isWrapperFor in interface java.sql.Wrapper

Throws:

java.sql.SQLException

unwrap

public java.lang.Object unwrap(java.lang.Class iface)
                        throws java.sql.SQLException

Deprecated.

Specified by:

unwrap in interface java.sql.Wrapper

Throws:

java.sql.SQLException