[Gvsig_english] gvSIG 1.1.2: Cannot load PostGIS-Layer

[Johannes Valenta]

Hi List,

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?
See the log file below.

Thanks,

Johannes

INFO AWT-EventQueue-1
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver - SQL> SELECT
ASBINARY(way, 'XDR'), 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
ERROR AWT-EventQueue-1
com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB - While
creating db layer: FEHLER: Syntaxfehler bei »,«

com.iver.cit.gvsig.fmap.drivers.DBException: FEHLER: Syntaxfehler bei »,«

    at
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.setData(Unknown
Source)
    at
com.prodevelop.cit.gvsig.vectorialdb.wizard.WizardVectorialDB.getLayer(Unknown
Source)
    at com.iver.cit.gvsig.AddLayer.loadGenericWizardPanelLayers(Unknown
Source)
    at com.iver.cit.gvsig.AddLayer.addLayers(Unknown Source)
    at com.iver.cit.gvsig.AddLayer.execute(Unknown Source)
    at com.iver.andami.plugins.ExtensionDecorator.execute(Unknown Source)
    at com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(Unknown Source)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.iver.andami.ui.AndamiEventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20090718/5c215bcb/attachment.htm