<html><body bgcolor='#ffffff' style='margin-left:0px; font-size:9pt; margin:0px; font-family:Verdana; margin-left:0px; margin-right:0px; margin-top:0px; margin-bottom:0px; font-family: Verdana' ><FONT size=2> </FONT><P align=left>import java.sql.*; import java.util.*; import java.lang.*; import org.postgis.*; </P><P align=left>public class JavaGIS { public static void main(String[] args)</P><P align=left>{</P><P align=left>java.sql.Connection conn;</P><P align=left>try</P><P align=left>{</P><P align=left> Class.forName("org.postgresql.Driver");</P><P align=left> String url = "jdbc:postgresql://localhost:5432/database"; conn = DriverManager.getConnection(url, "postgres", ""); </P><P align=left> ((org.postgresql.jdbc2.Jdbc2Connection)conn).addDataType("Geometry","org.postgis.PGgeometry");<BR> ((org.postgresql.jdbc2.Jdbc2Connection)conn).addDataTy
pe("box3d","org.postgis.PGbox3d");</P><P align=left><FONT face=NimbusMonL-Regu-Extend_850 size=2> Statement s = conn.createStatement();</P><P align=left> ResultSet r = s.executeQuery("SELECT Buffer(GeometryFromText('POINT(10000 20000)',-1),20)");</P><P align=left> while( r.next() )</P><P align=left> {<FONT face=NimbusMonL-Regu-Extend_850 size=2></P><P align=left> PGgeometry geom= (PGgeometry)r.getObject(1);</P><P align=left> if( geom.getType() = Geometry.POLYGON )</P><P align=left> {</P><P align=left> Polygon pl = (Polygon)geom.getGeometry();</P><P align=left> for( int r = 0; r < pl.numRings(); r++ )</P><P align=left> {</P><P align=left> LinearRing rng = pl.ge
tRing(r);</P><P align=left> System.out.println("Ring: " + r);</P><P align=left> for( int p = 0; p < rng.numPoints(); p++ )</P><P align=left> {</P><P align=left> Point pt = rng.getPoint(p);</P><P align=left> System.out.println("Point: " + p);</P><P align=left> System.out.println(pt.toString());</P><P align=left> }</P><P align=left> }</P><P align=left> }</P></FONT><P align=left>}</P><P align=left>s.close();</P><P align=left>conn.close();</P><P align=left>}</P><P align=left>catch( Exception e )</P><P align=left>{</P><P align=left>e.printStackTrace();</P><P align=left>}</P><P align=left>}</P><P align=left>}</P><P align=left>Dear PostGis users,</P><P align=left>I want to use buf
fer function from POSTGIS but I simply cannot convert the result of query in a PGgeometry object. The line:</P><P align=left> PGgeometry geom= (PGgeometry)r.getObject(1);</P><P align=left>results always in:</P><P align=left>java.lang.ClassCastException: org.postgresql.util.PGobject</P><P align=left>I got result as a strine when i insert in qery function Astext(), but when I want to work with geometry I am helpless. Has anyone an idea how this problem could be solved?</P><P align=left>Thanking in advance</P></FONT><br><br><table cellpadding="0" cellspacing="0" border="0"><tr><td bgcolor="#000000"><img src="https://img.web.de/p.gif" width="1" height="1" border="0" alt="" /></td></tr><tr><td style="font-family:verdana; font-size:12px; line-height:17px;">Erweitern Sie FreeMail zu einem noch leistungsstärkeren E-Mail-Postfach! <br>Mehr Infos unter <A HREF="http://produkte.web.de/club/?mc=021131"><B>http://produkte.web.de/club/?mc=021131</B></A>&
nbsp; </td></tr></table></body></html>