org.geotools.data.jdbc.fidmapper
Class MaxIncFIDMapper

Object
  AbstractFIDMapper
      MaxIncFIDMapper

All Implemented Interfaces:

Serializable, FIDMapper

public class MaxIncFIDMapper
extends AbstractFIDMapper

A FID mapper that uses a single integer column as the primary key and that does a SELECT MAX(fixColumn) + 1 to generate new ones. This is a fragile generation strategy, better use a sequence or a serial to get reliable results.

Author:

aaime

See Also:

Serialized Form

Module:

modules/library/jdbc (gt2-jdbc.jar) (Maven report) (SVN head)

Field Summary

Fields inherited from class AbstractFIDMapper

autoIncrement, colDecimalDigits, colNames, colSizes, colTypes, returnFIDColumnsAsAttributes, tableName, tableSchemaName

Constructor Summary

MaxIncFIDMapper(String tableName, String FIDColumn, int FIDColumnType)
Creates a new MaxIncFIDMapper object.

MaxIncFIDMapper(String tableSchemaName, String tableName, String FIDColumn, int FIDColumnType, boolean returnFIDColumnsAsAttributes)
Creates a new MaxIncFIDMapper object that will return the FID columns as business attributes.

Method Summary

String	createID(Connection conn, Feature feature, Statement statement) Creates a new ID for a feature.
boolean	equals(Object object)
String	getID(Object[] attributes) Returns the FID given the values of the prymary key attributes
Object[]	getPKAttributes(String FID) Creates the value for the PK attributes given the feature.

Methods inherited from class AbstractFIDMapper

getColumnCount, getColumnDecimalDigits, getColumnDecimalDigits, getColumnName, getColumnName, getColumnSize, getColumnSize, getColumnType, getColumnType, getTableName, getTableSchemaName, hasAutoIncrementColumns, initSupportStructures, isAutoIncrement, isAutoIncrement, isVolatile, returnFIDColumnsAsAttributes, setInfo, toString

Methods inherited from class Object

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

Constructor Detail

MaxIncFIDMapper

public MaxIncFIDMapper(String tableName,
                       String FIDColumn,
                       int FIDColumnType)

Creates a new MaxIncFIDMapper object.

Parameters:

tableName - the table name

FIDColumn - the name of the FID column

FIDColumnType - The SQL type of the column - must be a numeric type

MaxIncFIDMapper

public MaxIncFIDMapper(String tableSchemaName,
                       String tableName,
                       String FIDColumn,
                       int FIDColumnType,
                       boolean returnFIDColumnsAsAttributes)

Creates a new MaxIncFIDMapper object that will return the FID columns as business attributes.

Parameters:

tableSchemaName - the schema of this table

tableName - the table name

FIDColumn - the name of the FID column

FIDColumnType - The SQL type of the column - must be a numeric type

returnFIDColumnsAsAttributes - true to return FID columns as attributes.

Method Detail

getID

public String getID(Object[] attributes)

Description copied from interface: FIDMapper

Returns the FID given the values of the prymary key attributes

Parameters:

attributes - DOCUMENT ME!

See Also:

FIDMapper.getID(java.lang.Object[])

getPKAttributes

public Object[] getPKAttributes(String FID)

Description copied from interface: FIDMapper

Creates the value for the PK attributes given the feature. If the FID is null, will throw an IOException if not possible. If null is returned, no primary key value needs to be specified, which is what we want for auto-increment fields.

Parameters:

FID - The feature ID is going to be parsed

See Also:

FIDMapper.getPKAttributes(java.lang.String)

equals

public boolean equals(Object object)

Overrides:

equals in class Object

See Also:

Object.equals(java.lang.Object)

createID

public String createID(Connection conn,
                       Feature feature,
                       Statement statement)
                throws IOException

Description copied from interface: FIDMapper

Creates a new ID for a feature.
This is done either by querying the database (for auto-increment like types, for example sequences) or by inspecting the Feature (for example, for primary keys with business meaning that whose attributes are included in the Feature ones).

Parameters:

conn - - the database connection

feature - - the feature that needs the new FID

statement - - the statement used to insert the feature into the database

Throws:

IOException

See Also:

FIDMapper.createID(java.sql.Connection, Feature, Statement)