|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectnet.sourceforge.hatbox.jts.Proc
public class Proc
Implementation of server side procedures
Method Summary | |
---|---|
static void |
buildIndex(java.sql.Connection con,
java.lang.String schema,
java.lang.String table,
int commitInterval,
ProgressMonitor progressMonitor)
Build the index for a spatial table. |
static void |
buildIndexProc(java.lang.String schema,
java.lang.String table,
int commitInterval,
ProgressMonitor progressMonitor)
|
static void |
delSpatial(java.lang.String schema,
java.lang.String table,
long id)
Delete an entry from the index for a deleted row in the spatial table. |
static void |
deSpatialize(java.sql.Connection con,
java.lang.String schema,
java.lang.String table)
Despatialize a currently spatialized table. |
static void |
deSpatializeProc(java.lang.String schema,
java.lang.String table)
|
static java.lang.String |
getDefaultSchema(java.sql.Connection con)
|
static void |
insSpatial(java.lang.String schema,
java.lang.String table,
long id)
Insert an entry into the index for an existing row in the spatial table. |
static java.sql.ResultSet |
mbrIntersectsEnv(java.sql.Connection con,
java.lang.String schema,
java.lang.String table,
double minx,
double maxx,
double miny,
double maxy)
A Table Function designed to provide the fastest possible intersection search at the cost of spatial inaccuracy ie an id is returned for each feature whose minimum bounding rectangle (MBR) intersects a rectangular search envelope. |
static java.sql.ResultSet |
mbrIntersectsEnvFunc(java.lang.String schema,
java.lang.String table,
double minx,
double maxx,
double miny,
double maxy)
|
static java.sql.ResultSet |
queryIntersectsWkb(java.sql.Connection con,
java.lang.String schema,
java.lang.String table,
byte[] wkb)
|
static java.sql.ResultSet |
queryIntersectsWkbFunc(java.lang.String schema,
java.lang.String table,
byte[] wkb)
|
static java.sql.ResultSet |
queryIntersectsWkt(java.sql.Connection con,
java.lang.String schema,
java.lang.String table,
java.lang.String wkt)
|
static java.sql.ResultSet |
queryIntersectsWktFunc(java.lang.String schema,
java.lang.String table,
java.lang.String wkt)
|
static java.sql.ResultSet |
queryWithPredicateWkb(java.sql.Connection con,
java.lang.String schema,
java.lang.String table,
java.lang.String predicate,
byte[] wkb)
|
static java.sql.ResultSet |
queryWithPredicateWkbFunc(java.lang.String schema,
java.lang.String table,
java.lang.String predicate,
byte[] wkb)
|
static java.sql.ResultSet |
queryWithPredicateWkt(java.sql.Connection con,
java.lang.String schema,
java.lang.String table,
java.lang.String predicate,
java.lang.String wkt)
|
static java.sql.ResultSet |
queryWithPredicateWktFunc(java.lang.String schema,
java.lang.String table,
java.lang.String predicate,
java.lang.String wkt)
|
static void |
saveEntry(java.lang.String schema,
java.lang.String table,
long id)
This procedure is invoked from 'before delete' and 'before update' triggers. |
static void |
spatialize(java.sql.Connection con,
java.lang.String schema,
java.lang.String table,
java.lang.String geomColumn,
java.lang.String geomType,
java.lang.String srid,
java.lang.String exposePK,
java.lang.String entriesMax)
Spatialize a currently non-spatialized table. |
static void |
spatializeProc(java.lang.String schema,
java.lang.String table,
java.lang.String geomColumn,
java.lang.String geomType,
java.lang.String srid,
java.lang.String exposePK,
java.lang.String entriesMax)
|
static MetaNode |
spatialMetaData(java.sql.Connection con,
java.lang.String schema,
java.lang.String table)
|
static void |
updSpatial(java.lang.String schema,
java.lang.String table,
long id)
Update an entry in the index for an existing row in the spatial table. |
static java.lang.String |
wkbToWkt(byte[] wkb)
Convert Well Known Binary byte array to Well Known Text string. |
static byte[] |
wktToWkb(java.lang.String wkt)
Convert Well Known Text string to Well Known Binary byte array. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public static java.lang.String getDefaultSchema(java.sql.Connection con) throws java.sql.SQLException
java.sql.SQLException
public static MetaNode spatialMetaData(java.sql.Connection con, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
java.sql.SQLException
public static void spatializeProc(java.lang.String schema, java.lang.String table, java.lang.String geomColumn, java.lang.String geomType, java.lang.String srid, java.lang.String exposePK, java.lang.String entriesMax) throws java.sql.SQLException
java.sql.SQLException
public static void spatialize(java.sql.Connection con, java.lang.String schema, java.lang.String table, java.lang.String geomColumn, java.lang.String geomType, java.lang.String srid, java.lang.String exposePK, java.lang.String entriesMax) throws java.sql.SQLException
There are no triggers created at this time, so bulk data loading can proceed efficiently.
The case of database object names must be specified exactly as recorded in database meta data. Both derby and H2 will convert un-escaped object names to upper case when it records them in the database meta data.
spatialSchema
- spatialTable
- entriesMax
- The maximum number of entries per node (defaults to 98)fidColumn
- The feature Id column in the spatial tablegeomColumn
- The geometry column in the spatial tablegeomType
- The geometry type (refer WKT types)
java.sql.SQLException
public static void buildIndexProc(java.lang.String schema, java.lang.String table, int commitInterval, ProgressMonitor progressMonitor) throws java.sql.SQLException
java.sql.SQLException
public static void buildIndex(java.sql.Connection con, java.lang.String schema, java.lang.String table, int commitInterval, ProgressMonitor progressMonitor) throws java.sql.SQLException
This procedure uses a non-nested connection that is committed independently of the connection that started the procedure.
spatialSchema
- spatialTable
- progressMonitor
-
java.sql.SQLException
public static void deSpatializeProc(java.lang.String schema, java.lang.String table) throws java.sql.SQLException
java.sql.SQLException
public static void deSpatialize(java.sql.Connection con, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
spatialSchema
- spatialTable
-
java.sql.SQLException
public static void insSpatial(java.lang.String schema, java.lang.String table, long id) throws java.sql.SQLException
schema
- The spatial schematable
- The spatial tableid
- The id of the row in the spatial table
java.sql.SQLException
public static void updSpatial(java.lang.String schema, java.lang.String table, long id) throws java.sql.SQLException
schema
- The spatial schematable
- The spatial tableid
- The id of the row in the spatial table
java.sql.SQLException
public static void delSpatial(java.lang.String schema, java.lang.String table, long id) throws java.sql.SQLException
schema
- The spatial schematable
- The spatial tableid
- The id of the row in the spatial table
java.sql.SQLException
public static void saveEntry(java.lang.String schema, java.lang.String table, long id) throws java.sql.SQLException
schema
- The spatial schematable
- The spatial tableid
- The id of the row in the spatial table
java.sql.SQLException
public static byte[] wktToWkb(java.lang.String wkt) throws com.vividsolutions.jts.io.ParseException
Note the Derby limitation on function arguments and return values that limits the size of WKT strings to 32,672 char and WKB arrays to 32,672 bytes.
WKT
-
com.vividsolutions.jts.io.ParseException
public static java.lang.String wkbToWkt(byte[] wkb) throws com.vividsolutions.jts.io.ParseException
Note the Derby limitation on function arguments and return values that limits the size of WKT strings to 32,672 char and WKB arrays to 32,672 bytes.
WKB
-
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet mbrIntersectsEnvFunc(java.lang.String schema, java.lang.String table, double minx, double maxx, double miny, double maxy) throws java.sql.SQLException
java.sql.SQLException
public static java.sql.ResultSet mbrIntersectsEnv(java.sql.Connection con, java.lang.String schema, java.lang.String table, double minx, double maxx, double miny, double maxy) throws java.sql.SQLException
con
- schema
- table
- minx
- maxx
- miny
- maxy
-
java.sql.SQLException
public static java.sql.ResultSet queryIntersectsWkbFunc(java.lang.String schema, java.lang.String table, byte[] wkb) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet queryIntersectsWkb(java.sql.Connection con, java.lang.String schema, java.lang.String table, byte[] wkb) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet queryIntersectsWktFunc(java.lang.String schema, java.lang.String table, java.lang.String wkt) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet queryIntersectsWkt(java.sql.Connection con, java.lang.String schema, java.lang.String table, java.lang.String wkt) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet queryWithPredicateWkbFunc(java.lang.String schema, java.lang.String table, java.lang.String predicate, byte[] wkb) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet queryWithPredicateWkb(java.sql.Connection con, java.lang.String schema, java.lang.String table, java.lang.String predicate, byte[] wkb) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet queryWithPredicateWktFunc(java.lang.String schema, java.lang.String table, java.lang.String predicate, java.lang.String wkt) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
public static java.sql.ResultSet queryWithPredicateWkt(java.sql.Connection con, java.lang.String schema, java.lang.String table, java.lang.String predicate, java.lang.String wkt) throws java.sql.SQLException, com.vividsolutions.jts.io.ParseException
java.sql.SQLException
com.vividsolutions.jts.io.ParseException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |