ilog.views.gantt.model.jdbc

Class IlvJDBCGanttModel

java.lang.Object

ilog.views.gantt.model.IlvAbstractGanttModel

ilog.views.gantt.model.table.IlvTableGanttModel

ilog.views.gantt.model.jdbc.IlvJDBCGanttModel

All Implemented Interfaces:

IlvGanttModel, Serializable, EventListener, TableModelListener

public class IlvJDBCGanttModel
extends IlvTableGanttModel

An implementation of the IlvGanttModel interface that connects to a database through JDBC to get the definition of the activities, resources, constraints and reservation with simple mapping configuration. Optionally modifications on the model will be forwarded back to the database if read-only option is de-activated.

In practice IlvJDBCGanttModel is an IlvTableGanttModel subclass that uses IlvRowSetTableModel instances to fill the model with activities, resources, constraints and reservations.

If advanced features that are not available in this class are required (such as switching off auto-commit or mapping to several columns for a single property), it is possible to directly use the IlvTableGanttModel class and configure IlvTableModelMapper instances.

The following is an example of how to use this class. Considering the given GANTT_TABLE in a database:

ACTIVITY	ARRIVAL	DEPARTURE	RESOURCE	METADATA
A1	10/17/03	04/02/04	R1	Whatever
...	...	...	...	...

The following code allows you to read its content in the given gantt model:

 // true in the constructor means that the model will be read-only
 IlvJDBCGanttModel jdbcGanttModel = new IlvJDBCGanttModel(true);
 Connection connection = DriverManager.getConnection(databaseURL, user, passwd);
 Map activitiesMapping = new HashMap();
 activitiesMapping.put(IlvTableActivity.ID_PROPERTY, "ACTIVITY");
 activitiesMapping.put(IlvTableActivity.NAME_PROPERTY, "ACTIVITY");
 activitiesMapping.put(IlvTableActivity.START_TIME_PROPERTY, "ARRIVAL");
 activitiesMapping.put(IlvTableActivity.END_TIME_PROPERTY, "DEPARTURE");
 activitiesMapping.put(IlvTableActivity.PARENT_ID_PROPERTY, "ACTIVITY_PARENT");
 // user property
 activitiesMapping.put("MyUserProperty", "METADATA");
 jdbcGanttModel.setActivitiesQuery(connection, "select ACTIVITY,
                                                       ARRIVAL, DEPARTURE,
                                                       // no parent => Null
                                                       Null as ACTIVITY_PARENT,
                                                       METADATA
                                                from GANTT_TABLE",
                                   activitiesMapping);
 Map resourcesMapping = new HashMap();
 resourcesMapping.put(IlvTableResource.ID_PROPERTY, "RESOURCE");
 resourcesMapping.put(IlvTableResource.NAME_PROPERTY, "RESOURCE");
 resourcesMapping.put(IlvTableResource.PARENT_ID_PROPERTY, "RESOURCE_PARENT");
 // for this one use column index for mapping not column name
 resourcesMapping.put(IlvTableResource.QUANTITY_PROPERTY, new Integer(2));
 jdbcGanttModel.setResourcesQuery(connection, "select RESOURCE,
                                                      // no parent => null
                                                      Null as RESOURCE_PARENT,
                                                      '1'
                                                from GANTT_TABLE group by RESOURCE",
                                   resourcesMapping);
 Map reservationsMapping = new HashMap();
 reservationsMapping.put(IlvTableReservation.ACTIVITY_ID_PROPERTY, "ACTIVITY");
 reservationsMapping.put(IlvTableReservation.RESOURCE_ID_PROPERTY, "RESOURCE");
 jdbcGanttModel.setReservationsQuery(connection, "select ACTIVITY, RESOURCE
                                                from GANTT_TABLE",
                                   reservationsMapping);
 // read the data in the IlvJDBCGanttModel
 jdbcGanttModel.initializeMapping();
 

Since:

JViews 6.0

See Also:

Serialized Form

Field Summary

Fields inherited from interface ilog.views.gantt.IlvGanttModel

ADJUSTING_PROPERTY, BATCHING_PROPERTY

Constructor Summary

Constructors

Constructor and Description
IlvJDBCGanttModel() Builds a read-only IlvJDBCGanttModel that will be configured later on.
IlvJDBCGanttModel(boolean readonly) Builds IlvJDBCGanttModel that will be configured later on.
IlvJDBCGanttModel(Connection connection, String activitiesQuery, Map activitiesMapping, String resourcesQuery, Map resourcesMapping, String constraintsQuery, Map constraintsMapping, Object[] constraintTypesMapping, String reservationsQuery, Map reservationsMapping) Builds a read-only IlvJDBCGanttModel from a single JDBC Connection, four queries and mapping information from queries columns to gantt properties.
IlvJDBCGanttModel(Connection connection, String activitiesQuery, Map activitiesMapping, String resourcesQuery, Map resourcesMapping, String constraintsQuery, Map constraintsMapping, Object[] constraintTypesMapping, String reservationsQuery, Map reservationsMapping, boolean readonly) Builds a IlvJDBCGanttModel from a single JDBC Connection, four queries and mapping information from queries columns to gantt properties.
IlvJDBCGanttModel(Connection connection, String activitiesQuery, Object[] activitiesQueryParameters, Map activitiesMapping, String resourcesQuery, Object[] resourcesQueryParameters, Map resourcesMapping, String constraintsQuery, Object[] constraintsQueryParameters, Map constraintsMapping, Object[] constraintTypesMapping, String reservationsQuery, Object[] reservationsQueryParameters, Map reservationsMapping, boolean readonly) Builds a IlvJDBCGanttModel from a single JDBC Connection, four queries and mapping information from queries columns to gantt properties.
IlvJDBCGanttModel(ResultSet activitiesResultSet, Map activitiesMapping, ResultSet resourcesResultSet, Map resourcesMapping, ResultSet constraintsResultSet, Map constraintsMapping, Object[] constraintTypesMapping, ResultSet reservationsResultSet, Map reservationsMapping) Builds a read-only IlvJDBCGanttModel from four ResultSet and mapping information from queries columns to gantt properties.

Method Summary

Modifier and Type	Method and Description
boolean	isReadOnly() Returns whether or not this model is read-only.
void	setActivitiesQuery(Connection connection, String query, Map mapping) Configures the IlvJDBCGanttTableModel to use the given query for activities.
void	setActivitiesQuery(Connection connection, String query, Object[] queryParameters, Map mapping) Configures the IlvJDBCGanttTableModel to use the given query for activities.
void	setActivitiesResultSet(ResultSet resultSet, Map mapping) Configures the IlvJDBCGanttTableModel to use the given ResultSet for activities.
void	setConstraintsQuery(Connection connection, String query, Map mapping, Object[] typesMapping) Configures the IlvJDBCGanttTableModel to use the given query for constraints.
void	setConstraintsQuery(Connection connection, String query, Object[] queryParameters, Map mapping, Object[] typesMapping) Configures the IlvJDBCGanttTableModel to use the given query for constraints.
void	setConstraintsResultSet(ResultSet resultSet, Map mapping, Object[] typesMapping) Configures the IlvJDBCGanttTableModel to use the given ResultSet for constraints.
void	setReservationsQuery(Connection connection, String query, Map mapping) Configures the IlvJDBCGanttTableModel to use the given query for reservations.
void	setReservationsQuery(Connection connection, String query, Object[] queryParameters, Map mapping) Configures the IlvJDBCGanttTableModel to use the given query for reservations.
void	setReservationsResultSet(ResultSet resultSet, Map mapping) Configures the IlvJDBCGanttTableModel to use the given ResultSet for reservations.
void	setResourcesQuery(Connection connection, String query, Map mapping) Configures the IlvJDBCGanttTableModel to use the given query for resources.
void	setResourcesQuery(Connection connection, String query, Object[] queryParameters, Map mapping) Configures the IlvJDBCGanttTableModel to use the given query for resources.
void	setResourcesResultSet(ResultSet resultSet, Map mapping) Configures the IlvJDBCGanttTableModel to use the given ResultSet for resources.

Methods inherited from class ilog.views.gantt.model.table.IlvTableGanttModel

addActivity, addConstraint, addReservation, addResource, configureHierarchyChart, configureHierarchyChart, constraintIterator, constraintIteratorFromActivity, constraintIteratorToActivity, contains, contains, contains, createActivityMapper, createActivityMapper, createActivityMapper, createConstraintMapper, createConstraintMapper, createConstraintMapper, createReservationMapper, createReservationMapper, createReservationMapper, createResourceMapper, createResourceMapper, createResourceMapper, fireReservationEvent, getActivitiesTableModel, getActivityMapper, getChildActivity, getChildActivityCount, getChildActivityIndex, getChildResource, getChildResourceCount, getChildResourceIndex, getConstraintMapper, getConstraintsTableModel, getParentActivity, getParentActivityIndex, getParentResource, getParentResourceIndex, getReservationMapper, getReservationsTableModel, getResourceMapper, getResourcesTableModel, getRootActivity, getRootResource, initializeMapping, isAdvanceCheckEnabled, isMultipleRootModeOn, moveActivity, moveResource, removeActivity, removeActivity, removeConstraint, removeReservation, removeResource, removeResource, reservationIterator, reservationIterator, reservationIterator, reservationIterator, setActivitiesTableModel, setActivityMapper, setAdvanceCheckEnabled, setConstraintMapper, setConstraintsTableModel, setMultipleRootModeOn, setReservationMapper, setReservationsTableModel, setResourceMapper, setResourcesTableModel, setRootActivity, setRootResource, tableChanged

Methods inherited from class ilog.views.gantt.model.IlvAbstractGanttModel

activityPreorderIterator, activityPreorderIterator, addActivity, addActivityHierarchyListener, addActivityListener, addConstraintListener, addGanttModelPropertyListener, addReservationListener, addResource, addResourceHierarchyListener, addResourceListener, childActivityIterator, childResourceIterator, clear, fireActivitiesInserted, fireActivitiesInserted, fireActivitiesRemoved, fireActivitiesRemoved, fireActivityEvent, fireActivityInserted, fireActivityMoved, fireActivityRemoved, fireConstraintEvent, fireConstraintInserted, fireConstraintRemoved, fireConstraintRemoved, fireGanttModelPropertyEvent, fireReservationInserted, fireReservationRemoved, fireReservationRemoved, fireResourceEvent, fireResourceInserted, fireResourceMoved, fireResourceRemoved, fireResourcesInserted, fireResourcesInserted, fireResourcesRemoved, fireResourcesRemoved, getActivityHierarchyListeners, getActivityListeners, getChild, getChildCount, getChildIndex, getParent, getParentIndex, getResourceHierarchyListeners, getResourceListeners, isAdjusting, isBatching, registerEventListener, removeActivityHierarchyListener, removeActivityListener, removeConstraintListener, removeGanttModelPropertyListener, removeReservationListener, removeResourceHierarchyListener, removeResourceListener, resourcePreorderIterator, resourcePreorderIterator, setAdjusting, setBatching, writeEventListeners

Methods inherited from class java.lang.Object

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

Constructor Detail

IlvJDBCGanttModel

public IlvJDBCGanttModel()

Builds a read-only IlvJDBCGanttModel that will be configured later on. Once configured IlvTableGanttModel.initializeMapping() must be called.

See Also:

setActivitiesQuery(Connection, String, Object[], Map), setActivitiesResultSet(ResultSet, Map), setResourcesQuery(Connection, String, Object[], Map), setResourcesResultSet(ResultSet, Map), setConstraintsQuery(Connection, String, Object[], Map, Object[]), setConstraintsResultSet(ResultSet, Map, Object[]), setReservationsQuery(Connection, String, Object[], Map), setReservationsResultSet(ResultSet, Map)

IlvJDBCGanttModel

public IlvJDBCGanttModel(boolean readonly)

Builds IlvJDBCGanttModel that will be configured later on. Once configured IlvTableGanttModel.initializeMapping() must be called.

Parameters:

readonly - if true the model is read-only otherwise modifications are allowed and will automatically be commited back to the database

Since:

JViews 6.5

See Also:

setActivitiesQuery(Connection, String, Object[], Map), setActivitiesResultSet(ResultSet, Map), setResourcesQuery(Connection, String, Object[], Map), setResourcesResultSet(ResultSet, Map), setConstraintsQuery(Connection, String, Object[], Map, Object[]), setConstraintsResultSet(ResultSet, Map, Object[]), setReservationsQuery(Connection, String, Object[], Map), setReservationsResultSet(ResultSet, Map)

IlvJDBCGanttModel

public IlvJDBCGanttModel(Connection connection,
                         String activitiesQuery,
                         Map activitiesMapping,
                         String resourcesQuery,
                         Map resourcesMapping,
                         String constraintsQuery,
                         Map constraintsMapping,
                         Object[] constraintTypesMapping,
                         String reservationsQuery,
                         Map reservationsMapping)
                  throws SQLException,
                         IlvTableModelMappingException

Builds a read-only IlvJDBCGanttModel from a single JDBC Connection, four queries and mapping information from queries columns to gantt properties. If mapping information is not available a default mapping will be used, this mapping will look up for columns in the database that have the same name as the gantt properties involved (IlvTableActivity.ID_PROPERTY, IlvTableActivity.PARENT_ID_PROPERTY...)

Parameters:

connection - the Connection that will be used to connect to the database.

activitiesQuery - the query that returns the list table of activities

activitiesMapping - a Map filled with the association between the IlvTableActivity properties (like IlvTableActivity.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

resourcesQuery - the query that returns the list table of resources

resourcesMapping - a Map filled with the association between the IlvTableResource properties (like IlvTableResource.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintsQuery - the query that returns the list table of constraints

constraintsMapping - a Map filled with the association between the IlvTableConstraint properties (like IlvTableConstraint.FROM_ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintTypesMapping - contains the Objects in the TableModel that will represents, in that order, IlvConstraintType.START_START, IlvConstraintType.START_END, IlvConstraintType.END_START, IlvConstraintType.END_END.

reservationsQuery - the query that returns the list table of reservations

reservationsMapping - a Map filled with the association between the IlvTableReservation properties (like IlvTableReservation.ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException - if problems occurs with the database connection

IlvTableModelMappingException

IlvJDBCGanttModel

public IlvJDBCGanttModel(Connection connection,
                         String activitiesQuery,
                         Map activitiesMapping,
                         String resourcesQuery,
                         Map resourcesMapping,
                         String constraintsQuery,
                         Map constraintsMapping,
                         Object[] constraintTypesMapping,
                         String reservationsQuery,
                         Map reservationsMapping,
                         boolean readonly)
                  throws SQLException,
                         IlvTableModelMappingException

Builds a IlvJDBCGanttModel from a single JDBC Connection, four queries and mapping information from queries columns to gantt properties. If mapping information is not available a default mapping will be used, this mapping will look up for columns in the database that have the same name as the gantt properties involved (IlvTableActivity.ID_PROPERTY, IlvTableActivity.PARENT_ID_PROPERTY...)

Parameters:

connection - the Connection that will be used to connect to the database.

activitiesQuery - the query that returns the list table of activities

activitiesMapping - a Map filled with the association between the IlvTableActivity properties (like IlvTableActivity.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

resourcesQuery - the query that returns the list table of resources

resourcesMapping - a Map filled with the association between the IlvTableResource properties (like IlvTableResource.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintsQuery - the query that returns the list table of constraints

constraintsMapping - a Map filled with the association between the IlvTableConstraint properties (like IlvTableConstraint.FROM_ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintTypesMapping - contains the Objects in the TableModel that will represents, in that order, IlvConstraintType.START_START, IlvConstraintType.START_END, IlvConstraintType.END_START, IlvConstraintType.END_END.

reservationsQuery - the query that returns the list table of reservations

reservationsMapping - a Map filled with the association between the IlvTableReservation properties (like IlvTableReservation.ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

readonly - if true the model is read-only otherwise modifications are allowed and will automatically be commited back to the database

Throws:

SQLException - if problems occurs with the database connection

IlvTableModelMappingException

Since:

JViews 6.5

IlvJDBCGanttModel

public IlvJDBCGanttModel(Connection connection,
                         String activitiesQuery,
                         Object[] activitiesQueryParameters,
                         Map activitiesMapping,
                         String resourcesQuery,
                         Object[] resourcesQueryParameters,
                         Map resourcesMapping,
                         String constraintsQuery,
                         Object[] constraintsQueryParameters,
                         Map constraintsMapping,
                         Object[] constraintTypesMapping,
                         String reservationsQuery,
                         Object[] reservationsQueryParameters,
                         Map reservationsMapping,
                         boolean readonly)
                  throws SQLException,
                         IlvTableModelMappingException

Builds a IlvJDBCGanttModel from a single JDBC Connection, four queries and mapping information from queries columns to gantt properties. If mapping information is not available a default mapping will be used, this mapping will look up for columns in the database that have the same name as the gantt properties involved (IlvTableActivity.ID_PROPERTY, IlvTableActivity.PARENT_ID_PROPERTY...)

Parameters:

connection - the Connection that will be used to connect to the database.

activitiesQuery - the query that returns the list table of activities

activitiesQueryParameters - The parameters for the query that returns the list table of activities, or null.

activitiesMapping - a Map filled with the association between the IlvTableActivity properties (like IlvTableActivity.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

resourcesQuery - the query that returns the list table of resources

resourcesQueryParameters - The parameters for the query that returns the list table of resources, or null.

resourcesMapping - a Map filled with the association between the IlvTableResource properties (like IlvTableResource.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintsQuery - the query that returns the list table of constraints

constraintsQueryParameters - The parameters for the query that returns the list table of constraints, or null.

constraintsMapping - a Map filled with the association between the IlvTableConstraint properties (like IlvTableConstraint.FROM_ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintTypesMapping - contains the Objects in the TableModel that will represents, in that order, IlvConstraintType.START_START, IlvConstraintType.START_END, IlvConstraintType.END_START, IlvConstraintType.END_END.

reservationsQuery - the query that returns the list table of reservations

reservationsQueryParameters - The parameters for the query that returns the list table of reservations, or null.

reservationsMapping - a Map filled with the association between the IlvTableReservation properties (like IlvTableReservation.ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

readonly - if true the model is read-only otherwise modifications are allowed and will automatically be commited back to the database

Throws:

SQLException - if problems occurs with the database connection

IlvTableModelMappingException

Since:

JViews 8.8

IlvJDBCGanttModel

public IlvJDBCGanttModel(ResultSet activitiesResultSet,
                         Map activitiesMapping,
                         ResultSet resourcesResultSet,
                         Map resourcesMapping,
                         ResultSet constraintsResultSet,
                         Map constraintsMapping,
                         Object[] constraintTypesMapping,
                         ResultSet reservationsResultSet,
                         Map reservationsMapping)
                  throws IlvTableModelMappingException,
                         SQLException

Builds a read-only IlvJDBCGanttModel from four ResultSet and mapping information from queries columns to gantt properties. If mapping information is not available a default mapping will be used, this mapping will look up for columns in the database that have the same name as the gantt properties involved (IlvTableActivity.ID_PROPERTY, IlvTableActivity.PARENT_ID_PROPERTY...)

Parameters:

activitiesResultSet - the ResultSet than contains the values needed for the definition of the activities.

activitiesMapping - a Map filled with the association between the IlvTableActivity properties (like IlvTableActivity.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

resourcesResultSet - the ResultSet than contains the values needed for the definition of the resources.

resourcesMapping - a Map filled with the association between the IlvTableResource properties (like IlvTableResource.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintsResultSet - the ResultSet than contains the values needed for the definition of the constraints.

constraintsMapping - a Map filled with the association between the IlvTableConstraint properties (like IlvTableConstraint.FROM_ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

constraintTypesMapping - contains the Objects in the TableModel that will represents, in that order, IlvConstraintType.START_START, IlvConstraintType.START_END, IlvConstraintType.END_START, IlvConstraintType.END_END.

reservationsResultSet - the ResultSet than contains the values needed for the definition of the reservations.

reservationsMapping - a Map filled with the association between the IlvTableReservation properties (like IlvTableReservation.ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException - if problems occurs with the database connection

IlvTableModelMappingException

Method Detail

isReadOnly

public final boolean isReadOnly()

Returns whether or not this model is read-only. The ready-only status must be set at construction time, by default a model is read-only. When the model is not read-only modifications are allowed and will automatically be commited back to the database.

Returns:

whether or not this model is read-only.

Since:

JViews 6.5

See Also:

IlvJDBCGanttModel(boolean), IlvJDBCGanttModel(Connection, String, Map, String, Map, String, Map, Object[], String, Map, boolean), IlvJDBCGanttModel(Connection, String, Object[], Map, String, Object[], Map, String, Object[], Map, Object[], String, Object[], Map, boolean)

setActivitiesQuery

public void setActivitiesQuery(Connection connection,
                               String query,
                               Map mapping)
                        throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for activities.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

mapping - a Map filled with the association between the IlvTableActivity properties (like IlvTableActivity.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

setActivitiesQuery

public void setActivitiesQuery(Connection connection,
                               String query,
                               Object[] queryParameters,
                               Map mapping)
                        throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for activities.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

queryParameters - Parameters for the SQL query, or null for none.

mapping - a Map filled with the association between the IlvTableActivity properties (like IlvTableActivity.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

Since:

JViews 8.8

setActivitiesResultSet

public void setActivitiesResultSet(ResultSet resultSet,
                                   Map mapping)
                            throws SQLException

Configures the IlvJDBCGanttTableModel to use the given ResultSet for activities. This model must be read-only to be configured from a ResultSet.

Parameters:

resultSet - the ResultSet to be used.

mapping - a Map filled with the association between the IlvTableActivity properties (like IlvTableActivity.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

See Also:

isReadOnly()

setResourcesQuery

public void setResourcesQuery(Connection connection,
                              String query,
                              Map mapping)
                       throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for resources.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

mapping - a Map filled with the association between the IlvTableResource properties (like IlvTableResource.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

setResourcesQuery

public void setResourcesQuery(Connection connection,
                              String query,
                              Object[] queryParameters,
                              Map mapping)
                       throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for resources.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

queryParameters - Parameters for the SQL query, or null for none.

mapping - a Map filled with the association between the IlvTableResource properties (like IlvTableResource.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

Since:

JViews 8.8

setResourcesResultSet

public void setResourcesResultSet(ResultSet resultSet,
                                  Map mapping)
                           throws SQLException

Configures the IlvJDBCGanttTableModel to use the given ResultSet for resources. This model must be read-only to be configured from a ResultSet.

Parameters:

resultSet - the ResultSet to be used.

mapping - a Map filled with the association between the IlvTableResource properties (like IlvTableResource.ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

See Also:

isReadOnly()

setConstraintsQuery

public void setConstraintsQuery(Connection connection,
                                String query,
                                Map mapping,
                                Object[] typesMapping)
                         throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for constraints.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

mapping - a Map filled with the association between the IlvTableConstraint properties (like IlvTableConstraint.FROM_ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

typesMapping - contains the Objects in the TableModel that will represents, in that order, IlvConstraintType.START_START, IlvConstraintType.START_END, IlvConstraintType.END_START, IlvConstraintType.END_END.

Throws:

SQLException

setConstraintsQuery

public void setConstraintsQuery(Connection connection,
                                String query,
                                Object[] queryParameters,
                                Map mapping,
                                Object[] typesMapping)
                         throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for constraints.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

queryParameters - Parameters for the SQL query, or null for none.

mapping - a Map filled with the association between the IlvTableConstraint properties (like IlvTableConstraint.FROM_ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

typesMapping - contains the Objects in the TableModel that will represents, in that order, IlvConstraintType.START_START, IlvConstraintType.START_END, IlvConstraintType.END_START, IlvConstraintType.END_END.

Throws:

SQLException

Since:

JViews 8.8

setConstraintsResultSet

public void setConstraintsResultSet(ResultSet resultSet,
                                    Map mapping,
                                    Object[] typesMapping)
                             throws SQLException

Configures the IlvJDBCGanttTableModel to use the given ResultSet for constraints. This model must be read-only to be configured from a ResultSet.

Parameters:

resultSet - the ResultSet to be used.

mapping - a Map filled with the association between the IlvTableConstraint properties (like IlvTableConstraint.FROM_ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

typesMapping - contains the Objects in the TableModel that will represents, in that order, IlvConstraintType.START_START, IlvConstraintType.START_END, IlvConstraintType.END_START, IlvConstraintType.END_END.

Throws:

SQLException

See Also:

isReadOnly()

setReservationsQuery

public void setReservationsQuery(Connection connection,
                                 String query,
                                 Map mapping)
                          throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for reservations.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

mapping - a Map filled with the association between the IlvTableReservation properties (like IlvTableReservation.ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

setReservationsQuery

public void setReservationsQuery(Connection connection,
                                 String query,
                                 Object[] queryParameters,
                                 Map mapping)
                          throws SQLException

Configures the IlvJDBCGanttTableModel to use the given query for reservations.

Parameters:

connection - the Connection to be used

query - the SQL query to be used

queryParameters - Parameters for the SQL query, or null for none.

mapping - a Map filled with the association between the IlvTableReservation properties (like IlvTableReservation.ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

Since:

JViews 8.8

setReservationsResultSet

public void setReservationsResultSet(ResultSet resultSet,
                                     Map mapping)
                              throws SQLException

Configures the IlvJDBCGanttTableModel to use the given ResultSet for reservations. This model must be read-only to be configured from a ResultSet.

Parameters:

resultSet - the ResultSet to be used.

mapping - a Map filled with the association between the IlvTableReservation properties (like IlvTableReservation.ACTIVITY_ID_PROPERTY (keys) and columns indexes (Integer) or names (String) in the JDBC query (values).

Throws:

SQLException

See Also:

isReadOnly()