[GeoMoose-users] search Java error

[Dan Little]

This is an error in GeoServer. You’re trying to do a “like” search against
an integer field. Check your data types in GeoServer.

On Fri, Jun 10, 2022 at 13:34 James Klassen <klassen.js at gmail.com> wrote:

> How did you get GeoMoose (which isn’t written in Java) to throw a Java
> exception with the text of a PostgreSQL hint message?
>
> Based on the PostgreSQL hint, my guess is you have a bad SQL statement
> and/or a statement that was expecting a value passed in and got nothing
> instead.
>
> On Fri, Jun 10, 2022 at 10:54 <ihara.olivera at imm.gub.uy> wrote:
>
>> Hi there does anyone has an idea of why this error ocurr when trying a
>> search?
>> java.lang.RuntimeException: java.io.IOException java.io.IOExceptionERROR:
>> operator does not exist: integer ~~ unknown Hint: No operator matches the
>> given name and argument type(s). You might need to add explicit type casts.
>> Position: 81
>> thanks in advance,
>> Belen
>>
>>  ------------------------------
>>
>> El presente correo electrónico y cualquier posible archivo adjunto esta dirigido únicamente al destinatario del mismo y contiene información que puede ser confidencial. Si Ud. no es el destinatario correcto por favor notifique al remitente respondiendo este mensaje y elimine inmediatamente de su sistema, el correo electrónico y los posibles archivos adjuntos al mismo. Esta prohibida cualquier utilización, difusión o copia de este correo electrónico por cualquier persona o entidad que no sean las especificas destinatarias del mensaje. La Intendencia de Montevideo no acepta ninguna responsabilidad con respecto a cualquier comunicación que haya sido emitida incumpliendo nuestra normativa municipal, así como lo previsto en la Ley 18.331 de Protección de Datos Personales y la Ley 18.381 de Acceso a la Información Publica.
>>
>> This e-mail and any attachment is confidential and is intended solely for the addressee(s). If you are not intended recipient please inform the sender immediately, answering this e-mail and delete it as well as the attached files. Any use, circulation or copy of this e-mail by any person or entity that is not the specific addressee(s) is prohibited. The City Council of Montevideo is not responsible for any communication emitted without respecting our Organization Policy or the Data Protection Act and Habeas Data Action No. 18.331 and the Information Access Act N 18.381.
>>
>>
>> _______________________________________________
>> GeoMoose-users mailing list
>> GeoMoose-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/geomoose-users
>>
> _______________________________________________
> GeoMoose-users mailing list
> GeoMoose-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geomoose-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20220610/63574b09/attachment-0001.htm>