Re: JDBC get object - (Geometry Postgis)

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(at)micro-automation(dot)net>