org.deegree.feature.utils
Class DBUtils

java.lang.Object
  org.deegree.feature.utils.DBUtils

public class DBUtils
extends Object

Util

Version:

$Revision: 30563 $, $Date: 2011-04-27 10:54:18 +0200 (Wed, 27 Apr 2011) $

Author:

Andreas Schmitz, last edited by: $Author: mschneider $

Constructor Summary

DBUtils()

Method Summary

static GenericFeatureType	determineFeatureType(QName ftName, String connId, String sql)
static LinkedList<String>	fetchGeometrySchemas(String connId)
static LinkedList<String>	fetchGeometryTables(String connId, String schema)
static int	findSrid(String connid, String tableName, String tableSchema)

Methods inherited from class java.lang.Object

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

Constructor Detail

DBUtils

public DBUtils()

Method Detail

determineFeatureType

public static GenericFeatureType determineFeatureType(QName ftName,
                                                      String connId,
                                                      String sql)

Parameters:

ftName -

connId -

sql -

Returns:

null, if an SQL error occurred

fetchGeometrySchemas

public static LinkedList<String> fetchGeometrySchemas(String connId)

Parameters:

connId -

Returns:

a list of all schemas with geometry tables

fetchGeometryTables

public static LinkedList<String> fetchGeometryTables(String connId,
                                                     String schema)

Parameters:

connId -

schema -

Returns:

all tables (currently only PostGIS)

findSrid

public static int findSrid(String connid,
                           String tableName,
                           String tableSchema)

Parameters:

connid -

tableName -

tableSchema -

Returns:

-2, if an error occurred (can be -1 if srid is -1 in the db, or if not found in geometry_columns metadata)