Hallo cuxland,
sorry for answering so late, but I
received your e-mail 4 days later.
1. First you must install PosgreSQL with PostGIS.
2. If you create a new database you must use the template
with postgis functions.
3. So in you new database you must have under
public>tables the two postgis-tables geometry_columns
and spatial_ref_sys.
4. Under public>functions you must have the postgis-functions!
Regards
Uwe Dalluege
--------------------------------------------------------------------------
HafenCity Universitaet Hamburg
Department Geomatik
Rechenzentrum
Dipl.-Ing. Uwe Dalluege :-)
Hebebrandstr. 1
22297 Hamburg
Tel.: +49 40 42827 - 5335 oder 5353 oder 5313
Fax: +49 40 42827 - 5409
E-Mail: mailto:[EMAIL PROTECTED]
Url: http://www.hcu-hamburg.de/geomatik/
--------------------------------------------------------------------------
cuxland schrieb:
Meanwhile I found the solution, I think.
I took another turn and found this thread
<http://postgis.refractions.net/pipermail/postgis-users/2007-September/017111.html>:
So I got aware of the *geometry_columns* and the *spatial_ref_sys*, all
to find under databases > Template_posgis > schemata > public > tables.
I also found those under databases > postgis (I'm using the pgAdmin III).
Having this in mind I didn't try to connect to my own database called
'OpenJump' any longer, but connect to the database 'Template_Postgis'
Now everything work's fine. My suggestion is to emphasize this matter of
fact more clearly in the Tutorial2.
And another question:
Is it possible just to copy *geometry_columns* and the *spatial_ref_sys*
to any other database so it'll work with postGIS (and OpenJump)?
Nevertheless - I'll try out... Maybe I can report a success again :-)
cuxland
cuxland schrieb:
Hi there,
I’m tired of two days trying and searching...
I just wanted to try out two tutorials (Tutorial1
<http://de.giswiki.net/wiki/PostGIS_Tutorial>, Tutorial2
<http://de.giswiki.net/wiki/OpenJUMP_Tutorial>). So I installed
*OpenJump v1.2D* running on *jdk1.5.0_14* under *Windows XP Pro SP2*.
The OpenJump PostGIS-Plugin I downloaded here from
<https://sourceforge.net/project/showfiles.php?group_id=118054&package_id=179545&release_id=464883>
and saved *JumpPostGIS61106B.jar *(Tutorial2 says something about
JumpPostGISrzcn.jar, but I think they are just talking about an older
version...) and *sridsupport.jar *into C:\Programme\OpenJUMP\lib\ext.
The JDBC-Driver out of the OpenJump-PostGIS-Plugin-Package
*postgresql-8.0.309..jdbc3.jar *I put into
C:\Programme\Java\jdk1.5.0_14\jre\lib\ext as destinationfolder
(meanwhile I also tried out C:\Programme\Java\jdk1.5.0_14\lib – no
success...)**
Besides I also installed *Postgres 8.3* and included *PostGIS 1.3.2*
with the Installation Stack Builder.
I was able to establish a connection from OpenJump to PostGIS (Ebenen
> Datenbankabfrage ausführen ........). But now I went on with the
Tutorial1 and tried to add the testdata
<http://de.giswiki.net/wiki/Bild:Testdaten_PostGIS_Tutorial.zip>:
opening it, changing the SRID e.g. to 4326 and trying to save it as a
new table into my PostGis database (in this case named ‘OpenJump’).
But all I got is the errormessage:
/AddGeometryColumn statement failed .../ (look at the Screenshot)
In one forum I found this thread
<http://osdir.com/ml/gis.jump.devel/2006-12/msg00027.html>. But I did
not understand what he meant. Somehow he had the same problem solving
it just by ‘spatially enable the database’ ... How?
I would be too glad if anybody could give me some advise! Thank you!
cuxland
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
