Re: First build of PostGIS module of GeoTools2. Need to

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Carlos Ho Shih Ning <cning(at)atech(dot)br>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: First build of PostGIS module of GeoTools2. Need to
Date: 2003-11-25 17:00:23
Message-ID: 1069779623.1628.5.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Carlos,

You may have better luck posting this on the geotools site.

http://jira.codehaus.org/secure/BrowseProject.jspa?id=10270

Dave
On Tue, 2003-11-25 at 09:35, Carlos Ho Shih Ning wrote:
> Hi,
>
> The first build of the GeoTools2 is almost OK except that of PostGIS.
> This is module that I am most interested in.
> By doing "maven test" in PostgisTest.java (excluding all other tests) only.
>
> I am getting the following console message excerpt
> .....
> [junit] 25/11/2003 11:03:39 org.geotools.data.postgis.PostgisTest setUp
> [junit] INFO: exception while making schemaCouldn't make schema: org.geotool
> s.data.DataSourceException: no geometry found in the GEOMETRY_COLUMNS table fo
> r jdbc_test of the postgis install. A row for geom is required for geotools t
> o work correctly
> [junit] 25/11/2003 11:03:39 org.geotools.data.postgis.PostgisTest testMaxFea
> tures
> [junit] INFO: ...threw data source exceptionorg.geotools.data.DataSourceExce
> ption: Couldn't make schema: org.geotools.data.DataSourceException: no geometry
> found in the GEOMETRY_COLUMNS table for jdbc_test of the postgis install. A r
> ow for geom is required for geotools to work correctly
> ......
>
> I installed PostGreSQL/PostGIS correctly and tested with the accompanying sample of the PostGIS
> and it worked perfectly. Now I am wondering if any additional sql script is needed to load into PostGre, besides postgis.sql,
> in order to make the GeoTools run properly.
>
> I guess that the table geometry_columns must be loaded. So, is there any standard procedure for doing that?
> Do I need to run the samples in some specified order?
>
> thanks a lot
> Carlos
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Joseph Shraibman 2003-11-25 17:39:11 Re: Problem with 7.4 driver
Previous Message Maffeo Gaetano 2003-11-25 16:43:53 Connection.setCatalog("DBNAME") does not work.....