[GeoNetwork-users] postgis driver

Eugenio_Trumpy · March 4, 2014, 1:40pm

Dear all,

I set up a fresh geonetwork on a unbuntu server 12.04.
Geonetwork 2.10.3, runs in tomcat6, is a war version.
I set up a postgresql-postgis database both for storing metadata
and for managing spatial index. (postgresql vs 9.1.19 and postgis 2).

In config.xml I set postgis driver:
<resource enabled="true"><name>main-db</name><provider>jeeves.resources.dbms.ApacheDBCPool</provider><config><user>my_user</user><password>my_password</password><driver>org.postgresql.Driver</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://localhost:5432/geonetwork</url><poolSize>10</poolSize><validationQuery>SELECT 1</validationQuery></config></resource>
But using postgis.DriverWrapper seems doesn't work.

Thank you in advance

Eugenio

Jorge_Samuel_Mendes · June 19, 2014, 12:07pm

Hi to all

Not certain if someone replied to you, but anyway

I had the same problem but in may case was a mistake on the class name
:(, and therefore I stumbled into your email.

In your example the <url> is not correct (at least what I understand of
the system), this is what I use:

<url>jdbc:postgresql_postGIS://127.0.0.1:5432/geonetwork</url>

See the complete XML section here:

http://pastebin.com/xw5FEitr

Cheers
Jorge

On 03/04/2014 02:40 PM, Eugenio Trumpy wrote:

Dear all,

I set up a fresh geonetwork on a unbuntu server 12.04.
Geonetwork 2.10.3, runs in tomcat6, is a war version.
I set up a postgresql-postgis database both for storing metadata
and for managing spatial index. (postgresql vs 9.1.19 and postgis 2).

In config.xml I set postgis driver:
<resource enabled="true"><name>main-db</name><provider>jeeves.resources.dbms.ApacheDBCPool</provider><config><user>my_user</user><password>my_password</password><driver>org.postgresql.Driver</driver><url>jdbc:postgresql://localhost:5432/geonetwork</url><poolSize>10</poolSize><validationQuery>SELECT 1</validationQuery></config></resource>
But using postgis.DriverWrapper seems doesn't work.

Thank you in advance

Eugenio

------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

--
ISRIC - World Soil Information Post: PO box 353, 6700 AJ, Wageningen,
The Netherlands Visiting Address: Droevendaalsesteeg 3, 6708 PB
Wageningen (Bdg. 101), Office: C.013 Office Phone: +31 (0) 317 4 83715
Mobile Phone: +31 (0) 613 9 06950 OpenPGPKey: 0xA3D0065A