Hi List,<br>
<br>
I am using gvSIG 1.1.2 and I am trying to load a PostGIS Layer.
Unfortunately it does not work. I am not sure where the error occurs or
what I can improve at the PostGIS-DB to make the connection work. Any
hints?<br>
See the log file below.<br>
<br>
Thanks,<br>
<br>
Johannes<br>
<br>
INFO AWT-EventQueue-1
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver - SQL&gt;
SELECT ASBINARY(way, &#39;XDR&#39;), osm_id, access, admin_level, aerialway,
aeroway, amenity, area, bicycle, bridge, boundary, building, cutting,
disused, embankment, foot, highway, horse, junction, landuse, layer,
learning, leisure, man_made, military, motorcar, name, natural, oneway,
power, power_source, place, railway, ref, religion, residence, route,
sport, tourism, tracktype, tunnel, waterway, width, wood, z_order,
way_area, id FROM public.planet_osm_line  ORDER BY id<br>
ERROR AWT-EventQueue-1
com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB - While
creating db layer: FEHLER: Syntaxfehler bei »,«<br>
<br>
com.iver.cit.gvsig.fmap.drivers.DBException: FEHLER: Syntaxfehler bei »,«<br>
<br>
    at com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.setData(Unknown Source)<br>
    at com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.getLayer(Unknown Source)<br>
    at com.iver.cit.gvsig.AddLayer.loadGenericWizardPanelLayers(Unknown Source)<br>
    at com.iver.cit.gvsig.AddLayer.addLayers(Unknown Source)<br>
    at com.iver.cit.gvsig.AddLayer.execute(Unknown Source)<br>
    at com.iver.andami.plugins.ExtensionDecorator.execute(Unknown Source)<br>
    at com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(Unknown Source)<br>
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)<br>
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)<br>
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)<br>
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)<br>
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)<br>
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)<br>
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)<br>
    at java.awt.Component.processMouseEvent(Unknown Source)<br>
    at javax.swing.JComponent.processMouseEvent(Unknown Source)<br>
    at java.awt.Component.processEvent(Unknown Source)<br>
    at java.awt.Container.processEvent(Unknown Source)<br>
    at java.awt.Component.dispatchEventImpl(Unknown Source)<br>
    at java.awt.Container.dispatchEventImpl(Unknown Source)<br>
    at java.awt.Component.dispatchEvent(Unknown Source)<br>
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)<br>
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)<br>
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)<br>
    at java.awt.Container.dispatchEventImpl(Unknown Source)<br>
    at java.awt.Window.dispatchEventImpl(Unknown Source)<br>
    at java.awt.Component.dispatchEvent(Unknown Source)<br>
    at java.awt.EventQueue.dispatchEvent(Unknown Source)<br>
    at com.iver.andami.ui.AndamiEventQueue.dispatchEvent(Unknown Source)<br>
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)<br>
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)<br>
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br>
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br>
    at java.awt.EventDispatchThread.run(Unknown Source)<br>