Hi,
I'm trying to configure a new Geonetwork 3 installed as a war file to connect to postGIS
Before that I have a Geonetwork 2.10 running with this configuration perfect:
---
<!-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -->
<!-- postgresql -->
<!-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -->
<resource enabled="true">
<name>main-db</name>
<provider>jeeves.resources.dbms.ApacheDBCPool</provider>
<config>
<user>geonetwork</user>
<password>xxxxxx</password>
<!-- we use org.postgis.DriverWrapper in place of
org.postgresql.Driver to support both postgresql and postgis -->
<!--
<driver>org.postgresql.Driver</driver>
-->
<driver>org.postgis.DriverWrapper</driver>
<!--
jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database
or if you are using postgis and want the spatial index loaded
into postgis
jdbc:postgresql_postGIS://host:port/database
-->
<url>jdbc:postgresql_postGIS://coobd:5432/gn</url>
<poolSize>10</poolSize>
<validationQuery>SELECT 1</validationQuery>
</config>
</resource>
---
I'm trying to edit config-node/srv.xml file to use config-db/postgresql.xml and config-db/jndi-postgres-postgis.xml
In first case I changed 2 lines:
<!--<constructor-arg value="org.postgresql.Driver"/> -->
<constructor-arg value="org.postgis.DriverWrapper"/>
<!--<constructor-arg value="jdbc:postgresql://${jdbc.host}:5432/${jdbc.database}"/> -->
<constructor-arg value="jdbc:postgresql_postGIS://${jdbc.(user, pass, host, dbhost}:5432/${jdbc.database}"/>
Then I update jdbc.properties (user, pass, host, db)
After that I create a clean PostGIS database with that parameters
Then reboot geonetwork but a lot of SEVERE errors related to datasource
Anybody knows the configuration of a GN 3 with PostGIS?
Thanks a lot
Òscar
--
_______________________________________________________________________
Oscar Chic
Sotsdirector Tècnic
Institut de Ciències del Mar (ICM-CSIC) Tel: +34 932309529
Pg. Marítim de la Barceloneta, 37-49 Fax: +34 932309555
08003 Barcelona, Spain email: ochic@anonymised.com
_______________________________________________________________________