Benjamin thank you, that solved the problem. Fields also have to be lover case.
On Mon, May 17, 2010 at 10:33 AM, Benjamin Ducke [via OSGeo.org] < [email protected]<ml-node%[email protected]> > wrote: > 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" <[hidden > email]<http://user/SendEmail.jtp?type=node&node=5064137&i=0>> > > To: "gvsig internacional" <[hidden > email]<http://user/SendEmail.jtp?type=node&node=5064137&i=1>> > > 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 > [hidden email] <http://user/SendEmail.jtp?type=node&node=5064137&i=2> > 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 > [hidden email] <http://user/SendEmail.jtp?type=node&node=5064137&i=3> > http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional > > > ------------------------------ > View message @ > http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064137.html > To unsubscribe from Re: gvSIG 1.9 error message: Can`t initialize writer: > POSTGIS Writer, click > here<http://osgeo-org.1803224.n2.nabble.com/subscriptions/Unsubscribe.jtp?code=YmVybm84NEBnbWFpbC5jb218NTA2NDA4OHw0NzA2MzkwNjc=>. > > > -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-9-error-message-Can-t-initialize-writer-POSTGIS-Writer-tp4419161p5064155.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
