Re: Geometery access via JDBC
From: Lee Fesperman (firstsql_at_ix.netcom.com)
Date: 08/20/04
- Next message: Tung Chau: "Mapping a UNIQUE pair of keys in a MySQL table into .hbm.xml in Hibernate"
- Previous message: Tung Chau: "Re: PLEASE HELP! Tomcat and Hibernate ServletException, net/sf/cglib/core/KeyFactory problem"
- In reply to: Laura P: "Geometery access via JDBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 20 Aug 2004 21:45:53 GMT
Laura P wrote:
>
> I was wondering if anyone knows if there is any vendor-inspecific way
> of storing and querying a polygon shape via the JDBC?
There really isn't a vendor-generic way of doing this.
> I currently have an application that stores a simple rectangle across
> 4 decimal columns: top left lat; top left lon; bottom left lat; bottom
> left lon. These are easy to populate and to query (to discover if a
> specified area is contained within the rectangle).
>
> However, I know have a new requirement that states that my stored
> geometery should be a polygon composed of one or more coordinates. I
> have been having difficulty defining a geometry structure that is
> efficient to query.
>
> I know there are various geometry functions in MySQL and Oracle, but I
> need a function that will work on both, and work across JDBC...
>
> If anyone could tell me if such a function exists, or can suggest a
> workaround I would be very grateful!
The best solution to those requirements would be an RDBMS that stores (Java) objects in
columns and offers access to object methods in SQL. Working across JDBC is then no
problem. Our ORDBMS (see my sig) does this, but there is no truly portable solution.
-- Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
- Next message: Tung Chau: "Mapping a UNIQUE pair of keys in a MySQL table into .hbm.xml in Hibernate"
- Previous message: Tung Chau: "Re: PLEASE HELP! Tomcat and Hibernate ServletException, net/sf/cglib/core/KeyFactory problem"
- In reply to: Laura P: "Geometery access via JDBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
