[postgis-users] Postgis Java JDBC
erwan.bocher at wanadoo.fr
Wed Apr 13 01:05:57 PDT 2005
For example my request is :
Select Buffer(the_geom, 3000) As the_geom from parcels INTO results
select intersection (p1.the_geom, p2.the_geom) into tabintersection from
parcels1 p1, parcels1 p2 where p1.the_geom && p2.the_geom and p1.gid <>
>>I tried to create a small GUI to send SQL command to Postgis using JDBC
>>driver (downloaded in the postgis
>>cvs, or.postgis.DriverWrapper). The aim is to display the result in a
>>Jtable or integrate it into JumpGIS as a layer.The
>>org.postgis.DriverWrapper works well but when I execute a spatial
>>request the table isn't recognized by postgis.. A simple table is
>>created and the geometry_columns isn't udpated with my new table.
>>My code to execute a request :
>>result = rq.executeQuery(request); where the request is a command
>>writting in a JPanel.
>Which are the exact "spatial requests" you execute that should create
>Did you read what I wrote you about addGeometryColumn()?
More information about the postgis-users