It could be a problem with captial letters in table names. Towards the bottom of your error message it reads:
Caused by: org.postgresql.util.PSQLException: ERROR: relation "public.TstPostGIS" does not exist Try storing that table as "public.tstpostgis" (all small caps) instead. Handling capitalization in SQL is an absolute pain in the a** because every SQL server has its own ideas about how that should be done. Hope that helps. Ben ----- Original Message ----- From: "BERNO84" <[email protected]> To: "gvsig internacional" <[email protected]> Sent: Monday, May 17, 2010 10:10:31 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: Re: [Gvsig_english] gvSIG 1.9 error message: Can`t initialize writer: POSTGIS Writer Hi, I have the same problem. Character table is set ok. This is what I recive in error log: Can´t initialize writer: PostGIS Writer at com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.initialize(PostGISWriter.java:104) at com.iver.cit.gvsig.gui.cad.MyFinishAction.performAction(MyFinishAction.java:204) at jwizardcomponent.DefaultJWizardComponents.finishButton_actionPerformed(Unknown Source) at jwizardcomponent.DefaultJWizardComponents$4.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.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(AndamiEventQueue.java:58) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.Dialog$1.run(Unknown Source) at java.awt.Dialog$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Unknown Source) at java.awt.Component.show(Unknown Source) at java.awt.Component.setVisible(Unknown Source) at java.awt.Window.setVisible(Unknown Source) at java.awt.Dialog.setVisible(Unknown Source) at com.iver.core.mdiManager.NewSkin.addJDialog(NewSkin.java:447) at com.iver.core.mdiManager.NewSkin.addWindow(NewSkin.java:234) at com.iver.cit.gvsig.CreateNewLayer.execute(CreateNewLayer.java:137) at com.iver.andami.plugins.ExtensionDecorator.execute(ExtensionDecorator.java:89) at com.iver.andami.ui.mdiFrame.MDIFrame.actionPerformed(MDIFrame.java:678) 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.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.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.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at com.iver.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:58) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(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) Caused by: org.postgresql.util.PSQLException: ERROR: relation "public.TstPostGIS" does not exist at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:298) at com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGISWriter.initialize(PostGISWriter.java:84) ... 67 more I'm using gvSig 1.9 OADE 2010 beta on ubuntu 9.10. Is this bug or I'm not setting something right? Importing from postGIS works fine. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064088.html Sent from the gvSIG international mailing list archive at Nabble.com. _______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional ------ Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information. _______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
