subject:"\[Gvsig_english\] Cannot add GeoDb table to a View"

Re: [Gvsig_english] Cannot add GeoDb table to a View

2012-08-23 Thread Francisco Puga

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

2012/8/18 Al Vigil albert.vi...@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.vi...@gmail.com
Subject: [Gvsig_english] Cannot add GeoDb table to a View
To: gvsig_internacional@listserv.gva.es
Message-ID: DBCBEB9F0C1543F29DCCA7E57A36BA09@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 afalci...@yahoo.it
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

___
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

Re: [Gvsig_english] Cannot add GeoDb table to a View (Antonio Falciano)

2012-08-20 Thread 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
 mailto: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

Re: [Gvsig_english] Cannot add GeoDb table to a View

2012-08-18 Thread 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

Hello to the community,

I am new to gvSIG and hoping someone can help with my learning curve.

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.

Thanks to anyone that can throw some light into this problem,

Al Vigil

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

Re: [Gvsig_english] Cannot add GeoDb table to a View (Antonio Falciano)

2012-08-18 Thread Al Vigil

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

2012-08-17 Thread Antonio Falciano

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

Re: [Gvsig_english] Cannot add GeoDb table to a View (Antonio Falciano)

Re: [Gvsig_english] Cannot add GeoDb table to a View

Re: [Gvsig_english] Cannot add GeoDb table to a View (Antonio Falciano)

Re: [Gvsig_english] Cannot add GeoDb table to a View

5 matches

Site Navigation

Mail list logo

Footer information