[Gvsig_english] Cannot add GeoDb table to a View

[Francisco Puga]

I'm sorry but version 1.12 will not include driver for PostGIS 2.0

2012/8/18 Al Vigil <albert.vigil at gmail.com>:
> Thank you, Antonio, for the prompt reply.  It is not the answer I was hoping
> for, unfortunately.
>
> I will wait for the next release of gvSIG and try it again at that time.
>
> Al Vigil
>
>
>> Message: 1
>> Date: Fri, 17 Aug 2012 14:12:48 -0500
>> From: "Al Vigil" <albert.vigil at gmail.com>
>> Subject: [Gvsig_english] Cannot add GeoDb table to a View
>> To: <gvsig_internacional at listserv.gva.es>
>> Message-ID: <DBCBEB9F0C1543F29DCCA7E57A36BA09 at AlLaptop>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> Hello to the community,
>>
>> I am new to gvSIG and hoping someone can help with my learning curve.
>>
>> I am trying to add a GeoDB to a view, but nothing displays on the map.
>> However I am able to see the attribute table,
>> so it appears the file loads OK.  Also, when I double-click on the layer I
>> am able to specify the symbol to use.
>> But on returning from the Layer properties form the Information console
>> displays the following,
>>
>>  gvSIG had an unexpected problem. Current process was aborted. Error
>> message is:
>>
>>  Can?t read the driver: PostGIS JDBC Driver
>>
>>  PSQLException: ERROR: current transaction is aborted, commands ignored
>> until end of transaction ... (27
>>
>>  more)
>>
>>  If this message does not help avoid the problem, it's recommended (once
>> your current session is over)
>>
>>  to send the log file to the gvSIG team. Log file is located here::
>>
>>  C:\Users\Al\gvsig\gvSIG.log
>>
>> The pertinent contents of the log file are,
>>
>>  ...
>>
>> DEBUG
>>
>>  AWT-EventQueue-0 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
>> 125502 KB
>>  DEBUG AWT-EventQueue-0 com.iver.andami.messages.NotificationManager -
>> Can?t read the driver: PostGIS
>>
>>  JDBC Driver
>>  Can?t read the driver: PostGIS JDBC Driver
>>   at
>> com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.getFullExtent
>>
>>  (PostGisDriver.java:359)
>>
>> ...
>>
>> I am also attaching the complete log file, in case I missed any important
>> clues in the above snippet.
>>
>> Based on a recommendation I found on the Internet that suggested the
>> problem is with the JDBC driver,
>> I downloaded and copied to CLASSPATH directory the file
>> postgresql-9.1-902.jdbc.jar(from
>>
>> http://jdbc.postgresql.org/download.html), however this did not make any
>> difference. The CLASSPATH
>>
>> directory on my pc is .;c:\Program Files\Java\jre7\lib\;C:\Program
>> Files\Java\jre7\lib\ext\. Perhaps I should put it somewhere else?
>>
>> I have no trouble displaying shp files, only PostGis GeoDb tables.
>>
>> Am using the binaries for Postgresql 9.1 and PostGis 2.0.1 running under
>> Windows Vista.  The vectors
>> are stored in a geometry column and am using projection 4326 on the View,
>> the same projection as the table.
>>
>> Thanks to anyone that can throw some light into this problem,
>>
>> Al Vigil
>>
>> Developer, pchomes, inc., Addison, TX, USA
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20120817/a446f622/attachment.html
>> -------------- next part --------------
>> A non-text attachment was scrubbed...
>> Name: gvSIG.log
>> Type: application/octet-stream
>> Size: 51342 bytes
>> Desc: not available
>> Url :
>> http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20120817/a446f622/attachment-0001.obj
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Fri, 17 Aug 2012 21:49:20 +0200
>> From: Antonio Falciano <afalciano at yahoo.it>
>> Subject: Re: [Gvsig_english] Cannot add GeoDb table to a View
>> To: gvsig_internacional at listserv.gva.es
>> Message-ID: <502EA040.2090503 at yahoo.it>
>> Content-Type: text/plain; charset=ISO-8859-15; format=flowed
>>
>> Il 17/08/2012 21.12, Al Vigil ha scritto:
>>> I have no trouble displaying shp files, only PostGis GeoDb tables.
>>> Am using the binaries for Postgresql 9.1 and PostGis 2.0.1 running under
>>> Windows Vista.  The vectors
>>> are stored in a geometry column and am using projection 4326 on the
>>> View, the same projection as the table.
>>
>> Hi Al,
>> I think that the issue is probably due to your PostGIS version, because
>> gvSIG 1.1x actually supports only PostGIS 1.x and not the latest 2.0.
>> In reference to this there's also a ticket in the PostGIS bug tracker [1].
>> IMHO adding the PostGIS 2.0 support is a useful feature request, but I
>> don't know if developers have enough time and resources to solve this
>> problem right now that gvSIG 1.12 final is going to be released.
>>
>> Cheers,
>> Antonio
>>
>> [1] http://trac.osgeo.org/postgis/ticket/833
>>
>> --
>> Antonio Falciano
>> http://www.linkedin.com/in/antoniofalciano
>>
>>
>> ------------------------------
>>
>> _______________________________________________
>> Gvsig_internacional mailing list
>> Gvsig_internacional at listserv.gva.es
>> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>>
>>
>> End of Gvsig_internacional Digest, Vol 79, Issue 10
>> ***************************************************
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
>
> To see the archives, edit your preferences or unsubscribe from this mailing list, please access this url:
>
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional



-- 
Francisco Puga
Grupo de Desarrollo
Cartolab - Laboratorio de Ingeniería Cartográfica.
http://www.cartolab.es

ETS Ingeniería de Caminos, Canales y Puertos
Universidade da Coruña
Campus de Elviña - 15071 A Coruña (España)
(34)981167000 ext. 5493