[Gvsig_english] Cannot add GeoDb table to a View

[Al Vigil]

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
> ***************************************************