org.deegree.io.datastore.sql.mysql
Class MySQLDatastore

java.lang.Object
  org.deegree.io.datastore.Datastore
      org.deegree.io.datastore.sql.AbstractSQLDatastore
          org.deegree.io.datastore.sql.mysql.MySQLDatastore

public class MySQLDatastore
extends AbstractSQLDatastore

Datastore implementation for MySQL spatial databases.

Version:

$Revision: 12552 $, $Date: 2008-06-26 12:01:34 +0200 (Do, 26 Jun 2008) $

Author:

Markus Schneider , last edited by: $Author: aschmitz $

Field Summary

Fields inherited from class org.deegree.io.datastore.sql.AbstractSQLDatastore

pool, SRS_UNDEFINED

Constructor Summary

MySQLDatastore()

Method Summary

void	appendGeometryColumnGet(StatementBuffer query, String tableAlias, String column)
Geometry	convertDBToDeegreeGeometry(Object value, CoordinateSystem targetCS, Connection conn) Converts a MySQL specific geometry Object (a byte[] containing WKB) from the ResultSet to a deegree Geometry.
byte[]	convertDeegreeToDBGeometry(Geometry geometry, int targetSRS, Connection conn) Converts a deegree Geometry to a MySQL specific geometry object (a byte[] containing WKB).
MySQLWhereBuilder	getWhereBuilder(MappedFeatureType[] rootFts, String[] aliases, Filter filter, SortProperty[] sortProperties, TableAliasGenerator aliasGenerator, VirtualContentProvider vcProvider) Returns a specific WhereBuilder implementation for MySQL.

Methods inherited from class org.deegree.io.datastore.sql.AbstractSQLDatastore

acquireConnection, acquireTransaction, buildSRSTransformCall, buildSRSTransformCall, close, configure, convertFromDBType, createTransaction, determineFidsToLock, getAnnotationParser, getMaxValue, getNativeSRSCode, getSequenceCurrValPlusOffset, getSequenceNextVal, performQuery, performQuery, performQuery, prepareStatement, releaseConnection, releaseTransaction

Methods inherited from class org.deegree.io.datastore.Datastore

bindSchema, canTransformTo, getConfiguration, getFeatureType, getSchemas, transformQuery, transformResult

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLDatastore

public MySQLDatastore()

Method Detail

getWhereBuilder

public MySQLWhereBuilder getWhereBuilder(MappedFeatureType[] rootFts,
                                         String[] aliases,
                                         Filter filter,
                                         SortProperty[] sortProperties,
                                         TableAliasGenerator aliasGenerator,
                                         VirtualContentProvider vcProvider)
                                  throws DatastoreException

Returns a specific WhereBuilder implementation for MySQL.

Overrides:

getWhereBuilder in class AbstractSQLDatastore

Parameters:

rootFts - involved (requested) feature types

aliases - aliases for the feature types, may be null

filter - filter that restricts the matched features

sortProperties - sort criteria for the result, may be null or empty

aliasGenerator - used to generate unique table aliases

vcProvider -

Returns:

WhereBuilder implementation for MySQL

Throws:

DatastoreException

convertDBToDeegreeGeometry

public Geometry convertDBToDeegreeGeometry(Object value,
                                           CoordinateSystem targetCS,
                                           Connection conn)
                                    throws SQLException

Converts a MySQL specific geometry Object (a byte[] containing WKB) from the ResultSet to a deegree Geometry.

Specified by:

convertDBToDeegreeGeometry in class AbstractSQLDatastore

Parameters:

value -

targetCS -

conn -

Returns:

corresponding deegree geometry

Throws:

SQLException

convertDeegreeToDBGeometry

public byte[] convertDeegreeToDBGeometry(Geometry geometry,
                                         int targetSRS,
                                         Connection conn)
                                  throws DatastoreException

Converts a deegree Geometry to a MySQL specific geometry object (a byte[] containing WKB).

Specified by:

convertDeegreeToDBGeometry in class AbstractSQLDatastore

Parameters:

geometry -

targetSRS -

conn -

Returns:

corresponding PostGIS specific geometry object

Throws:

DatastoreException

appendGeometryColumnGet

public void appendGeometryColumnGet(StatementBuffer query,
                                    String tableAlias,
                                    String column)

Overrides:

appendGeometryColumnGet in class AbstractSQLDatastore