org.gvsig.fmap.dal.store.h2.h2gis

Class SFSUtilities

java.lang.Object

org.gvsig.fmap.dal.store.h2.h2gis.SFSUtilities

public class SFSUtilities
extends java.lang.Object

Generic utilities function to retrieve spatial metadata trough SFS specification. Compatible with H2 and PostGIS.

Author:

Nicolas Fortin

Constructor Summary

Constructors

Constructor and Description
SFSUtilities()

Method Summary

Modifier and Type

Method and Description

static java.sql.PreparedStatement

prepareInformationSchemaStatement(java.sql.Connection connection, java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String informationSchemaTable, java.lang.String endQuery, java.lang.String catalog_field, java.lang.String schema_field, java.lang.String table_field) For table containing catalog, schema and table name, this function create a prepared statement with a filter on this combination.

Methods inherited from class java.lang.Object

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

Constructor Detail

SFSUtilities

public SFSUtilities()

Method Detail

prepareInformationSchemaStatement

public static java.sql.PreparedStatement prepareInformationSchemaStatement(java.sql.Connection connection,
                                                                           java.lang.String catalog,
                                                                           java.lang.String schema,
                                                                           java.lang.String table,
                                                                           java.lang.String informationSchemaTable,
                                                                           java.lang.String endQuery,
                                                                           java.lang.String catalog_field,
                                                                           java.lang.String schema_field,
                                                                           java.lang.String table_field)
                                                                    throws java.sql.SQLException

For table containing catalog, schema and table name, this function create a prepared statement with a filter on this combination.

Parameters:

connection - Active connection

catalog - Table catalog, may be empty

schema - Table schema, may be empty

table - Table name

informationSchemaTable - Information table location

endQuery - Additional where statement

catalog_field - Catalog field name

schema_field - Schema field name

table_field - Table field name

Returns:

Prepared statement

Throws:

java.sql.SQLException