Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Erreur 500 sur getProprietairesByParcelles #373

Closed
MaelREBOUX opened this issue Dec 21, 2017 · 1 comment
Closed

Erreur 500 sur getProprietairesByParcelles #373

MaelREBOUX opened this issue Dec 21, 2017 · 1 comment
Assignees
Labels
Milestone

Comments

@MaelREBOUX
Copy link
Member

On testait la méthode getProprietairesByParcelles et celle-ci répond par une Erreur 500
Exemple : https://portail.sig.rennesmetropole.fr/cadastrapp/services/getProprietairesByParcelles?parcelles=350238000DT0293

Ce service ne semble plus utilisé par cadastrapp lui-même sauf que sur le papier c'est intéressant pour aller le taper par script.

java.lang.RuntimeException: org.apache.cxf.interceptor.Fault: PreparedStatementCallback; bad SQL grammar 
[select parcelle, comptecommunal, app_nom_usage, app_nom_naissance, dlign3, dlign4, dlign5, dlign6, dldnss, jdatnss, ccodro_libfrom cadastrapp_arcopole.proprietaire prop, cadastrapp_arcopole.proprietaire_parcelle proparc  WHERE proparc.parcelle IN (?)  and prop.comptecommunal = proparc.comptecommunal 
AND cgocommune IN ('350240','350204','350238','350210','350079','350206','350144','350065','350088','350353','350047','350120','350216','350245','350001','350189','350076','350055','350351','350032','350058','350059','350024','350022','350131','350281','350180','350250','350196','350275','350197','350278','350039','350352','350139','350081','350315','350051','350066','350334','350080','350208','350363','350266' ) ]; 
nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
  Position : 151
@MaelREBOUX MaelREBOUX added the bug label Dec 21, 2017
@pierrejego pierrejego self-assigned this Jan 8, 2018
@pierrejego pierrejego added this to the v 1.6 milestone Jan 8, 2018
@pierrejego
Copy link
Member

pierrejego commented Jan 8, 2018

Ce service n'avait pas été testé, il manque juste un espace dans la requête.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants