Re: [Gvsig_english] Cannot add GeoDb table to a View
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@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
Re: [Gvsig_english] Cannot add GeoDb table to a View
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" > Subject: [Gvsig_english] Cannot add GeoDb table to a View > To: > Message-ID: > 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 > Subject: Re: [Gvsig_english] Cannot add GeoDb table to a View > To: gvsig_internacional@listserv.gva.es > Message-ID: <502ea040.2090...@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 > > > -- > > ___
Re: [Gvsig_english] Cannot add GeoDb table to a View
I'm sorry but version 1.12 will not include driver for PostGIS 2.0 2012/8/18 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" >> Subject: [Gvsig_english] Cannot add GeoDb table to a View >> To: >> Message-ID: >> 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 >> Subject: Re: [Gvsig_english] Cannot add GeoDb table to a View >> To: gvsig_internacional@listserv.gva.es >> Message-ID: <502ea040.2090...@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
Re: [Gvsig_english] Cannot add GeoDb table to a View (Antonio Falciano)
Antonio,
The problem is solved. I followed up with postgis via the ticket you mentioned
in your message. Their advise, to install legacy.sql, fixed the problem. This
is what posgis said:
Comment(by robe):
Al,
You can try installing the legacy.sql file packaged with PostGIS 2.0 that
is in share/contrib/postgis-2.0 folder (where the other PostGIS scripts
are). That reinstalls all the legacy functions we took out and resolves
many of these kinds of issues.
If that still doesn't work, can you turn on logging on your database and
let us know what errors you are seeing in the logs.
to turn on logging do the following - replace mygisdb with the name of the
database you are connecting to.
{{{
ALTER DATABASE mygisdb SET log_statement='all';
}}}
The logs are usually written to the pg_logs folder of your PostgreSQL data
folder.
Check the latest one -- usually notes the missing function or issue with
call.
> 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@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@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
Re: [Gvsig_english] Cannot add GeoDb table to a View (Antonio Falciano)
Al,
I'm happy to know that legacy.sql solves these compatibility issues.
Thanks for sharing your follow up.
Cheers,
Antonio
Il 19/08/2012 2.57, Al Vigil ha scritto:
> Antonio,
> The problem is solved. I followed up with postgis via the ticket you
> mentioned in your message. Their advise, to install legacy.sql, fixed
> the problem. This is what posgis said:
>
> /Comment(by robe):/
> //
> / Al,/
> //
> / You can try installing the legacy.sql file packaged with PostGIS
> 2.0 that
> is in share/contrib/postgis-2.0 folder (where the other PostGIS
> scripts
> are). That reinstalls all the legacy functions we took out and
> resolves
> many of these kinds of issues./
> //
> / If that still doesn't work, can you turn on logging on your
> database and
> let us know what errors you are seeing in the logs./
> //
> / to turn on logging do the following - replace mygisdb with the
> name of the
> database you are connecting to./
> //
> / {{{
> ALTER DATABASE mygisdb SET log_statement='all';
> }}}/
> //
> / The logs are usually written to the pg_logs folder of your
> PostgreSQL data
> folder.
> Check the latest one -- usually notes the missing function or
> issue with
> call.
> /
> > 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@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@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
--
Antonio Falciano
http://www.linkedin.com/in/antoniofalciano
___
Gvsig_internacional mailing list
Gvsig_internacional@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
