<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16448">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Hello to the community,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>I am new to gvSIG and hoping someone can help with
my learning curve. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>I am trying to add a GeoDB to a view, but nothing
displays on the map. However I am able to see the </FONT><FONT size=2
face=Arial>attribute table, </FONT></DIV>
<DIV><FONT size=2 face=Arial>so it appears the file loads OK. Also, when I
double-click on the layer I am able to </FONT><FONT size=2 face=Arial>specify
the symbol to use. </FONT></DIV>
<DIV><FONT size=2 face=Arial>But on returning from the Layer properties form the
Information console </FONT><FONT size=2 face=Arial>displays the
following,</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px" dir=ltr>
<DIV><FONT size=2 face=Arial><EM>gvSIG had an unexpected problem. Current
process was aborted. Error message is:</EM></FONT></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT size=2 face=Arial><EM>Canīt read the driver: PostGIS JDBC Driver
</EM></FONT></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT size=2 face=Arial><EM>PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction ... (27 </EM></FONT></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT size=2 face=Arial><EM>more)</EM></FONT></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT size=2 face=Arial><EM>If this message does not help avoid the
problem, it's recommended (once your current session is over)
</EM></FONT></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT size=2 face=Arial><EM>to send the log file to the gvSIG team. Log
file is located here::</EM></FONT></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT size=2
face=Arial><EM>C:\Users\Al\gvsig\gvSIG.log</EM></FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>The pertinent contents of the log file
are,</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px" dir=ltr>
<DIV><FONT
face=Arial>...<BR>
DEBUG </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial>AWT-EventQueue-0 com.iver.andami.ui.mdiFrame.MDIFrame -
Memory usage 125502 KB<BR>DEBUG AWT-EventQueue-0
com.iver.andami.messages.NotificationManager - Canīt read the driver: PostGIS
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial>JDBC Driver <BR>Canīt read the driver: PostGIS JDBC
Driver <BR> at
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.getFullExtent</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial>(PostGisDriver.java:359)</FONT></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>...</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>I am also attaching the complete log file, in case
I missed any important clues in the above snippet.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>Based on a recommendation I found on the Internet
that suggested the problem is with the JDBC driver,<BR>I downloaded and copied
to CLASSPATH directory the file postgresql-9.1-902.jdbc.jar(from </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial><A
href="http://jdbc.postgresql.org/download.html">http://jdbc.postgresql.org/download.html</A>),
however this did not make any difference. The CLASSPATH </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>directory on my pc is .;c:\Program
Files\Java\jre7\lib\;C:\Program Files\Java\jre7\lib\ext\. Perhaps I </FONT><FONT
size=2 face=Arial>should put it somewhere else?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>I have no trouble displaying shp files, only
PostGis GeoDb tables.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>Am using the binaries for Postgresql 9.1 and
PostGis 2.0.1 running under Windows Vista. The vectors </FONT></DIV>
<DIV><FONT size=2 face=Arial>are stored in a geometry column and am using
projection 4326 on the View, the same projection as the </FONT><FONT size=2
face=Arial>table.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>Thanks to anyone that can throw some light into
this problem,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>Al Vigil</FONT></DIV>
<DIV><FONT size=2 face=Arial><BR>Developer, pchomes, inc., Addison, TX,
USA</FONT></DIV></BODY></HTML>