Bonjour,
Etrange, le problème semble venir de la requête "Select count(*) exist
from Relations where..."
En version 8.4 de postgres, l'usage de AS pour l'alias n'est pas
obligatoire. Vous ne devriez donc pas avoir cette erreur.
Cf. http://www.postgresql.org/docs/8.4/static/sql-select.html
En version 9 je ne rencontre pas le problème avec la dernière version
de GéoSource.
Vous pouvez appliquer la correction suivante manuellement :
Modified: trunk/web/src/main/java/org/fao/geonet/services/relations/Insert.java
--- trunk/web/src/main/java/org/fao/geonet/services/relations/Insert.java
2010-10-07 07:53:39 UTC (rev 6638)
+++ trunk/web/src/main/java/org/fao/geonet/services/relations/Insert.java
2010-10-07 10:28:46 UTC (rev 6639)
@@ -67,7 +67,7 @@
Dbms dbms = (Dbms) context.getResourceManager()
.open(Geonet.Res.MAIN_DB);
- String query = "Select count(*) exist from Relations
where id=? and relatedId=?";
+ String query = "Select count(*) as exist from
Relations where id=? and relatedId=?";
Element record = dbms.select(query, parentId,
childId).getChild("record");
boolean exist = false;
if (record.getChild("exist").getText().equals("1")) {
Salutations.
Francois
Le 25 janvier 2011 09:45, chauveau <chloe.chauveau@anonymised.com> a écrit :
Bonjour,
Ci-dessous le geonetwork.log lorsque l'on reproduit l'erreur d'association :
2011-01-25 09:33:01,521 ERROR [geonetwork.search] - Errors occurred when
trying to parse a filter:
2011-01-25 09:33:01,536 ERROR [geonetwork.search] -
----------------------------------------------
2011-01-25 09:33:01,536 ERROR [geonetwork.search] -
org.xml.sax.SAXParseException: cvc-complex-type.2.4.b: The content of
element 'ogc:And' is not complete. One of
'{"http://www.opengis.net/ogc":comparisonOps,
"http://www.opengis.net/ogc":spatialOps,
"http://www.opengis.net/ogc":logicOps\}' is expected.
2011-01-25 09:33:01,536 ERROR [geonetwork.search] -
----------------------------------------------
2011-01-25 09:33:04,833 ERROR [jeeves.service] - Exception when executing
service
2011-01-25 09:33:04,833 ERROR [jeeves.service] - (C) Exc :
org.postgresql.util.PSQLException: ERROR: syntax error at or near "exist"
Merci d'avance pour votre aide complémentaire.
Cordialement,
Chloé Chauveau
--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Association-Metadonnees-et-catalogue-d-attributs-tp5940379p5957957.html
Sent from the GeoNetwork users francophone mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
GeoNetwork-users-fr mailing list
GeoNetwork-users-fr@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users-fr