be.SIRAPRISE.client

Class ReusableDBConnection

java.lang.Object

be.SIRAPRISE.client.DBConnection

be.SIRAPRISE.client.ReusableDBConnection

All Implemented Interfaces:

java.lang.AutoCloseable

public final class ReusableDBConnection
extends DBConnection

A ReusableDBConnection has all the semantics of a DBConnection. It differs from a OneShotDBConnection in that the close() method does not actually close the connection. Instead, after invocation of the close() method on a reusable connection, the connection object will be freed for subsequent reuse.

Author:

Erwin

Constructor Summary

Constructors

Constructor and Description
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, boolean initialAutoCommitForTransactions, long requestConnectionIdleTime, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, boolean initialAutoCommitForTransactions, long requestConnectionIdleTime, Signer signer) Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, boolean initialAutoCommitForTransactions, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, boolean initialAutoCommitForTransactions, Signer privateKeyProvider) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, long requestConnectionIdleTime, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, long requestConnectionIdleTime, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.util.Set<java.lang.String> signatureAlgorithmNames, java.lang.String clientID, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, boolean initialAutoCommitForTransactions, long requestConnectionIdleTime, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, boolean initialAutoCommitForTransactions, long requestConnectionIdleTime, Signer signer) Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, boolean initialAutoCommitForTransactions, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, boolean initialAutoCommitForTransactions, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, long requestConnectionIdleTime, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, long requestConnectionIdleTime, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, java.util.Set<java.lang.String> encryptionAlgorithmNames, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.
ReusableDBConnection(SiraPriseServer siraPriseServer, java.lang.String clientID, Signer signer) Creates a connection to the server on the specified host and port, and opens it for communication.

Method Summary

Modifier and Type	Method and Description
void	close() Closes the connection.

Methods inherited from class be.SIRAPRISE.client.DBConnection

commit, compileAndCacheQuery, compileQuery, endTransaction, execDmlCommand, execDmlCommandAndEndTransaction, execMultipleStatement, execMultipleStatement, execMultipleStatementAndEndTransaction, execMultipleStatementAndEndTransaction, execQueries, execQueriesAndEndTransaction, execQuery, execQueryAndEndTransaction, getDefaultTransactionAutoCommit, getSpecificationVersionForServer, isDefaultInitialAutoCommitForTransactions, isOpen, rollback, setDefaultTransactionAutoCommit, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction, startTransaction

Methods inherited from class java.lang.Object

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

Constructor Detail

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            long requestConnectionIdleTime,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The ID identifying the client of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

encryptionAlgorithmNames - A specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            long requestConnectionIdleTime,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The ID identifying the client of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The userID identifying the user of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

encryptionAlgorithmNames - a specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            Signer privateKeyProvider)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The userID identifying the user of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

privateKeyProvider - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            long requestConnectionIdleTime,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The userID identifying the user of this connection to SIRA_PRISE

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

encryptionAlgorithmNames - a specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            long requestConnectionIdleTime,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The userID identifying the user of this connection to SIRA_PRISE

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The userID identifying the user of this connection to SIRA_PRISE

encryptionAlgorithmNames - a specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.util.Set<java.lang.String> signatureAlgorithmNames,
                            java.lang.String clientID,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

signatureAlgorithmNames - a specified set of usable signature algorithm names

clientID - The userID identifying the user of this connection to SIRA_PRISE

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            long requestConnectionIdleTime,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The ID identifying the client of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

encryptionAlgorithmNames - A specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            long requestConnectionIdleTime,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port with the given autoCommit setting, and opens it for communication.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The ID identifying the client of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The userID identifying the user of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

encryptionAlgorithmNames - a specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            boolean initialAutoCommitForTransactions,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The userID identifying the user of this connection to SIRA_PRISE

initialAutoCommitForTransactions - true if the transactions created on this connection should have their autocommit set to true

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            long requestConnectionIdleTime,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The userID identifying the user of this connection to SIRA_PRISE

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

encryptionAlgorithmNames - a specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            long requestConnectionIdleTime,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The userID identifying the user of this connection to SIRA_PRISE

requestConnectionIdleTime - The requested time in milliseconds that the connection is allowed to stay idle

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            java.util.Set<java.lang.String> encryptionAlgorithmNames,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The userID identifying the user of this connection to SIRA_PRISE

encryptionAlgorithmNames - a specified set of usable encryption protocol names

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

ReusableDBConnection

public ReusableDBConnection(SiraPriseServer siraPriseServer,
                            java.lang.String clientID,
                            Signer signer)
                     throws java.io.IOException,
                            CommunicationProtocolException,
                            DBException

Creates a connection to the server on the specified host and port, and opens it for communication. AutoCommit will be OFF. The requested connection idle time is the default time configured in the client properties.

Parameters:

siraPriseServer - The identification of the host. It may either be its DNS name or its IP address in dotted decimal.

clientID - The userID identifying the user of this connection to SIRA_PRISE

signer - The Signer object that will be called upon to compute the needed signature

Throws:

java.io.IOException - if an I/O error occurs when creating the TCP socket.

CommunicationProtocolException - If an unexpected message was received during the handshake

DBException - If an error was detected on the server during the handshake

Method Detail

close

public void close()

Description copied from class: DBConnection

Closes the connection. If an uncommitted transaction is still pending on the connection, it will be rolled back and ended.

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in class DBConnection