org.deegree.commons.jdbc
Class Util

java.lang.Object
  org.deegree.commons.jdbc.Util

public class Util
extends java.lang.Object

Util

Version:

$Revision: 27616 $, $Date: 2010-10-29 11:01:36 +0200 (Fr, 29. Okt 2010) $

Author:

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

Constructor Summary

Util()

Method Summary

static GenericFeatureType	determineFeatureType(javax.xml.namespace.QName ftName, java.lang.String connId, java.lang.String sql)
static java.util.LinkedList<java.lang.String>	fetchGeometrySchemas(java.lang.String connId)
static java.util.LinkedList<java.lang.String>	fetchGeometryTables(java.lang.String connId, java.lang.String schema)
static int	findSrid(java.lang.String connid, java.lang.String tableName, java.lang.String tableSchema)

Methods inherited from class java.lang.Object

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

Constructor Detail

Util

public Util()

Method Detail

determineFeatureType

public static GenericFeatureType determineFeatureType(javax.xml.namespace.QName ftName,
                                                      java.lang.String connId,
                                                      java.lang.String sql)

Parameters:

ftName -

connId -

sql -

Returns:

null, if an SQL error occurred

fetchGeometrySchemas

public static java.util.LinkedList<java.lang.String> fetchGeometrySchemas(java.lang.String connId)

Parameters:

connId -

Returns:

a list of all schemas with geometry tables

fetchGeometryTables

public static java.util.LinkedList<java.lang.String> fetchGeometryTables(java.lang.String connId,
                                                                         java.lang.String schema)

Parameters:

connId -

schema -

Returns:

all tables (currently only PostGIS)

findSrid

public static int findSrid(java.lang.String connid,
                           java.lang.String tableName,
                           java.lang.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)