org.deegree.sqldialect.oracle
Class OracleGeometryConverter

java.lang.Object
  org.deegree.sqldialect.oracle.OracleGeometryConverter

All Implemented Interfaces:

ParticleConverter<Geometry>, GeometryParticleConverter

public class OracleGeometryConverter
extends Object
implements GeometryParticleConverter

TODO add class documentation here

Version:

$Revision: 31323 $, $Date: 2011-07-19 16:15:16 +0200 (Tue, 19 Jul 2011) $

Author:

Markus Schneider, Stephan Reichhelm, last edited by: $Author: sreichhelm $

Constructor Summary

OracleGeometryConverter(String column, ICRS crs, String srid)
Creates a new OracleGeometryConverter instance.

Method Summary

ICRS	getCrs()
String	getSelectSnippet(String tableAlias) Returns an SQL fragment for SELECTing the particle value from the associated database table.
String	getSetSnippet(Geometry particle) Returns a PreparedStatement fragment for setting the given particle value in an SQL statement.
String	getSrid()
void	setParticle(PreparedStatement stmt, Geometry particle, int paramIndex) Converts the given particle and sets the designated SQL parameter in the given PreparedStatement.
Geometry	toParticle(ResultSet rs, int colIndex) Builds a particle from the specified column of the current row of the given ResultSet.

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleGeometryConverter

public OracleGeometryConverter(String column,
                               ICRS crs,
                               String srid)

Creates a new OracleGeometryConverter instance.

Parameters:

column - (unqualified) column that stores the geometry, must not be null

crs - CRS of the stored geometries, can be null

srid - Oracle spatial reference identifier, must not be null

Method Detail

getSelectSnippet

public String getSelectSnippet(String tableAlias)

Description copied from interface: ParticleConverter

Returns an SQL fragment for SELECTing the particle value from the associated database table.

Specified by:

getSelectSnippet in interface ParticleConverter<Geometry>

Parameters:

tableAlias - alias that's used for disambiguating the table, may be null

Returns:

SQL fragment (e.g. X1.columname), may be null

getSetSnippet

public String getSetSnippet(Geometry particle)

Description copied from interface: ParticleConverter

Returns a PreparedStatement fragment for setting the given particle value in an SQL statement.

The value may be set in a literal SQL fashion (e.g. '2007-08-09') or as a PreparedStatement placeholder ('?').

Specified by:

getSetSnippet in interface ParticleConverter<Geometry>

Parameters:

particle - particle value, can be null

Returns:

SQL fragment (e.g. ?), may be null

toParticle

public Geometry toParticle(ResultSet rs,
                           int colIndex)
                    throws SQLException

Description copied from interface: ParticleConverter

Builds a particle from the specified column of the current row of the given ResultSet.

Specified by:

toParticle in interface ParticleConverter<Geometry>

Parameters:

rs - result set, never null

colIndex - index of the column in the result set

Returns:

particle, may be null

Throws:

SQLException

setParticle

public void setParticle(PreparedStatement stmt,
                        Geometry particle,
                        int paramIndex)
                 throws SQLException

Description copied from interface: ParticleConverter

Converts the given particle and sets the designated SQL parameter in the given PreparedStatement.

Specified by:

setParticle in interface ParticleConverter<Geometry>

Parameters:

stmt - prepared statement, never null

particle - particle value, can be null

paramIndex - index of the SQL parameter in the statement

Throws:

SQLException

getSrid

public String getSrid()

Specified by:

getSrid in interface GeometryParticleConverter

getCrs

public ICRS getCrs()

Specified by:

getCrs in interface GeometryParticleConverter