Paul,<br> I followed your suggestions - and my pg logs show that what is happening is that the client is querying for relations that are not schema qualified therefore there are a whole lot of errors saying that <br>"relation <geom table name> does not exist". I have tried to create Postgis Tables in the public schema but for wahtever reason Udig is not seeing them.
<br><br>I do think that the problem lies with the older Postgis driver not understanding schema's as the logged client requests that generate errors are not schema qualified.<br><br>I tried a trivial JDBC connection using Coldfusion connected to a JDBC data source. Queries like this:
<br><br><cfquery name="geomtest" datasource="jdbc.env_db"><br>SELECT gid, tag, AsText(the_geom) as geostring from shapes.bompah3<br></cfquery><br><br>Generate the expected output.<br><br>
I also tried area, centroid, intersection and a number of other queries and all returned the expected results, all issued over a JDBC connection between Postgres and Cold Fsuion.<br><br>I tried the same thing setting up a data source in OpenOffice
2.0 and running Postgis Functions like area as queries against Postgis Tables over a JDBC connection, and all queries returned the expected results.<br><br>In addition QGis on both windows and Linux (which uses an embedded Posgresql C library) has no problems with any of the Postgresql/Postgis servers.
<br><br>Could you give me the connection parameters to test instance and I will give that a try, though being on a satellite connection I sometimes have trouble with applications that have timeouts set below the latency to be expected on such a connection.
<br><br>Cheers<br>Johan Wehtje<br><br><br><br><div><span class="gmail_quote">On 12/3/05, <b class="gmail_sendername">Paul Ramsey</b> <<a href="mailto:pramsey@refractions.net">pramsey@refractions.net</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Johan,<br> I have been following your emails on the udig list as well, and<br>the fact that other users can connect to postgis fine indicates to me
<br>that the problem is likely not something as broad as a jdbc driver<br>problem, or else everyone would be having troubles.<br> There is something particular about your setup which is the key,<br>but it's hard to know what. One thing you could do is turn on
<br>statement logging in postgresql.conf and watch the log while udig<br>connects, see how far it gets, so you can see what return value it is<br>choking on. You could also try to write some trivial JDBC<br>applications that connect and pull back geometries and see if things
<br>die there. It is too bad you cannot connect to our test instance,<br>since that takes your particular server configuration right out of<br>the testing equation.<br>Paul<br><br>On 2-Dec-05, at 8:44 PM, Johan Wehtje wrote:
<br><br>> I have for some weeks now been trying to track down why i have not<br>> been able to get Postgis working with Udig and have managed to<br>> determine that the problem appears to lie with the Postgis JDBC
<br>> driver which I think is the same as the Jump Plugin.<br>><br>> I have not yet built the Latest version from CVS as as I have to<br>> first install a JDK. I don't know how much work has been done since<br>
> the release of the Postgresql 7.4 compatible release, but with both<br>> Udig and Jump dpending on this driver to use Postgis it would be<br>> nice to see it updated to support 8.x Postgresql and 1.0.x Postgis<br>
> and a ready built Jar made available.<br>><br>> Cheers<br>> Johan Wehtje<br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br></blockquote></div><br>