ru.biosoft.access
Class SqlDataCollection

ru.biosoft.access.DataElementSupport
  |
  +--ru.biosoft.access.AbstractDataCollection
        |
        +--ru.biosoft.access.SqlDataCollection

public class SqlDataCollection

extends AbstractDataCollection

DataCollection which store all information in SQL DBMS.

See Also: DataCollection, SqlTransformer

Methods inherited from class ru.biosoft.access.DataElementSupport

getName, getOrigin, registerConstructorWithBadEqual

Field Detail

JDBC_DRIVER_PROPERTY

public final static String JDBC_DRIVER_PROPERTY

Property for storing class of jdbc driver.

public final static String JDBC_PASSWORD_PROPERTY

Property for storing user password for connecting to the DBMS.

public final static String JDBC_URL_PROPERTY

Property for storing driver specific URL for connecting to the DBMS.

public final static String JDBC_USER_PROPERTY

Property for storing user name for connecting to the DBMS.

public final static String TRANSFORMER_CLASS_PROPERTY

Property for storing class of that should be used for converting DataElements to/from DBMS.

public SqlDataCollection(DataCollection parent, Properties properties)
                    throws java.lang.ClassNotFoundException,
                           java.sql.SQLException,
                           java.lang.InstantiationException,
                           java.lang.IllegalAccessException

Standart constructor for creating data collection. Used by CollectionFactory.

Required properties:
• JDBC_DRIVER_PROPERTY
• JDBC_URL_PROPERTY
• JDBC_USER_PROPERTY
• JDBC_PASSWORD_PROPERTY
• TRANSFORMER_CLASS_PROPERTY

Parameters:

parent - Parent collection.

properties - Properties for creating collection (cannot be null).

See Also:

JDBC_DRIVER_PROPERTY, JDBC_URL_PROPERTY, JDBC_USER_PROPERTY, JDBC_PASSWORD_PROPERTY, TRANSFORMER_CLASS_PROPERTY

public void close()
            throws java.lang.Exception

Close connection to DBMS. Invalidates SQLDataCollection instance.

Throws:

Exception

public boolean contains(String name)

Returns true if data collection contain element with the specified name.

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

Return active connection. Connect if necessary.

Returns: Active connection.

Throws:

java.sql.SQLException - If operation on DBMS failed.

public Class getDataElementType()

Return type of DataElement stored in this data collection. Really ask transformer for extract template type.

Returns: Type of DataElement stored in this data collection.

See Also:

SqlTransformer

public List getNameList()

public int getSize()

Returns size of data collection. This implementation execute SQL query for extract record count.

Returns: size of data collection.

public SqlTransformer getTransformer()

public boolean isMutable()

Returns true if this data collection is mutable. Check Connection is read only or not.

Returns: whether this collection is mutable.

See Also:

Connection

public Iterator iterator()

Returns an iterator over the data elements in this collection. There are no guarantees concerning the order in which the elements are returned. If the data collection is modified while an iteration over it is in progress, the results of the iteration are undefined.

See Also:

SQLDataCollection.SQLIterator

Association Links

to Class java.lang.String

Property for storing class of jdbc driver.

to Class java.lang.String

Property for storing driver specific URL for connecting to the DBMS.

to Class java.lang.String

Property for storing user name for connecting to the DBMS.

to Class java.lang.String

Property for storing user password for connecting to the DBMS.

to Class java.lang.String

Property for storing class of that should be used for converting DataElements to/from DBMS.

to Class java.sql.Connection

Connection to DBMS.

to Class ru.biosoft.access.SqlTransformer

Transformer for converting DataElements to/from DBMS.