Re: JDBC get object - (Geometry Postgis) - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: JDBC get object - (Geometry Postgis)
Date
Msg-id 1049814264.1744.66.camel@inspiron.cramers
Whole thread Raw
In response to Re: JDBC get object - (Geometry Postgis)  (Dave Cramer <Dave@micro-automation.net>)
List pgsql-jdbc
Pedro,

Sorry I was too quick, the code is still there the name of the
connection is different now

cast it to org.postgresql.PGConnection, then call

addDataType


here are the comments for it

    /*
     * This allows client code to add a handler for one of org.postgresql's
     * more unique data types.
     *
     * <p><b>NOTE:</b> This is not part of JDBC, but an extension.
     *
     * <p>The best way to use this is as follows:
     *
     * <p><pre>
     * ...
     *
((org.postgresql.Connection)myconn).addDataType("mytype","my.class.name");
     * ...
     * </pre>
     *
     * <p>where myconn is an open Connection to org.postgresql.
     *
     * <p>The handling class must extend org.postgresql.util.PGobject
     *
     * @see org.postgresql.util.PGobject
     */
    public void addDataType(String type, String name)
    {
        objectTypes.put(type, name);
    }


by default the following are defined, so you can overwrite them as long
as you use the same keys.

    private static final String defaultObjectTypes[][] = {
                {"box", "org.postgresql.geometric.PGbox"},
                {"circle", "org.postgresql.geometric.PGcircle"},
                {"line", "org.postgresql.geometric.PGline"},
                {"lseg", "org.postgresql.geometric.PGlseg"},
                {"path", "org.postgresql.geometric.PGpath"},
                {"point", "org.postgresql.geometric.PGpoint"},
                {"polygon", "org.postgresql.geometric.PGpolygon"},
                {"money", "org.postgresql.util.PGmoney"}
            };

Dave
On Tue, 2003-04-08 at 10:51, Dave Cramer wrote:
> Pedro,
>
> I think we have to put the code back which allows you to add types.
>
> I'm not sure where it went, but it appears to be gone??
>
> Dave
> On Tue, 2003-04-08 at 11:38, Pedro Salazar wrote:
> > On Tue, 2003-04-08 at 15:25, Dave Cramer wrote:
> > > Pedro,
> > >
> > > The geometry types are in the driver as
> > >
> > > org.postgresql.geometric.PGcircle,PGline ....
> > >
> > > Dave
> >
> > Hi Dave,
> >
> > Those objects are defined as well in the postgresql database as data
> > types, but how could I map them to postgis objects? Are them related or
> > compatible? Or should I transform/convert in a postgres function?
> >
> > And, to retrieve a geometry object, is it enough to do a simple
> > getObject(N) and after that cast it to the respective postgresql object?
> >
> > thanks,
> > Pedro Salazar.
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC get object - (Geometry Postgis)
Next
From: Todd Cornett
Date:
Subject: Bug in getImportedExportedKeys(), DatabaseMetaData class