com.inet.tds
Class PDataSource

java.lang.Object
  |
  +--com.inet.tds.TdsDriver
        |
        +--com.inet.tds.TdsDataSource
              |
              +--com.inet.tds.PDataSource

All Implemented Interfaces:

java.lang.Cloneable, javax.sql.ConnectionPoolDataSource, javax.sql.DataSource, java.sql.Driver, javax.naming.Referenceable, java.lang.Runnable, java.io.Serializable

public class PDataSource

extends TdsDataSource

implements javax.sql.ConnectionPoolDataSource

This class is the implementation of the ConnectionPoolDataSource in the driver i-net OPTA(tm). If you want to learn more about this interface please take a look at Sun website. A sample can be found in the file sample/WithPoolDataSource.java.

See Also:

Serialized Form

Fields inherited from class com.inet.tds.TdsDataSource

MODE_SQLSERVER_65, MODE_SQLSERVER_70, MODE_SQLSERVER_70_ASCII

Constructor Summary

PDataSource()
Create an empty DataSource.

Method Summary

boolean	equals(java.lang.Object obj) Compares this ConnectionPoolDataSource to the specified object.
java.sql.Connection	getConnection() override the method in TdsDataSource.
java.sql.Connection	getConnection(java.lang.String username, java.lang.String password) override the method in TdsDataSource.
int	getInitialPoolSize() Get the number of physical connections the pool should contain when it is created.
int	getMaxIdleTime() Get the number of seconds that a physical connection should remain unused in the pool before the connection is closed. 0 (zero) indicates no limit.
int	getMaxPoolSize() Get the maximum number of physical connections that the pool should contain. 0 (zero) indicates no maximum size.
int	getMaxStatements() Get the total number of statements that the pool should keep open. 0 (zero) indicates that caching of statements is disabled.
int	getMinPoolSize() Get the number of physical connections the pool should keep available at all times. 0 (zero) indicates that connections should be created as needed.
javax.sql.PooledConnection	getPooledConnection() This method creates a real connection to the SQL Server with the parameter of this DataSource.
javax.sql.PooledConnection	getPooledConnection(java.lang.String user, java.lang.String password) This method creates a real connection to the SQL Server with the parameter of this DataSource.
int	getPropertyCycle() Get the interval, in seconds, that the pool should wait before enforcing the current policy defined by the values of the above connection pool properties.
void	setInitialPoolSize(int initialPoolSize) Set the number of physical connections the pool should contain when it is created.
void	setMaxIdleTime(int maxIdleTime) Set the number of seconds that a physical connection should remain unused in the pool before the connection is closed. 0 (zero) indicates no limit.
void	setMaxPoolSize(int maxPoolSize) Set the maximum number of physical connections that the pool should contain. 0 (zero) indicates no maximum size.
void	setMaxStatements(int maxStatements) Set the total number of statements that the pool should keep open. 0 (zero) indicates that caching of statements is disabled.
void	setMinPoolSize(int minPoolSize) Set the number of physical connections the pool should keep available at all times. 0 (zero) indicates that connections should be created as needed.
void	setPropertyCycle(int propertyCycle) Set the interval, in seconds, that the pool should wait before enforcing the current policy defined by the values of the above connection pool properties.

Methods inherited from class com.inet.tds.TdsDataSource

clone, getCharset, getDatabaseName, getDescription, getInstanceName, getLoginTimeout, getLogWriter, getMode, getPassword, getPort, getPortNumber, getProperties, getProperty, getQueryTimeout, getReference, getServerName, getSqlServer7Mode, getUseCursorsAlways, getUser, setCharset, setDatabaseName, setDescription, setInstanceName, setLoginTimeout, setLogWriter, setMode, setPassword, setPort, setPortNumber, setProperties, setProperty, setProperty, setQueryTimeout, setServerName, setSqlServer7Mode, setUseCursorsAlways, setUser, toString

Methods inherited from class com.inet.tds.TdsDriver

acceptsURL, connect, getMajorVersion, getMinorVersion, getPropertyInfo, jdbcCompliant, run

Methods inherited from class java.lang.Object

getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface javax.sql.ConnectionPoolDataSource

getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter

Constructor Detail

PDataSource

public PDataSource()

Create an empty DataSource.

Method Detail

getConnection

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

override the method in TdsDataSource. This method gets a connection from the pool manager i-net PLEXA(tm). The connection is a pooled connection.

Overrides:

getConnection in class TdsDataSource

Returns:

a connection from a pool

Throws:

java.sql.SQLException - if a database-access error occurs.

See Also:

TdsDataSource.getConnection()

getConnection

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

override the method in TdsDataSource. This method gets a connection from the pool manager i-net PLEXA(tm). The connection is a pooled connection.

Overrides:

getConnection in class TdsDataSource

Parameters:

username -

password -

Returns:

a connection from a pool

Throws:

java.sql.SQLException - if a database-access error occurs.

See Also:

TdsDataSource.getConnection(String,String)

getPooledConnection

public javax.sql.PooledConnection getPooledConnection()
                                               throws java.sql.SQLException

This method creates a real connection to the SQL Server with the parameter of this DataSource. The real connection is packed in a PooledConnection.

Specified by:

getPooledConnection in interface javax.sql.ConnectionPoolDataSource

Returns:

a PooledConnection for this DataSource.

Throws:

java.sql.SQLException - if a database-access error occurs.

getPooledConnection

public javax.sql.PooledConnection getPooledConnection(java.lang.String user,
                                                      java.lang.String password)
                                               throws java.sql.SQLException

This method creates a real connection to the SQL Server with the parameter of this DataSource. The real connection is packed in a PooledConnection.

Specified by:

getPooledConnection in interface javax.sql.ConnectionPoolDataSource

Parameters:

user - the database user on whose behalf the Connection is being made.

password - the user's password.

Returns:

a PooledConnection for this DataSource.

Throws:

java.sql.SQLException - if a database-access error occurs.

equals

public boolean equals(java.lang.Object obj)

Compares this ConnectionPoolDataSource to the specified object. The result is true if and only if the argument is not null and if it is a PDataSource object that has the same significant properties.

Overrides:

equals in class TdsDataSource

Parameters:

obj - the object to compare.

setMaxStatements

public void setMaxStatements(int maxStatements)

Set the total number of statements that the pool should keep open. 0 (zero) indicates that caching of statements is disabled.

An application server managing a pool of PooledConnection objects uses these properties to determine how to manage its pool. i-net PLEXA and the method getConnection() is not using this property.

See Also:

getMaxStatements()

getMaxStatements

public int getMaxStatements()

Get the total number of statements that the pool should keep open. 0 (zero) indicates that caching of statements is disabled. This feature is only available with a JDBC 3.0 driver

See Also:

setMaxStatements(int)

setInitialPoolSize

public void setInitialPoolSize(int initialPoolSize)

Set the number of physical connections the pool should contain when it is created.

i-net PLEXA(tm) and the method getConnection() use this property.

See Also:

getInitialPoolSize()

getInitialPoolSize

public int getInitialPoolSize()

Get the number of physical connections the pool should contain when it is created.

See Also:

setInitialPoolSize(int)

setMinPoolSize

public void setMinPoolSize(int minPoolSize)

Set the number of physical connections the pool should keep available at all times. 0 (zero) indicates that connections should be created as needed.

i-net PLEXA(tm) and the method getConnection() use this property.

See Also:

getMinPoolSize()

getMinPoolSize

public int getMinPoolSize()

Get the number of physical connections the pool should keep available at all times. 0 (zero) indicates that connections should be created as needed.

See Also:

setMinPoolSize(int)

setMaxPoolSize

public void setMaxPoolSize(int maxPoolSize)

Set the maximum number of physical connections that the pool should contain. 0 (zero) indicates no maximum size.

i-net PLEXA(tm) and the method getConnection() use this property.

See Also:

getMaxPoolSize(), PoolManager.setMaxPoolSize(int)

getMaxPoolSize

public int getMaxPoolSize()

Get the maximum number of physical connections that the pool should contain. 0 (zero) indicates no maximum size.

See Also:

setMaxPoolSize(int)

setMaxIdleTime

public void setMaxIdleTime(int maxIdleTime)

Set the number of seconds that a physical connection should remain unused in the pool before the connection is closed. 0 (zero) indicates no limit.

i-net PLEXA(tm) and the method getConnection() use this property.

See Also:

getMaxIdleTime(), PoolManager.setMaxIdleTime(int)

getMaxIdleTime

public int getMaxIdleTime()

Get the number of seconds that a physical connection should remain unused in the pool before the connection is closed. 0 (zero) indicates no limit.

See Also:

setMaxIdleTime(int)

setPropertyCycle

public void setPropertyCycle(int propertyCycle)

Set the interval, in seconds, that the pool should wait before enforcing the current policy defined by the values of the above connection pool properties.

An application server managing a pool of PooledConnection objects uses these properties to determine how to manage its pool. i-net PLEXA(tm) and the method getConnection() do not use this property.

See Also:

getPropertyCycle()

getPropertyCycle

public int getPropertyCycle()

Get the interval, in seconds, that the pool should wait before enforcing the current policy defined by the values of the above connection pool properties.

See Also:

setPropertyCycle(int)