[Gvsig_usuarios] Invalid character or codec problem

[Bruno Cesarino]

Hi, I'm new in this group and also in the development for gvSIG. I've made a
plug-in that read data from a Postgrs database and create a new layer in the
current view. The problem is that it doesn´t work with the connector
included in the version 1.1 of gvSIG (postgresql-74.213.jar). If I replace
the connector with a higher version, i. e. postgresql-8.3-604.jdbc3.jar, it
works fine. Can anyone help me to make it work with any version of this
connector. The error message is listed bellow:

SqlAux getFeatureIterator = SELECT ASBINARY(the_geom, 'XDR'), gid FROM
brasil.braprj5 WHERE REGIAO IN
('214','216','217','219','220','221','222','225','227','228','229','231','232','234','235','237','241','242','244','245','247','248','249','250','252','256','258','259','261','265','266','267','269','270','271','272','274','275','278','279','280','281','283','284','285','286','287','288','291','292','294','295','296','297','301','304','307','308','309','310','311','313','314','317','320','321','322','324','325','326','331','332','336','337','339','341','342','343','346','350','351','353','354','355','356')
AND the_geom && GeometryFromText('LINESTRING(-59.15948247986953
-9.84083652496338, -45.79887628477887 -9.84083652496338, -45.79887628477887
2.59138917922974, -59.15948247986953 2.59138917922974)', 4291)
MapContextListener redraw
com.iver.cit.gvsig.fmap.DriverException: org.postgresql.util.PSQLException:
Invalid character data was found.  This is most likely caused by stored data
containing characters that are invalid for the character set the database
was created in.  The most common example of this is storing 8bit data in a
SQL_ASCII database.
    at
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisFeatureIterator.next(PostGisFeatureIterator.java:200)
    at
com.iver.cit.gvsig.fmap.operations.strategies.DBStrategy.draw(DBStrategy.java:161)
    at com.iver.cit.gvsig.fmap.layers.FLyrVect.draw(FLyrVect.java:357)
    at com.iver.cit.gvsig.fmap.layers.FLayers.draw(FLayers.java:653)
    at com.iver.cit.gvsig.fmap.layers.FLayers.draw(FLayers.java:464)
    at com.iver.cit.gvsig.fmap.MapContext.draw(MapContext.java:840)
    at
com.iver.cit.gvsig.fmap.MapControl$PaintingRequest.paint(MapControl.java:526)
    at
com.iver.cit.gvsig.fmap.MapControl$Drawer2$Worker.run(MapControl.java:627)
    at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: Invalid character data was
found.  This is most likely caused by stored data containing characters that
are invalid for the character set the database was created in.  The most
common example of this is storing 8bit data in a SQL_ASCII database.
    at org.postgresql.core.Encoding.decodeUTF8(Encoding.java:287)
    at org.postgresql.core.Encoding.decode(Encoding.java:182)
    at org.postgresql.core.Encoding.decode(Encoding.java:198)Layer SIGEPRO
156 milisecs.

    at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:201)
    at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getFixedString(AbstractJdbc1ResultSet.java:787)
    at
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:282)
    at
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.getFieldValue(PostGisDriver.java:455)
    at
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisFeatureIterator.next(PostGisFeatureIterator.java:173)
    ... 8 more

Thanks in advance,

Bruno C. S.
bruno.soares en mma.gov.br
MMA - Brazil.
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: http://runas.cap.gva.es/pipermail/gvsig_usuarios/attachments/20090113/fc854da3/attachment.htm