I'm not sure about the support for geography but I see you need a comma between id and locGeog
-- charles On Feb 2, 2012, at 5:58 PM, Jay Moss <[email protected]> wrote: > Is there any support for the Geography data type in the PostGIS JDBC driver? > > I received a classCastException if I try to cast a Geography colum to a > PGgeometry: > > my table: > > CREATE TABLE k16View ( > id character varying(255) NOT NULL, > locGeog geography > CONSTRAINT k16View_pkey PRIMARY KEY (id)); > > my code: > ... > ResultSet r = s.executeQuery("select id locGeog from k16View"); > String trackNumber = r.getString(1); > PGgeometry geog = (PGgeometry) r.getObject(2); // throws ClassCastException > > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
