org.gvsig.fmap.dal.store.jdbc

Class JDBCStoreProviderWriter

java.lang.Object

org.gvsig.tools.dispose.impl.AbstractDisposable

org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider

org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

org.gvsig.fmap.dal.store.jdbc.JDBCStoreProviderWriter

All Implemented Interfaces:

DataStoreProvider, FeatureStoreProvider, ResourceConsumer, JDBCHelperUser, Disposable, DynObject

Direct Known Subclasses:

H2StoreProvider, PostgreSQLStoreProvider

public class JDBCStoreProviderWriter
extends JDBCStoreProvider

Nested Class Summary

Nested classes/interfaces inherited from class org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider

AbstractFeatureStoreProvider.FeatureProviderNotFoundException

Nested classes/interfaces inherited from interface org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider

FeatureStoreProvider.FeatureTypeChanged

Field Summary

Fields

Modifier and Type	Field and Description
protected Appender	appender

Fields inherited from class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

DESCRIPTION, directSQLMode, helper, METADATA_DEFINITION_NAME, NAME

Constructor Summary

Constructors

Modifier	Constructor and Description
	JDBCStoreProviderWriter(JDBCStoreParameters params, DataStoreProviderServices storeServices)
protected	JDBCStoreProviderWriter(JDBCStoreParameters params, DataStoreProviderServices storeServices, DynObject metadata)

Method Summary

Methods

Modifier and Type	Method and Description
protected void	addToListFeatureValues(FeatureProvider featureProvider, FeatureAttributeDescriptor attrOfList, FeatureAttributeDescriptor attr, java.util.List<java.lang.Object> values)
protected void	addToListFeatureValues(FeatureProvider featureProvider, java.util.List<FeatureAttributeDescriptor> attributes, java.util.List<java.lang.Object> values)
boolean	allowWrite() unsupported by default, override this otherwise
void	append(FeatureProvider featureProvider) unsupported by default, override this otherwise
protected void	appendToSQLPreparedPkWhereClause(java.lang.StringBuilder sql, java.util.List<FeatureAttributeDescriptor> pkAttributes)
void	beginAppend() unsupported by default, override this otherwise
protected Appender	createAppender()
void	endAppend() unsupported by default, override this otherwise
protected void	executeRemovePreparedStatement(java.sql.Connection conn, java.lang.String sql, java.util.List<FeatureAttributeDescriptor> attributes, java.util.Iterator<FeatureReferenceProviderServices> featureReferences)
protected void	executeUpdatePreparedStatement(java.sql.Connection conn, java.lang.String sql, java.util.List<FeatureAttributeDescriptor> attributes, java.util.Iterator<FeatureProvider> featureProviders)
protected TransactionalAction	getPerformChangesAction(java.util.Iterator<FeatureReferenceProviderServices> deleteds, java.util.Iterator<FeatureProvider> inserteds, java.util.Iterator<FeatureProvider> updateds, java.util.Iterator<FeatureStoreProvider.FeatureTypeChanged> featureTypesChanged)
protected java.lang.String	getSqlStatementAddField(FeatureAttributeDescriptor attr, java.util.List<java.lang.String> additionalStatement)
protected java.util.List<java.lang.String>	getSqlStatementAlterField(FeatureAttributeDescriptor attrOrg, FeatureAttributeDescriptor attrTrg, java.util.List<java.lang.String> additionalStatement)
protected java.lang.String	getSqlStatementDropField(FeatureAttributeDescriptor attr, java.util.List<java.lang.String> additionalStatement)
void	perfomInsert(java.sql.Connection conn, java.sql.PreparedStatement insertSt, java.lang.String sql, FeatureProvider feature, java.util.List<FeatureAttributeDescriptor> attributes)
void	performChanges(java.util.Iterator deleteds, java.util.Iterator inserteds, java.util.Iterator updateds, java.util.Iterator featureTypesChanged) unsupported by default, override this otherwise
protected void	performDeletes(java.sql.Connection conn, java.util.Iterator<FeatureReferenceProviderServices> deleteds, java.util.List<FeatureAttributeDescriptor> pkAttributes)
protected void	performInserts(java.sql.Connection conn, java.util.Iterator<FeatureProvider> inserteds)
protected void	performUpdates(java.sql.Connection conn, java.util.Iterator<FeatureProvider> updateds, java.util.List<FeatureAttributeDescriptor> pkAttributes)
protected void	performUpdateTable(java.sql.Connection conn, FeatureType original, FeatureType target)
protected void	prepareAttributeForInsert(FeatureAttributeDescriptor attr, java.util.List<java.lang.String> fields, java.util.List<java.lang.String> values)
protected void	prepareAttributeForUpdate(FeatureAttributeDescriptor attr, java.util.List<java.lang.String> values)
protected void	prepareSQLAndAttributeListForInsert(java.lang.StringBuilder sqlb, java.util.List<FeatureAttributeDescriptor> attributes)
boolean	supportsAppendMode() unsupported by default, override this otherwise

Methods inherited from class org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider

allowAutomaticValues, appendWhere, checksResulsets, close, closeDone, closeResource, closeResourceRequested, closeResulset, closeResulset, compoundCountSelect, compoundSelect, createHelper, createNewOID, createNewResultSet, createResultSet, createResultSet, createSet, doDispose, fixFilter, forceCloseAllResultSet, forceCloseResultSet, getCount, getDynValue, getEnvelope, getExplorer, getFeatureCount, getFullName, getHelper, getIsNullExpression, getJDBCParameters, getName, getOIDType, getProviderName, getResource, getResultSet, getSourceId, getTimeToResulSetZombie, hasGeometrySupport, initFeatureType, internalGetFeatureProviderByReference, internalGetFeatureProviderByReference, isDirectSQLMode, loadFeatureProvider, loadFeatureProviderValue, open, opendDone, openResulsetCount, resetCount, resourceChanged, resulsetNext, setTimeToResulSetZombie

Methods inherited from class org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider

abortAppend, canWriteGeometry, clear, createFeatureLocks, createFeatureProvider, createFeatureSelection, createResource, delegate, getChilds, getDynClass, getFeatureProviderByReference, getFeatureProviderByReference, getFeatureStore, getInterval, getParameters, getRetrievedFeaturesLimit, getStoreServices, getTimes, getTimes, hasDynValue, hasRetrievedFeaturesLimit, implement, invokeDynMethod, invokeDynMethod, isKnownEnvelope, isLocksSupported, refresh, savePrjFile, setDynValue, setMetadata

Methods inherited from class org.gvsig.tools.dispose.impl.AbstractDisposable

dispose, dispose

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.gvsig.tools.dispose.Disposable

dispose

Field Detail

appender

protected Appender appender

Constructor Detail

JDBCStoreProviderWriter

public JDBCStoreProviderWriter(JDBCStoreParameters params,
                       DataStoreProviderServices storeServices)
                        throws InitializeException

Throws:

InitializeException

JDBCStoreProviderWriter

protected JDBCStoreProviderWriter(JDBCStoreParameters params,
                       DataStoreProviderServices storeServices,
                       DynObject metadata)
                           throws InitializeException

Throws:

InitializeException

Method Detail

createAppender

protected Appender createAppender()

supportsAppendMode

public boolean supportsAppendMode()

Description copied from class: AbstractFeatureStoreProvider

unsupported by default, override this otherwise

Specified by:

supportsAppendMode in interface FeatureStoreProvider

Overrides:

supportsAppendMode in class AbstractFeatureStoreProvider

See Also:

FeatureStoreProvider.supportsAppendMode()

endAppend

public void endAppend()
               throws DataException

Description copied from class: AbstractFeatureStoreProvider

unsupported by default, override this otherwise

Specified by:

endAppend in interface FeatureStoreProvider

Overrides:

endAppend in class AbstractFeatureStoreProvider

Throws:

DataException

See Also:

FeatureStoreProvider.endAppend()

beginAppend

public void beginAppend()
                 throws DataException

Description copied from class: AbstractFeatureStoreProvider

unsupported by default, override this otherwise

Specified by:

beginAppend in interface FeatureStoreProvider

Overrides:

beginAppend in class AbstractFeatureStoreProvider

Throws:

DataException

See Also:

FeatureStoreProvider.beginAppend()

append

public void append(FeatureProvider featureProvider)
            throws DataException

Description copied from class: AbstractFeatureStoreProvider

unsupported by default, override this otherwise

Specified by:

append in interface FeatureStoreProvider

Overrides:

append in class AbstractFeatureStoreProvider

Throws:

DataException

See Also:

org.gvsig.fmap.dal.feature.spi.FeatureStoreProvider#append(org.gvsig. fmap.dal.feature.spi.FeatureProvider)

addToListFeatureValues

protected void addToListFeatureValues(FeatureProvider featureProvider,
                          FeatureAttributeDescriptor attrOfList,
                          FeatureAttributeDescriptor attr,
                          java.util.List<java.lang.Object> values)
                               throws DataException

Throws:

DataException

addToListFeatureValues

protected void addToListFeatureValues(FeatureProvider featureProvider,
                          java.util.List<FeatureAttributeDescriptor> attributes,
                          java.util.List<java.lang.Object> values)
                               throws DataException

Throws:

DataException

appendToSQLPreparedPkWhereClause

protected void appendToSQLPreparedPkWhereClause(java.lang.StringBuilder sql,
                                    java.util.List<FeatureAttributeDescriptor> pkAttributes)

executeRemovePreparedStatement

protected void executeRemovePreparedStatement(java.sql.Connection conn,
                                  java.lang.String sql,
                                  java.util.List<FeatureAttributeDescriptor> attributes,
                                  java.util.Iterator<FeatureReferenceProviderServices> featureReferences)
                                       throws DataException

Throws:

DataException

executeUpdatePreparedStatement

protected void executeUpdatePreparedStatement(java.sql.Connection conn,
                                  java.lang.String sql,
                                  java.util.List<FeatureAttributeDescriptor> attributes,
                                  java.util.Iterator<FeatureProvider> featureProviders)
                                       throws DataException

Throws:

DataException

performDeletes

protected void performDeletes(java.sql.Connection conn,
                  java.util.Iterator<FeatureReferenceProviderServices> deleteds,
                  java.util.List<FeatureAttributeDescriptor> pkAttributes)
                       throws DataException

Throws:

DataException

getSqlStatementAddField

protected java.lang.String getSqlStatementAddField(FeatureAttributeDescriptor attr,
                                       java.util.List<java.lang.String> additionalStatement)
                                            throws DataException

Throws:

DataException

getSqlStatementDropField

protected java.lang.String getSqlStatementDropField(FeatureAttributeDescriptor attr,
                                        java.util.List<java.lang.String> additionalStatement)

getSqlStatementAlterField

protected java.util.List<java.lang.String> getSqlStatementAlterField(FeatureAttributeDescriptor attrOrg,
                                                         FeatureAttributeDescriptor attrTrg,
                                                         java.util.List<java.lang.String> additionalStatement)
                                                              throws DataException

Throws:

DataException

performUpdateTable

protected void performUpdateTable(java.sql.Connection conn,
                      FeatureType original,
                      FeatureType target)
                           throws DataException

Throws:

DataException

perfomInsert

public void perfomInsert(java.sql.Connection conn,
                java.sql.PreparedStatement insertSt,
                java.lang.String sql,
                FeatureProvider feature,
                java.util.List<FeatureAttributeDescriptor> attributes)
                  throws DataException

Throws:

DataException

prepareAttributeForUpdate

protected void prepareAttributeForUpdate(FeatureAttributeDescriptor attr,
                             java.util.List<java.lang.String> values)

prepareAttributeForInsert

protected void prepareAttributeForInsert(FeatureAttributeDescriptor attr,
                             java.util.List<java.lang.String> fields,
                             java.util.List<java.lang.String> values)

prepareSQLAndAttributeListForInsert

protected void prepareSQLAndAttributeListForInsert(java.lang.StringBuilder sqlb,
                                       java.util.List<FeatureAttributeDescriptor> attributes)
                                            throws DataException

Throws:

DataException

performInserts

protected void performInserts(java.sql.Connection conn,
                  java.util.Iterator<FeatureProvider> inserteds)
                       throws DataException

Throws:

DataException

performUpdates

protected void performUpdates(java.sql.Connection conn,
                  java.util.Iterator<FeatureProvider> updateds,
                  java.util.List<FeatureAttributeDescriptor> pkAttributes)
                       throws DataException

Throws:

DataException

getPerformChangesAction

protected TransactionalAction getPerformChangesAction(java.util.Iterator<FeatureReferenceProviderServices> deleteds,
                                          java.util.Iterator<FeatureProvider> inserteds,
                                          java.util.Iterator<FeatureProvider> updateds,
                                          java.util.Iterator<FeatureStoreProvider.FeatureTypeChanged> featureTypesChanged)

performChanges

public void performChanges(java.util.Iterator deleteds,
                  java.util.Iterator inserteds,
                  java.util.Iterator updateds,
                  java.util.Iterator featureTypesChanged)
                    throws PerformEditingException

Description copied from class: AbstractFeatureStoreProvider

unsupported by default, override this otherwise

Specified by:

performChanges in interface FeatureStoreProvider

Overrides:

performChanges in class AbstractFeatureStoreProvider

Parameters:

deleteds - iterator of FeatureReferenceProviderServices

inserteds - iterator of FeatureProvider

updateds - iterator of FeatureProvider

featureTypesChanged - iterator of FeatureStoreProvider.FeatureTypeChanged

Throws:

PerformEditingException

See Also:

FeatureStoreProvider.performChanges(Iterator, Iterator, Iterator, Iterator)

allowWrite

public boolean allowWrite()

Description copied from class: AbstractFeatureStoreProvider

unsupported by default, override this otherwise

Specified by:

allowWrite in interface FeatureStoreProvider

Overrides:

allowWrite in class AbstractFeatureStoreProvider

Returns:

if write is supported

See Also:

FeatureStoreProvider.allowWrite()